Dont know if this will help.. In the past I have used formulas instead of parameters to very good effect. Jared Clinton. > -----Original Message----- > From: Brian Thornton [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 5 April 2001 13:45 > To: CF-Talk > Subject: Re: Help sending data to Crystal Reports > > > 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\bydued > ate.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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
