troubleshooting Question

Need CR 10 to auto-generate line numbers

Avatar of curtwade
curtwadeFlag for United States of America asked on
Crystal Reports
2 Comments1 Solution444 ViewsLast Modified:
Basic question: Can CR 10 auto-generate line numbers?  But it's more comlicated....

We have an application which generates a report in CR 10 and converts the report from PDF format to text (PDF2TXT) for import into other applications.  The report has a header section, multiple sub-reports and a footer section.  At times, the PDF2TXT conversion drops data which appear in the PDF formatted report - or perhaps generates a PDF line multiple times - and we are looking for an automated method to "flag" such ommissions or additions.  (Yes, we are looking into the report formatting and the PDF2TXT.DLL which are causing these issues.)

Here's my theory:

1. Have CR auto-generate line numbers to the far left (e.g., like "legal documents" require) and sum all these numbers.  Example (no report will ever have more than 9,999 lines):

   0001 This is the first line of text (perhaps from the header)
   0002 This is the next line (perhaps from a sub-report)
   0003 This is another line  (perhaps from the same or a different sub-report)
   0004 There may be blank lines which need to be counted
   0005 This is the "last line" (from the report footer)
   0015 This is the "checksum total" of all the above lines

2. Before the converted text version of the report is imported into the "other applications", it makes a brief stopover at an "interface engine" which can count all the lines of text received, sum them, and compare these values to the "last line" and "checksum total" generated by the CR in PDF format.  If both match, the line numbers are stripped from the report and it is sent on it's merry way.  If they do not match, well, we'd find a way to deal with them (but that's not the point of this question).

Is such auto-generated line numbering available in CR 10 in a report with a header section, multiple sub-reports and a footer section?

Thanks,
Curt

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros