ASP.NET Session Variable used as parameter to report

[kaijanm]

Hello, I'm a complete newbie to Crystal Reports and I'm using the version that comes with VS.Net.

I (kind of) created a report that is based on a sproc on the SQL Server. The SPROC requires the customer ID to be passed to it. I have it stored in a Session Variable in my application.

How do I take the session variable and pass it as a parameter through the report?

Thank in Advance!
Kimberly

 

[synapsevampire]

There are lots on VS.NET Example reports here:

http://support.businessobjects.com/fix/samplescr.asp

You didn't mention what manguage you were using, but this has VB.NET, C++ and c#

-k

 

[randysmid]

Hi,
I am using the following code to retrieve a session variable, but be aware that I am pushing down the query to the database server so that the CR doesn't retrieve ALL the records in the database. In fact, I have a form that lets the user select the criteria, then I call the ASPX form that contains the report viewer. This code lives inside the PageLoad event:

'Retrieve parameter value entered in web form called....
' testCountySelectRegion.aspx
' the session variable is "CTARegion"
Dim strRegion As String
strRegion = Session("CTARegion".ToString)

I wrote an FAQ on the topic of passing criteria from a separate form to the ASPX form that contains the report viewer. You can find it at: faq766-5471


HTH,
Randy Smith, MCP
California Teachers Association