Passing Formula to Subreport
Posted on 2004-08-26
I have a problem.
I have a main report that has a Paramter Field "Year"
I have also two subreports which does a subreport link to the Parameter Field.
These subreports uses SQL Command and has parameter in the SQL query as "Reporting Year"
Now I want to modify the Parameter Field "Year" such that if I enter 2004, it will pass 2004 to the 1st subreport and 2003(Year-1) to the 2nd subreport.
I am able to use formula to do the subtraction but when I do a subreport link from this formula to the 2nd subreport, it does not show the 2nd subreport in the main report.
That is it is showhow hidden the whole 2nd subreport.
Is there a way to go about show both the subreports if I just enter 1 parameter field in the main report?