I need to be able to pass parameters to a subreport sproc at run time, I would perfer session variables but I don't really care, just need to pass the variables.
Here is what I’m talking about. I need a report that shows Maintenance, Oil usage and Meter hours against Power Generators located at 15 different sites. The data needs to be filtered for what ever date range the user passes, usually a month . I don’t use a report viewer, just export the report directly to pdf and let the user save the report. They put a begin date and end date into two text boxes, and clicks the report button.
Main Report datasource is SqlDatasource with a Sproc, it returns Site Name and SiteID, No parameters, I want to see all sites data in this particular report.
Subreport 1 - Oil usage for that site. Table has fields SiteID, DateAdded, QuantityAdded
Parameters(@BeginDate, @EndDate)
Subreport 2 - Meter Hours for that site . Table has fields SiteID, ReadingDate, MeterReading
Parameters(@BeginDate, @EndDate)
Subreport 3 Maintenance performed
Parameters(@BeginDate, @EndDate)
How do I make this work with Telerik Reports??????
Right now I have hard coded the stored procedures as this is the first report I have created but next month I need to be able to provide the user with a way of filtering the report. I am in a real jam here. Any help would be greatly appreciated. Thanks