Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing Variables to Crystal Reports

Status
Not open for further replies.

szeiss

Programmer
Joined
Apr 5, 2000
Messages
137
Location
US
I have the following code:

<td><A HREF=&quot;index.cfm?main=solicitations&sub=availlist&solicitation_id=#SOLICITATION_ID#&avail_list_rev_no=#AVAIL_LIST_REV_NO#&quot;</A><INPUT TYPE=&quot;Image&quot; SRC=&quot;images/btn_avail_list_rpt.gif&quot; ALT=&quot;Availability List Report&quot; ONCLICK=&quot;javascript:displayAvailListReport('reports/AvailList.rpt')&quot;></A></td>

I'm trying to pass the variables in the url to the Crystal Report Viewer (using CR 8.0 and actx viewer), which in turn will use the variables as criteria in the report. What am I doing wrong?

Thanks,
Sherry
 
If index.cfm passes the variables directly to the report, are you using the CR conventions for parameter names? Are you using the CFREPORT tag?

I usually call a report directly, like this:


<a href=&quot;myreport.rpt?prompt0=something&prompt1=somethingelse(etc.)>Get Report</a>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top