In the detail section ItemDataBinding event, I set one of those two controls to visible= true depending of a value in the data row.
This used to works fine in Q1 2009 but since I have upgraded the report to Q2 2009, when I set the CrossTable visible to true, the CrossTable does not appears anymore.
I have tried with Q3 2009 and it still does not work like it used to be.
Thanks
Frédéric
public RenewalList(int KeyPK) |
{ |
/// <summary> |
/// Required for telerik Reporting designer support |
/// </summary> |
InitializeComponent(); |
this.sqlDataAdapter1.SelectCommand.Parameters["@KeyPK"].Value = KeyPK; |
this.DataSource = this.sqlDataAdapter1; |
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