-
March 6th, 2014, 10:34 AM
#1
whileprinting
In a quandary, I have a record, prior to working on this record I need to run a subreport to share a number that will determine what becomes of the present record, based on that do whatever is determined, and proceed to the next record...till end of file.
Problem is the shared number produced by the subreport shows up a record late...iow, it acts on the next record not the one that it is called from.
Is there a way to do this or simply a limitation?
crystal 8.5
Last edited by leburg; March 6th, 2014 at 10:35 AM.
Reason: add info
-
March 10th, 2014, 09:37 AM
#2
Re: whileprinting
There are a few limits to CR, one is evaluation time. Not trying to overstate the obvious but you can't read a record before you read the record. Sometimes you can use multiple sub-reports, i.e. run the sub-report to determine you key value, read a record in the main report, then pass values from the first sub-report and the record to another sub-report to do the processing. Sounds a bit heavy. Another option is to build a stored procedure to do the work.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|