Using Crystal Reports and the Crystal Reports Web Server

[klewis]

I am working on a project that would allow users to &quot;customize&quot; the type of report they want to create based on information they entered. This project will be web-based. For the project, we are using Interbase, Cold Fusion and Crystal Reports. I now how to create a &quot;standard&quot; report by using the &lt;CFREPORT&gt; tag to pass parameters. However, What if the user wanted to choose multiple fields and want a report on that? For example, if the Zip Code field was a parameter, and they wanted a report that displayed both Zip code 11111 and 22222, How would I write could to accomadate both entries?<br><br>Also, the database has Stored procedures. Does anyone know how I would have the person enter a parameter and have that parameter entered into the stored procedure and then print the report?<br><br>Lastly, when the report comes back on the screen, how do I make it show up in landscape either when it is displayed on the screen or when they print it? <br><br>Thanks!<br><br>Kiesha<br><A HREF="mailto:kieshalewis@hotmail.com">kieshalewis@hotmail.com</A>

 

[skst]

Look at the crystal example of reportsvr.asp the Automation server demo. You can then access most of the objects easily as this asp creates an application and report object.

Using the report object you access the parameter fields in the report and load your parameters into them ie.

Session(&quot;oRpt&quot.ParameterFields(&quot;pv_start_date&quot.setcurrentvalue &quot;&quot; & Start_Date & &quot;&quot;
Session(&quot;oRpt&quot.ParameterFields(&quot;pv_end_date&quot.setcurrentvalue &quot;&quot; & End_Date & &quot;&quot;

The report is then opened and the stored proc attached to the report uses the loaded parameters.