https://forums.adobe.com/community/coldfusion/coldfusion_reporting?view=discussions Most recent forum messages en Tue, 02 Sep 2014 16:23:03 GMT Jive Engage 7.0.0.1 (http://jivesoftware.com/products/) 2014-09-02T16:23:03Z en https://forums.adobe.com/message/6694411?tstart=0#6694411 <!-- [DocumentBodyStart:dae0f91b-14f2-48b9-bcae-77d1f6498c97] --><div class="jive-rendered-content"><p>Change <strong>format="PDF"</strong> to <strong>format="#VariableName#"</strong> where <em>VariableName</em> contains the text "PDF" or "Excel".</p></div><!-- [DocumentBodyEnd:dae0f91b-14f2-48b9-bcae-77d1f6498c97] --><img src='/beacon?t=1415918206838' /> Tue, 02 Sep 2014 16:23:03 GMT forums_noreply@adobe.com https://forums.adobe.com/message/6694411?tstart=0#6694411 2014-09-02T16:23:03Z 2 months 2 weeks ago 0 https://forums.adobe.com/message/6675653?tstart=0#6675653 <!-- [DocumentBodyStart:c54094ee-c023-460f-9999-8a558ec6296d] --><div class="jive-rendered-content"><p>I have following code to generate the report for pdf format.</p><p>I would like to let users to choose report type 'pdf' or 'excel'</p><p>I need pass the user select from user interface to &lt;cfreport format= "PDF" or "Excel".</p><p>Can you please advise how I can pass the user select Report Type from lsReportType to my cfReport?</p><p style="min-height: 8pt; padding: 0px;">&nbsp;</p><p>Your help and information is great appreciated,</p><p style="min-height: 8pt; padding: 0px;">&nbsp;</p><p>Regards,</p><p style="min-height: 8pt; padding: 0px;">&nbsp;</p><p>Iccsi</p><p style="min-height: 8pt; padding: 0px;">&nbsp;</p><p style="min-height: 8pt; padding: 0px;">&nbsp;</p><p>&lt;cfstoredproc procedure="spGetReportType"&gt;</p><p>&nbsp;&nbsp; &lt;cfprocresult name="rsReportType" resultset="1"&gt;</p><p>&lt;/cfstoredproc&gt;</p><p style="min-height: 8pt; padding: 0px;">&nbsp;</p><p style="min-height: 8pt; padding: 0px;">&nbsp;</p><p> &lt;cfreport format = "PDF" template= "MyReport.cfr" query="#myQuery#"&gt;</p><p>&nbsp;&nbsp; &lt;/cfreport&gt;</p><p style="min-height: 8pt; padding: 0px;">&nbsp;</p><p> &lt;td&gt;&lt;select width="50" name="lstReportType" id="lstReportType"&gt;</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;cfoutput query="rsReportType"&gt;</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;option value="#rsReportType.ReportTypeID#" &lt;cfif (isDefined("form.ReportTypeID") AND form.ReportTypeID EQ rsReportType.ReportTypeID)&gt;selected="selected"&lt;/cfif&gt;&gt;#rsReportType.ReportType#&lt;/option&gt;</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/cfoutput&gt;</p><p>&nbsp;&nbsp;&nbsp;&nbsp; &lt;/select&gt;&lt;/td&gt;</p></div><!-- [DocumentBodyEnd:c54094ee-c023-460f-9999-8a558ec6296d] --> Tue, 26 Aug 2014 18:09:36 GMT forums_noreply@adobe.com https://forums.adobe.com/message/6675653?tstart=0#6675653 2014-08-26T18:09:36Z 2 months 3 weeks ago 1 0