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: manojmisrasrm...@gmail.com On Sat, Mar 29, 2014 at 4:34 AM, Jerwyn Fernandez [via Koha] < ml-node+s1045719n5792600...@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.html > > 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-tp5792591p5792600.html > 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-tp5792591p5792647.html Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha