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.
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.