RE: NAV 5.1 - Classic Reports
Has anybody done any report develop. that prints a table of contents for a report listing items?
We print a simple customer products (items) catalogue grouped by Item Category then sub-grouped by Prod. Group, however, our customers have asked for a 'table of contents' that would print at beg. of report listing just the Item Categories and Product Groups with page #'s of where they are located in the report. This is a dynamic catelogue and will somtimes filter for only certain categories and/or prod. groups.
I would imagine you would have to run the report twice, the first time with no output then somehow store on a temp. table page # 's of there the cats/prod. groups start.
Has anybody done anything like this? Is there an external report tool (outside NAV) that does this autoamtically? Thanks.
0
Comments
What I do is export the report to WORD.
I have also created a separate word doc that contains all the things I want to Index (Product groups)
In word (my item report) I goto References->Insert Index->Automark then I choose my Index doc.
It runs thru the "item report" word doc and marks all the places in it that matches the values from the index doc.
I then place my cursor at the END OF THE DOC - THE LAST SPACE POSSIBLE
Then in "insert index" I select my format (usually->simple) set my columns and click OK.
You can show/hide the marks using in word (i usually hide them one done)
http://www.techf5.com/pic/2011/06/word- ... acters.png
You will get an index of all the groups and their page number.
Now if you wish you could copy & paste the results into a seperate new doc and create a PDF of the index. And if you also send your customers or whomever a PDF of your item list, then you can use BULLZIP pdf creator to merge the files together putting the index first and a cover page if you want.
I've been doing it this way for years and it only takes a few minutes once you get the hang of it.
http://www.BiloBeauty.com
http://www.autismspeaks.org
http://www.youtube.com/watch?v=7Gzbjpmk ... e=youtu.be
let me know if you have any issues
http://www.BiloBeauty.com
http://www.autismspeaks.org