Greetings Programs!

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

Help Please :)

This should probably go under a Crystal forum, but I'll give it a try. I am assuming that you are either using Crystal Enterprise or Crystal Report Designer Component (RDC). If the latter you could try creating a parameter in the report and passing the argument as such...

Session("oRpt").ParameterFields.GetItemByName("MyP arameter").AddCurrentValue(cStr(sqlSelectString))

MyParameter being your Crystal parameter and sqlSelectString being the value of your select string. Then you should be able to call it from anywhere in the report.