Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

pass url parameter to cfreport

New Here ,
Apr 13, 2011 Apr 13, 2011

I am using CF9 and have generated a report using CF Report Builder that has a report parameter that function correctly.

I am trying to be able to get the variable value from the the address line and then display the cooresponding report page.

I have set a default value in report builder and written a simple viewing cfm. 

<cfreport template="NC_ImpactReport.cfr" format="pdf">

<cfreportparam name= "CFVarProjectID" value=55>

</cfreport>

When I run this I get the report returned correctly for record '55'

http://website/nc_impactreport.cfm

Another program will have the hyperlink (http://website/nc_impactreport.cfm) with the selected record id(ie55) all on one line.

How do I get the variable value from the address line into the cfm correctly to pass it into the report?

Thanks,

Kurt

TOPICS
Reporting
1.5K
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advocate ,
Sep 17, 2013 Sep 17, 2013
LATEST

If your URL is "http://website/nc_impactreport.cfm?id=55" then your cfreportparam line should be:

<cfreportparam name= "CFVarProjectID" value="#URL.id#">

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources