Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 161
  • Last Modified:

Print and Export in different Formats using Crystal 9 and CFMX

Hello
We're using Crystal Reports and would like to integrate it with our coldfusion application running under MS Server 2000 and CFMX with SQL Server 2000 in the backend. The reports should be called from coldfusion template or whatever possible workaround.

As I read in this topic area an expert called "Plucka" has a great solution to this, with cfml and a little bit of ASP.

It would be great if he or someone else can give or provide help.

Greetings
drtaut
0
drtaut
Asked:
drtaut
1 Solution
 
proceptCommented:
Hi,

you can run reports with <cfreport>:

<cfreport    
   report = "report_path"
   dataSource = "ds_name"
   type = "type"
   timeout = "number of seconds"
   orderBy = "result_order"
   username = "username"
   password = "password"  
   formula = "formula"></cfreport>


A few remarks: type is not valid for Crystal Reports 8.0 and dataSource is the Crystal Reports datasource, NOT the CF datasource. Check the CF documentation on <cfreport> for more details.

HTH,

Chris

0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now