A friend posted this on another list, and I figured someone here could help:
I'm using Cold Fusion 4.5, Crystal Reports 8.5. I cannot determine how to
pass multiple parameters to a .rpt file when they are entered via a form.
Example Snippet:
<CFREPORT
REPORT="D:\giweb-online\site\reports\gagesdue\byduedate\byduedate.rpt"
DATASOURCE="Gage InSite" TYPE="Microsoft" username="GI" password ="GI">
<CFOUTPUT>
<cfif '#FORM.company#' IS NOT "">
{Gages.Company} = '#FORM.company#'
</cfif>
<cfif '#FORM.department#' IS NOT "">
{Gages.Department} = '#FORM.department#'
</cfif>
<cfif '#FORM.gage_type#' IS NOT "">
{Gages.Gage_Type} = '#FORM.gage_type#'
</cfif>
</CFOUTPUT>
</CFREPORT>
Results:
- If company and gage_type are passed to the CFM page, only gage_type gets
pushed to the report.
- If company and department are passed to the CFM page, only department gets
pushed to the report.
----------------------------------------------------------------------
Hardcoded values:
<CFREPORT
REPORT="D:\giweb-online\site\reports\gagesdue\byduedate\byduedate.rpt"
DATASOURCE="Gage InSite" TYPE="Microsoft" username="GI" password ="GI">
<CFOUTPUT>
{Gages.Company} = 'ABC COMPANY'
{Gages.Gage_Type} = 'CALIPER'
</CFOUTPUT>
</CFREPORT>
Result: Out of Memory Message
----------------------------------------------------------------------
Adding Semicolons clears the memory error:
<CFREPORT
REPORT="D:\giweb-online\site\reports\gagesdue\byduedate\byduedate.rpt"
DATASOURCE="Gage InSite" TYPE="Microsoft" username="GI" password ="GI">
<CFOUTPUT>
{Gages.Company} = 'ABC COMPANY';
{Gages.Gage_Type} = 'CALIPER';
{Gages.Gage_SN} = 'BCD110';
</CFOUTPUT>
</CFREPORT>
Result: In this case BCD110 is found... but if we do this:
<CFREPORT
REPORT="D:\giweb-online\site\reports\gagesdue\byduedate\byduedate.rpt"
DATASOURCE="Gage InSite" TYPE="Microsoft" username="GI" password ="GI">
<CFOUTPUT>
{Gages.Gage_SN} = 'BCD110';
{Gages.Company} = 'ABC COMPANY';
{Gages.Gage_Type} = 'CALIPER';
</CFOUTPUT>
</CFREPORT>
All the calipers are found.
----------------------------------------------------------------------
I am left assuming only one paramter (the last in the list) is sent to
crystal reports.
Basically, I have a form with about 20 optional fields and I need to pass
form data into the report for custom lookups based on what they enter. I've
tried CFIF, no CFOUTPUT, yes CFOUTPUT, Variables, IsDefined... blah blah
blah. I've gone through Allaire, Macromedia, Google, Altavista, Seagate
Software, etc ad nauseum and have yet to find anything beyond this simple
kind of example:
<CFREPORT
REPORT="D:\giweb-online\site\reports\gagesdue\byduedate\byduedate.rpt">
{Gages.Company} = '#FORM.company#'
</CFREPORT>
So I'm stuck.
--------------------------------------------
Thanks,
Peter Janett
New Media One Web Services
================================
WEB HOSTING FOR WEB DEVELOPERS
================================
Sun, IRIX, Windows 2000, Linux;
PHP, MySQL, Perl, Cold Fusion,
MS SQL, ASP, SSI, SSL
http://www.newmediaone.net
[EMAIL PROTECTED]
(303)828-9882
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
