sql reporting

[Wolfgang Flieger]

Hello everybody,
is it possible to load session values to a report?
I would like to combine them with the text from the database. For example:
session("he")="John"; text from the database: "is smart".
Text on the report should be so: "John is smart"
How to implement it?
Thanks
Wolfgang

 

[Paul Shapiro]

You can add a parameter to the report, in your case a string parameter, and
then specify the parameter value in the Page_Load event. In the report I
defined a parameter named UnsubmittedPaperCount, and then used that
parameter in a text box value property:
=Parameters!UnsubmittedPaperCount.Value & " unsubmitted abstracts."

Here's the Page_Load code:
//Pass the count to the report parameter, so it can be
displayed.
ReportParameter p = new
ReportParameter("UnsubmittedPaperCount",
unsubmittedPaperCount.ToString());
this.ReportViewerStatisticsByDay.LocalReport.SetParameters(new
ReportParameter[] { p });