Solved

Print and Export in different Formats using Crystal 9 and CFMX

Posted on 2003-10-29
3
151 Views
Last Modified: 2013-12-24
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
Comment
Question by:drtaut
3 Comments
 
LVL 4

Accepted Solution

by:
procept earned 250 total points
ID: 9641651
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

Superior storage. Superior surveillance.

WD Purple drives are built for 24/7, always-on, high-definition security systems. With support for up to 8 hard drives and 32 cameras, WD Purple drives are optimized for surveillance.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure (http://www.axure.com/). It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
The purpose of this video is to demonstrate how to make a WordPress Site faster and smaller in size by cleaning up the database. This will be demonstrated using a Windows 8 PC. Plugin WP Optimize will be used. Go to your WordPress login page. T…
The purpose of this video is to demonstrate how to Import and export files in WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Click on Too…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now