Crystal has a IIS ISAPI snap in that needs to be used with the Web server.
----- Original Message -----
From: "Peter Janett" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 8:41 PM
Subject: Help sending data to Crystal Reports
> 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
