Results 1 to 1 of 1
May 23, 2005, 12:48 #1
- Join Date
- Sep 2004
- my house
- 0 Post(s)
- 0 Thread(s)
Passing a Virtual Variable from ASP to Crystal 9
I have an ASP page where I input values that will be used as criteria for a Crystal version 9 report. The SQL statement is generated dynamically based on a load of conditional statements. It works Great! The report responds within the Viewer and displays the correct data set based on the users selected criteria. I can display the SQL statement that I store in a variable called selectstring on the asp page that has the viewer.
Example: session("oRpt").SQLQueryString = selectstring
My Issue is that I want to be able to Display the selectstring value "On The Report Header" of the Crystal report.
How do I do this? I tried several way of doing it, but I can't seem to get it to display on the Crystal report. I know the report sees the SQL statement, otherwise it would not return the correct record set, in fact it probably wouldn't return anything.
How can I pass the value of my asp selectstring variable into a variable that I can use within crystal