Passing Paramter through Hyperlink

[veeru75]

I am passing parameter through hyperlink, Like

http://Crystal/MainReport.Rpt?prompt0={Agency.PFS_Number}.

The Agency.PFS_Number is the database field. I wanted to pass this value to the Sql Query. How to get the value from hyperlink, Pass the Value to Sql Query.
Please help me.

Thanks in advance.

 

[LV]

You are using Web Componenet Server now.
If you want more control, such as accessing report properties, you need to use Report Designer Component(CRAXDRT.DLL) and call your report through ASP code.
Take a look at the Seagate Samples (is you intalled them with Crystal). Open the browser, type //localhost/scrsamples
and click on ASP samples. I think there is a sample of how to access SQLQuery property. If you don't find it, those exaples can be downloaded from Seagate site. Look for aspxmps8.zip or .exe