February 17, 2011 at 8:03 am
I have a report which has a chart(sub report embedded in it)
The main report has dataset1 , takes a parameter @year from the user and pulls up the report.
I want the @year parameter value to be passed to the sub report as well in order to pull up the correct data ...how can I do that...
eg: sub report has the SQL : select * from tbl1 where ...
the sql should be able to take select * from tbl1 where ...and year =@year...
February 18, 2011 at 7:39 am
The sub report needs to be looking for a parameter @Year. In other words the @Year parameter has to be built natively into the sub report.
February 18, 2011 at 7:55 am
the main report has a parameter @year and asub report also has a parameter @year . I am not sure how to link them...
When the sub report is run indicudually , it asks for the year and generates the report , however I want the parameter entered in the Main report to be supplied to the sub report as well...
February 18, 2011 at 8:44 am
In the report, right click on the box for the sub report go to Subreport Properties, go to Parameters and add your parameter there.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply