<?xml version="1.0"?> |
<configuration> |
<configSections> |
<section name="Telerik.Reporting" type="Telerik.Reporting.Processing.Config.ReportingConfigurationSection, Telerik.Reporting.Processing, Version=3.1.9.701, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" allowLocation="true" allowDefinition="Everywhere"/> |
</configSections> |
<Telerik.Reporting> |
<Extensions> |
<Render> |
<Extension name="IMAGE" visible="false"></Extension> |
<Extension name="HTML" visible="false"></Extension> |
<Extension name="MHTML" visible="false"></Extension> |
<Extension name="XLS" visible="true"></Extension> |
<Extension name="CSV" visible="false"></Extension> |
<Extension name="PDF" visible="true"></Extension> |
</Render> |
</Extensions> |
</Telerik.Reporting> |
</configuration> |
Dear Telerik Support,
Is there a way to programmatically uncheck the Isnull checkbox on a report parameter?
Please advise,
Woody
public partial class My_Report : Telerik.Reporting.Report
{
public My_Report()
{
InitializeComponent();
this.DataSource = null;
this.NeedDataSource += new System.EventHandler(this.My_Report_NeedDataSource);
}
private void My_Report_NeedDataSource(object sender, System.EventArgs e)
{
//Transfer the ReportParameter value to the parameter of the select command
this.sqlDataAdapter1.SelectCommand.Parameters["@PersonID"].Value = 8;
this.sqlDataAdapter1.SelectCommand.Parameters["@OperatorID"].Value = 11;
//Take the Telerik.Reporting.Processing.Report instance and set the adapter as it's DataSource
Telerik.Reporting.Processing.
Report report = (Telerik.Reporting.Processing.Report)sender;
report.DataSource =
this.sqlDataAdapter1;
}
}
I have each of my fields in a table referencing in this manner:
=Fields.TaskNumber
I do no receive any errors or anything, so I am looking for some guidance.
Thanks, Mike
More info:
When I added this to my NeedDataSource method:
this.sqlConnection1.Open();
int rows = this.sqlSelectCommand1.ExecuteNonQuery();
rows returns -1, so I am somehow not getting any data back. I removed the parameters from the sproc and just hardcoded them and I still get a return value of -1 in rows. Any ideas?
Dim objMainReport As Telerik.Reporting.Report = New RequestsByDate()
objMainReport.DataSource = dsTemp.Tables(0) '-- table is available here
ReportViewer1.Report = objMainReport
ReportViewer1.DataBind()
I know that it is probably something to do with my RequestsByDate class, but I really have no clue. Any help would be appreciated.
Thanks in advance,
Mark