how to get dynamic reports

[Y L]

Hello there,

So now my project can produce reports successfully, what I want to do is when users select different calendars, they will see different reports which have the events selected from the different calendars.  I use Request.Cookies("checkedCalendars").Value in my web application code. How can I pass the cookie "checkedCalendars" to my Report.Designer.vb file, in which i  have
Me.SqlDataSource1.SelectCommand = "SELECT  Subject, Start, [End], aLocation" & Global.Microsoft.VisualBasic.ChrW(13) & Global.Microsoft.VisualBasic.ChrW(10) & "FROM  tblActivities WHERE aCalendarID IN ("checkedCalendars") ;"  ?

How can i do this?

Thank you very much.  

[Steve]

Hello Y L,

You can use the Report Parameters for such scenarios. More information is available in the Using Report Parameters programmatically.

Kind regards,
Steve
the Telerik team

[Y L]

Thank you Steve.

I checked the links you mentioned. However, I don't think they are quite similar to my case. In my project, I'm trying to pass Request.Cookies("checkedCalendars").Value which is in my .aspx.vb file   to my Report.Designer.vb file, in which i  have
Me.SqlDataSource1.SelectCommand = "SELECT  Subject, Start, [End], aLocation" & Global.Microsoft.VisualBasic.ChrW(13) & Global.Microsoft.VisualBasic.ChrW(10) & "FROM  tblActivities WHERE aCalendarID IN ("here should be the cookie checkedCalendars") ;"

Any help will be appreciated.

.
 

[Steve]

Hi Y L,

The solution is straight-forward:

Me.SqlDataSource1.SelectCommand = "SELECT  Subject, Start, [End], aLocation" & Global.Microsoft.VisualBasic.ChrW(13) & Global.Microsoft.VisualBasic.ChrW(10) & "FROM  tblActivities WHERE aCalendarID IN FormatArray(DirectCast(Me.ReportParameters("checkedCalendarsReportParameter").Value, ArrayList)) + ") "

where FormatArray is a user function that separates the multiple values. You can see this function in our ProductLineSales demo report (should open the Visual Studio examples and the actual report to see the code).

Additionally, since Q2 SP1 2010, we handle multivalue report parameters as Value for SqlDataSourceParameters internally, so you might want to setup this through the report designer in the same manner the chart items in the ProductLineSales report are bound.

All the best,
Steve
the Telerik team