Report Type for pdf and Excel

[iccsi]

I have following code to generate the report for pdf format.

I would like to let users to choose report type 'pdf' or 'excel'

I need pass the user select from user interface to <cfreport format= "PDF" or "Excel".

Can you please advise how I can pass the user select Report Type from lsReportType to my cfReport?

Your help and information is great appreciated,

Regards,

Iccsi

<cfstoredproc procedure="spGetReportType">

   <cfprocresult name="rsReportType" resultset="1">

</cfstoredproc>

<cfreport format = "PDF" template= "MyReport.cfr" query="#myQuery#">

   </cfreport>

<td><select width="50" name="lstReportType" id="lstReportType">

      <cfoutput query="rsReportType">

         <option value="#rsReportType.ReportTypeID#" <cfif (isDefined("form.ReportTypeID") AND form.ReportTypeID EQ rsReportType.ReportTypeID)>selected="selected"</cfif>>#rsReportType.ReportType#</option>

       </cfoutput>

     </select></td>

[EddieLotter · Accepted solution]

Change format="PDF" to format="#VariableName#" where VariableName contains the text "PDF" or "Excel".