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$xxxxxx">
<input type="Hidden" name="password0" value="xxxxxxx">
<input type="Submit" value="Submit">
</cfform>
------------------------------------------
<cfform action="NewReport/PM/OPEN PROJECTS IN TMS.rpt" method="POST"
enablecab="No">
<tr><td align="center"><cfselect name="prompt0" size="1" query="pmopenproj"
value="tsxre2">
</cfselect> <input type="submit" name="Submit"
value="Submit"></td>
<input type="Hidden" name="user0" value="xxx$xxxxxx">
<input type="Hidden" name="password0" value="xxxxxxx">
</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#0000000000">
</cfoutput>
<CENTER>
<br><font face="" class="tekst">Konten plan</font><br><br>
<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