I am using Visual Studio 2005 Professional Edition [ASP.NET with C#].
I have a Crystal Report with a column is shown as a hyperlink. On clicking any hyperlinked value of any row, another report should open but I have three issues to be addressed:
The URL of the second report should be handled via Server.Transfer method to hide the page name from the URL.
The hyperlinked text, where the user has clicked to open second report, should be passed to the second report.
The second report is connected with SQL command as database back-end. I want to pass a Session value as a parameter to the SQL command being used by the second report.
To dynamically construct a querystring, edit the conditional formula that is associated with the field's Hyperlink infomation (right click field; Format Field...; Hyperlink tab). It might resemble:
//change to reflect your situation
"http://server:port/resource/redirect.aspx?reportname=" + [report name here] + "&token=" + [logon token here]
If you are using BusinessObjects Enterprise, you may want to investigate URLReporting.