cfreport and Crystal Reports
about 6 years ago i create a custom tag to envoke a Crystal Report. At the time CF and CRW as is would produce an HTML CR not a real CRYSTAL REPORT to be dumped to the printer. Does the current version of CF allow you to create a real CR or is is still HTML? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241557 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfreport and crystal reports
Is there a way to dynamicly pass the name of the database file that you want the crystal reports report you are calling to use? I have one report, but I want it to be able to pull from any number of different databases. So far, I haven't been able to figure out how to do this. Does anyone know, or have any good links on this sort of thing? Todd Ashworth -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFreport and crystal reports
Hi, Mike!
I had a posting a month ago about CR8 and the problems I have. You wrote
that you didn't have any problem using it, so I would like to know how you
are implementing the reports. Here is the .cfm template that I'm using to
open the report in a new window. I got the template with recrystallize. The
problem is that with CR8 - sometimes it opens, sometimes it doesn't and
gives the error "Error detected in database dll". But, even if it opens, the
cookies that I had created with the EXPIRES="NEVER" are gone. Could you,
please, tell me how you are calling the reports and have you tried this
cookie expiring thing?
Thank you in advance,
Lena Trajkovska
P.S. This code is working great with CR7, on NT4 with CF4.0.1 Enterprise,
Oracle 8.
!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
html
head
LINK REL="StyleSheet" HREF="../../../../styles/form.css" type="text/css"
meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"
meta name="GENERATOR" content="ReCrystallize Web Publishing Wizard for
Seagate Crystal Reports 2.3.1"
title Konten plan/title
SCRIPT
function decode( valstring ) {
var resultstring = ""
for (var p=0; p valstring.length - 1; p +=2) {
tmp = '%' + valstring.charAt(p) + valstring.charAt(p + 1)
resultstring += unescape( tmp )
}
return resultstring
}
function validateandsubmit( f ) {
document.parmform.user0.value = decode( document.parmform.user0.value )
document.parmform.password0.value = decode(
document.parmform.password0.value )
window.open( '', 'reportviewerwindow',
'toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,re
sizable=yes');
document.parmform.submit()
}
/SCRIPT
/head
body
CFform action="ADFN060100.rpt" method="POST" name="parmform"
target="reportviewerwindow"
input type=hidden name="init" value="actx"
input type=hidden name="promptOnRefresh" value=1
input type=hidden name="user0" value="697A76657374616A"
input type=hidden name="password0" value="697A76657374616A"
cfoutput
input type=hidden name="prompt0" value="#cookie.ckompanija#00"
/cfoutput
CENTER
brfont face="" class="tekst"Konten plan/fontbrbr
INPUT TYPE="BUTTON" class="tekst" VALUE="Pogled na izve{tajot"
style="width: 90%" onClick="validateandsubmit(this.form)"
/center
/CFform
/body
/html
-Original Message-
From: Hales, John M [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2000 17:18
To: CF-Talk
Subject: RE: CFreport and crystal reports
I could never get it to work. We just use CF to pass the parameters to
Crystal, and the CR Web Server to display the reports. That works well for
us.
HTH
Mike Hales
-Original Message-
From: Katie Bessiere [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2000 11:08 AM
To: CF-Talk
Subject: CFreport and crystal reports
has anyone had any luck using CFREPORT with crystal reports 8? i've tried
the workaround that Allaire recommends and I still can't get the tag to
work. It's very frustrating..
If anyone has any ideas, please let me know..
katie
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFreport and crystal reports
Lena,
I don't use cookies (they frown on that at a government site). With regards
to the "Error detected in database dll", I had the same problem. It turns
out the the User Name I specified in the "user0" parameter didn't have the
right permissions on the table. Other than that, I'm using simple cfforms to
call the reports, passing the parameters the same way as you are. I've
pasted some samples below.
HTH
Mike Hales
---
cfform action="NewReport/TOC/Troubles By Date.rpt" method="POST"
enablecab="No" name="openreport"
cfinput type="text" name="prompt0" size="15" maxlength="16"
cfinput type="text" name="prompt1" size="15" maxlength="16"
input type="Hidden" name="user0" value="xxx$xx"
input type="Hidden" name="password0" value="xxx"
input type="Submit" value="Submit"
/cfform
--
cfform action="NewReport/PM/OPEN PROJECTS IN TMS.rpt" method="POST"
enablecab="No"
trtd align="center"cfselect name="prompt0" size="1" query="pmopenproj"
value="tsxre2"
/cfselectnbsp;nbsp;input type="submit" name="Submit"
value="Submit"/td
input type="Hidden" name="user0" value="xxx$xx"
input type="Hidden" name="password0" value="xxx"
/cfform
-Original Message-
From: Lena Trajkovska [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 14, 2000 3:40 AM
To: CF-Talk
Subject: RE: CFreport and crystal reports
Hi, Mike!
I had a posting a month ago about CR8 and the problems I have. You wrote
that you didn't have any problem using it, so I would like to know how you
are implementing the reports. Here is the .cfm template that I'm using to
open the report in a new window. I got the template with recrystallize. The
problem is that with CR8 - sometimes it opens, sometimes it doesn't and
gives the error "Error detected in database dll". But, even if it opens, the
cookies that I had created with the EXPIRES="NEVER" are gone. Could you,
please, tell me how you are calling the reports and have you tried this
cookie expiring thing?
Thank you in advance,
Lena Trajkovska
P.S. This code is working great with CR7, on NT4 with CF4.0.1 Enterprise,
Oracle 8.
!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
html
head
LINK REL="StyleSheet" HREF="../../../../styles/form.css"
type="text/css"
meta http-equiv="Content-Type" content="text/html;
charset=iso-8859-1"
meta name="GENERATOR" content="ReCrystallize Web Publishing Wizard
for
Seagate Crystal Reports 2.3.1"
title Konten plan/title
SCRIPT
function decode( valstring ) {
var resultstring = ""
for (var p=0; p valstring.length - 1; p +=2) {
tmp = '%' + valstring.charAt(p) + valstring.charAt(p + 1)
resultstring += unescape( tmp )
}
return resultstring
}
function validateandsubmit( f ) {
document.parmform.user0.value = decode( document.parmform.user0.value )
document.parmform.password0.value = decode(
document.parmform.password0.value )
window.open( '', 'reportviewerwindow',
'toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,re
sizable=yes');
document.parmform.submit()
}
/SCRIPT
/head
body
CFform action="ADFN060100.rpt" method="POST" name="parmform"
target="reportviewerwindow"
input type=hidden name="init" value="actx"
input type=hidden name="promptOnRefresh" value=1
input type=hidden name="user0" value="697A76657374616A"
input type=hidden name="password0" value="697A76657374616A"
cfoutput
input type=hidden name="prompt0" value="#cookie.ckompanija#00"
/cfoutput
CENTER
brfont face="" class="tekst"Konten plan/fontbrbr
INPUT TYPE="BUTTON" class="tekst" VALUE="Pogled na izve{tajot"
style="width: 90%" onClick="validateandsubmit(this.form)"
/center
/CFform
/body
/html
-Original Message-
From: Hales, John M [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2000 17:18
To: CF-Talk
Subject: RE: CFreport and crystal reports
I could never get it to work. We just use CF to pass the parameters to
Crystal, and the CR Web Server to display the reports. That works well for
us.
HTH
Mike Hales
-Original Message-
From: Katie Bessiere [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2000 11:08 AM
To: CF-Talk
Subject: CFreport and crystal reports
has anyone had any luck using CFREPORT with crystal reports 8? i've tried
the workaround that Allaire recommends and I still can't get the tag to
work. It's very frustrating..
If anyone has any ideas, please let me know..
katie
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFreport and crystal reports
has anyone had any luck using CFREPORT with crystal reports 8? i've tried the workaround that Allaire recommends and I still can't get the tag to work. It's very frustrating.. If anyone has any ideas, please let me know.. katie Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFreport and crystal reports
I could never get it to work. We just use CF to pass the parameters to Crystal, and the CR Web Server to display the reports. That works well for us. HTH Mike Hales -Original Message- From: Katie Bessiere [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 13, 2000 11:08 AM To: CF-Talk Subject: CFreport and crystal reports has anyone had any luck using CFREPORT with crystal reports 8? i've tried the workaround that Allaire recommends and I still can't get the tag to work. It's very frustrating.. If anyone has any ideas, please let me know.. katie Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFreport and crystal reports
hi i've been using CFX_PRINTREPORT (find it at Allaire's Tags Gallery). Works great for me, so may it help you. Cheers, Gaston. -Mensaje original- De: Hales, John M [SMTP:[EMAIL PROTECTED]] Enviado el: Miércoles 13 de Diciembre de 2000 13:18 Para: CF-Talk Asunto: RE: CFreport and crystal reports I could never get it to work. We just use CF to pass the parameters to Crystal, and the CR Web Server to display the reports. That works well for us. HTH Mike Hales -Original Message- From: Katie Bessiere [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 13, 2000 11:08 AM To: CF-Talk Subject: CFreport and crystal reports has anyone had any luck using CFREPORT with crystal reports 8? i've tried the workaround that Allaire recommends and I still can't get the tag to work. It's very frustrating.. If anyone has any ideas, please let me know.. katie Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFreport and crystal reports
Try taking a look at recrystallize.com. It's just a wizard that generate the html files to run the crystal report; you can probably fined your answers in those files. There's a beta version you can try for free. It uses a dll (u2fpdf.dll) which comes with the download. I haven't actually tried it, yet, since I'm still using CR7, and the feature I need (PDF download)only works with CR8, but I plan to if we upgrade. If you try it, let me know what you think. Marianne Daye Programmer/Analyst Information Delivery Systems http://ids.rti.org -Original Message- From: Katie Bessiere [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 13, 2000 11:08 AM To: CF-Talk Subject: CFreport and crystal reports has anyone had any luck using CFREPORT with crystal reports 8? i've tried the workaround that Allaire recommends and I still can't get the tag to work. It's very frustrating.. If anyone has any ideas, please let me know.. katie Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
