What do people use to out put live reports to the web

[yogi564]

hi all

can somebody help me out.
What do people use to output live report using cold fusion. I tried to use <cfreport> tag, it doesn't like it one bit at all! It come up with stupid errors. thank's

 

[tlhawkins]

Hi Yogi,

I usually use Crystal Reports.

the <cfreport> tag is for interfacing CF with Crystal Reports. You need to have Crystal reports make a report then you send the name of the report with

<cfreport report=&quot;\path\report.rpt&quot;>
you can send options in here...
</cfreport>

there is a lot more to it then that. But first you need Crystal Reports to make the report.

hope it helps...

 

[yogi564]

hi tlhawkins

I have done all that kind of things you told me to do. This is the error it comes up with.

In CF code, we have:

<cfreport report=3D&quot;c:\\Inetpub\

http://wwwroot\myreport.rpt&quot;>

</cfreport>

-----------------------------The error message :----------------

Error Diagnostic Information
Error occurred while processing CFREPORT


An unexpected error occurred while using the Crystal Engine.

Error number 692 ocurred (Error in File C:\Inetpub\

http://wwwroot\myreport.rpt:

=
Invalid export DLL or export format.).

Crystal Library =3D C:\WINNT\system32\CRPE32.DLL (1/28/2000 4:16)=20
DLL Version =3D 8.0, Engine Version =3D 8.0


The error occurred while processing an element with a general identifier =
of (CFREPORT), occupying document position (1:1) to (1:84) in the =
template file C:\Inetpub\

http://wwwroot\mycfreport.cfm.

Can you help me solve this problem Otherwise can you give your url of a working <Cfreport> example. Thank's

 

[tlhawkins]

Hmm.. that's a messy error message.

The only time I've seen an error message like that with crystal reports it was a bad install. You may want to try re-installing crystal reports.

I've never had much trouble with it, but I haven't used it that much either.

Here is a link to what Allaire says about it:

http://www.opensesame.com/documents...09_Selecting_and_Presenting_Data/dwa09_10.htm

I know it's long...

Hope it helps.

 

[Silvano]

this looks as incorect path to me:

<cfreport report=3D&quot;c:\\Inetpub\

http://wwwroot\myreport.rpt&quot;>

</cfreport>

try this:

<cfreport report=&quot;c:\Inetpub\

http://wwwroot\myreport.rpt&quot;>

</cfreport>

or even just relative path:

<cfreport report=&quot;myreport.rpt&quot;>
</cfreport>


Sylvano
dsylvano@hotmail.com

 

[yogi564]

Hi wwebspider

I tried both the option long time ago, you mentioned and I still get the below error.

Crystal Library =3D C:\WINNT\system32\CRPE32.DLL (1/28/2000 4:16)=20
DLL Version =3D 8.0, Engine Version =3D 8.0

I don't what the heck is going on! There should be another way to this kind of stuff. When I tried the <cflocation> tag to work the report, it seems to open the report ok. there should be some kind of bug in the CFREPORT tag.