While printing records

[cmp119]

I created a report that accesses two views. The first view has most of the data needed in the report. The second view is necessary to pull data not available in the primary view. When it reads the records in the second view it prints a copy each time it reads a record. It should only print one page per record, instead it prints a page each time it loops in the second view. How can I force it to print one page per record based on the primary view? I hope I explained it clearly.

Let me clarify a bit, just in case. The primary view is based on a case number 123456, and it is linked to the second view using the case number. However, view two has specific information that requires it to loop several times to find specific information. Each time it loops it prints a copy instead of just skipping it until it finds the specific information and prints a page.

Thank you for any type of input.

 

[Drus]

What is "While Printing Records" used for? I have a subreport I am trying to pass a value from. It seems to not pass the value due to the record falling within the last sequence.

Detail Records
100-00 pass-through works fine.
100-99 pass-through does NOT work.

&ru

 

[synapsevampire]

You should start a new thread as opposed to piggybacking on an old one.

When doing so, try to avoid the urge to describe requirements with text, post technical information:

Crystal version
Database/connectivity used
Example data
Expected output

And avoid using phrases like "It seems to not pass the value due to the record falling within the last sequence." A sequence isn't a technical term and will immediately receive a response for clarification, as in, does that mean on the last row, or the last iteration of a grouping, or?

whileprintingrecords tells Crystal to process this formula at the last pass, Crystal uses a 3 pass system:

BeforeReadingRecords
WhileReadingRecords
WhilePrintingRecords

Hit F1 in Crystal to learn more about this.

-k

 

[synapsevampire]

I should have said that Crystal says to process whileprintingrecords on the second pass, although sometimes the second is the last, here's a doc to help you understand:

http://www.businessobjects.com/prod...nlineHelp/html/crconreportprocessingmodel.htm

-k