Dear Friends, Is there no way we can do it by SQL Command in report writing. *Regards!* *Manoj Kumar Misra* M.Phil., M.L.I.Sc., B.L.I.Sc., M.Sc.(Phy), B.Sc. (P.C.M.) Deputy Librarian SRMGPC Lucknow Mob. No.: 09415422579 Alternate E-mail: manojmisrasrmgpc@gmail.com On Sat, Mar 29, 2014 at 4:34 AM, Jerwyn Fernandez [via Koha] < ml-node+s1045719n5792600h71@n5.nabble.com> wrote:
Hi Manoj,
Maybe what you are try to say, you want to export your generated report arranged by barcode? Am I right?
In that case you may edit your data through excel.
*Steps*
Step 1
Highlight the whole column of the "barcode"
Step 2
click cnrt+H
Step 3
Find what = A Replace with = *note leave it blank
click Replace All
(so that you can remove the "A" symbol)
Step 4
Go to *Data* and sort your column to A - Z
Step 5
Make a new column beside the barcode column
then type ="A"&(the column with the number 1) then press enter
and then drag the formula to put A back
Regards,
- Jerwyn
On Sat, Mar 29, 2014 at 12:20 PM, manoj382093 <[hidden email]<http://user/SendEmail.jtp?type=node&node=5792600&i=0>>wrote:
Dear Friends, I have used alphabets in barcode numerbers for different item types, now when i have generated the accession register sorted by barcode it sort like A1, A11, A12, A21.. etc instead of A1,A2,A3,A4.....
Please help!
Manoj Kumar Misra
-- View this message in context:
http://koha.1045719.n5.nabble.com/Sorting-of-accession-numbers-tp5792591.htm...
Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org [hidden email] <http://user/SendEmail.jtp?type=node&node=5792600&i=1> http://lists.katipo.co.nz/mailman/listinfo/koha
-- Jerwyn G. Fernadez Basic Education Librarian Southville International School and Colleges _______________________________________________ Koha mailing list http://koha-community.org [hidden email] <http://user/SendEmail.jtp?type=node&node=5792600&i=2> http://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------ If you reply to this email, your message will be added to the discussion below:
http://koha.1045719.n5.nabble.com/Sorting-of-accession-numbers-tp5792591p579... To unsubscribe from Sorting of accession numbers, click here<http://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=5792591&code=bWFub2prdW1hcm1pc3JhQGdtYWlsLmNvbXw1NzkyNTkxfC0xMDkzNzg1MDg0> . NAML<http://koha.1045719.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
-- View this message in context: http://koha.1045719.n5.nabble.com/Sorting-of-accession-numbers-tp5792591p579... Sent from the Koha-general mailing list archive at Nabble.com.