Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing Data from Sub report

Status
Not open for further replies.

sjdbmc

IS-IT--Management
Jan 30, 2004
14
GB
I have created a query with returns 2,000 records approx from one table.

I have created a subreport for each record which is linked to the main report and returns a SURVEY activity and a date.

I now want to pass the date value back to the main report using StoreDateVar and FetchDateVar.

I have succeeded in getting values returned to the main report but they are for the previous record. The output is as follows:-


Job No. Subreport Date Passed to Main Report
999999 Survey 12/03/2004
999999 Survey 13/03/2004 12/03/2004
999999 13/03/2004
999999 13/03/2004

If they is no value in the sub report it returns the last date where there was one.

Then whole point is to then suppress the main report where no date is returned.

I am using CR v6.

I hope the above makes sense.


 
You have to put the formula to display the value from the subreport in a section below the subreport. I usually put in another group with the sub report in the group header. Then in the details section I can reference the value from the sub report. Does that answer you question.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top