C1 Community

I have a report with two subreports. One – use Two parameters = Beginning Date and Ending Date and other is Summary report, so he used only Ending Date.
Summary report seems to work properly as a stay along report but returns wrong data as subreport. And lay out for Summary report doesn’t work properly as well.

And other question – may I use SQL statement, table .. for parameters (non date), not hard coded ones using Report Designer?

<pvictoria> wrote in message news:183740@test.componentone.com...

I have a report with two subreports. One – use Two parameters = Beginning Date and Ending Date and other is Summary report, so he used only Ending Date.
Summary report seems to work properly as a stay along report but returns wrong data as subreport. And lay out for Summary report doesn’t work properly as well.

And other question – may I use SQL statement, table .. for parameters (non date), not hard coded ones using Report Designer?

---

http://home.componentone.com/cs/forums/183740/ShowPost.aspx

Hi i'm also having the same problem.

I have a report which contains several subreports, some of them summary graphics, some others details. I need all the reports in their datasource have the same values for the specified parameters in the master report (starttime, endtime). At DB level, the reports execute different stored procedures but all with the same two input parameters.

The problem is... i'm assigning via code the parameters for the master report and works fine, but for the subreports, they take the hard coded values used in their own built datasource and not the ones for the master report. Is there any way to pass the subreports the same parameters as the main report?? this has to be done by code or script in the designer?? Also, how do i set the same connection string for all the subreports to be the same as the master report?? I'm using C1WebReport and C#

 Examples:

 Datasource MasterReport:

 PARAMETERS starttime date '10/31/2007',  endtime date '11/05/2007';
sp_desca_agent_log_activity_graphic(starttime, endtime)

Datasource Subreport1:

PARAMETERS starttime date '10/31/2007',  endtime date '11/05/2007';
sp_desca_agent_log_activity(starttime, endtime) 

 Any help would be appreciated ASAP. I Included some of the reports i'm developing.

Hi,

I suggest taking a look at the following links.  They may help you with your situation.

http://helpcentral.componentone.com/CS/forums/p/46081/129375.aspx#129375

http://helpcentral.componentone.com/CS/forums/p/67989/184909.aspx#184909

http://helpcentral.componentone.com/CS/forums/p/44062/122756.aspx#122756

Hope those help,
~Greg

Hi, thanks so much for yor help... it works ok if i pass it through .net code, but not as an embedded script on the report... i tried putting this in the OnFormat value in the footer section (which has the subreport field)

SubReport1.subreport.datasource.recordsource = "sp_desca_agent_log_activity(#" & starttime & "#,#" & endtime & "#)"

 When i run the report using the report designer runs ok as i could see in the sql profiler. But when i run it in my app i have the same problem i had before. I didn't want to assing this recordset through code because of supporting issues, it's better if i could assign it directly in the report. Am i doing something wrong? because is the same sentence i used in code with no problem or is someking of a bug?

This is the C# code put in the page

cwr.Report.Sections.Footer.Fields["SubReport1"].Subreport.DataSource.RecordSource = "sp_desca_agent_log_activity(#" + starttime + "#,#" + endtime + "#)";