Print Page | Close Window

Report data residing in multiple records issue

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13175
Printed Date: 20 Apr 2025 at 7:31pm


Topic: Report data residing in multiple records issue
Posted By: claymohr
Subject: Report data residing in multiple records issue
Date Posted: 11 May 2011 at 10:05am
Hi all -

I have been digging through the forums and can't find anything like this problem so far... I'm pretty much a CR n00b.

I have an Oracle file that has records written to it for a single report to be generated.

I'm finding that 1 record contains about 95% of what I need, but 3 or 4 or 5 other, mostly blank, records will also get generated that contain 1 or 2 important fields of data I need as well.

I'm thinking I need to create a variable and somehow loop through the records until I find the mostly blank record that contains the info I need and save it to a variable for print time.

Is this the easiest way to do this or is there another way to easily consolidate information?

Thanks in advance for any help.

-C


Replies:
Posted By: lockwelle
Date Posted: 18 May 2011 at 3:46am
if it is all in the same group, you could probably do that, suppressing the details and displaying the results in the group footer...but cr doesn't allow you to just loop through the data in a controlled way. 
 
If you have a middle tier in your app, you can use that to do the looping and build a recordset of what want and pass it to CR...
 
or you could use a stored proc...but since it sounds like you are already getting a file, I would try the middle tier approach first as it will be the most flexible.
 
HTH


Print Page | Close Window