cfreport error 533 - Crystal reports 1

[ibearian]

i have been trying to access a crytal report.

Via

<cfreport report= c:\inetnet\

http://wwwroot\proline\r1.rtp

type=&quot;microsoft&quot; >

</cfreport>

and it won't work.

ERROR MESSAGE

An unexpected error occurred while using the Crystal Engine.
Error number 533 ocurred.

the report is simple and has saved data, i'm running iis, cf mx and cystal reports 8.5 & Crystal enterprise 8

thanking you in advance !


Ibearian

 

[philhege]

Iberian,

The usual filename extension for a Crystal Reports document is rpt, not rtp. could this be the problem?

PH

 

[ibearian]

ah no that was just a typo sorry. I believe actually that seagate dosen't support cold fusion with crystal 8, 8.5 & 9.

I don't know why ?

I will now have to take CE 8.0 out and CRW 8.5 and roll back to CRW 7.0. I will not be upgrading to CRW 9.

I just can't understand why crystal decisions have done this. In my opinion cold fusion will be the langauge of choice for the mid range web developer. Java if you are really keen and .net if you have plenty of time on your hands.

I chose 2 months ago and desided that cold fusion was the way for me. Having seen the simplicity of cold fusion when compared to java (CF is more simple and probably less capable in total, but it has enough funcionality for me) and the ridiculous amount of cold needed for ASP/.net and the lack of mainstream support for PHP. Cold fusion with dreamweaver was just the ticket.

Its just a shame that crystal have forgotten those that made it great.

 

[philhege]

ibearian,

Yeah, it's hard to get left behind. We use CR 8.0 and CE 8.5 here. I haven't used the CFREPORT tag since v6. I roll my own calls to the rpt files. You can pass parameters in the querystring or through a form POST to the rpt.

Good luck,
PH

 

[ketipst]

philhege, would you expand on &quot;I roll my own calls to the rpt files&quot;? Does this mean you are calling the CR engine from your work station, the CF server, or both?

Does your call cause the report to be refreshed or just
displayed from static data?

Thank you for your hints.

 

[philhege]

(Sorry so late; busy)

The Crystal Report that I call is parameterized. I pass the values in the URL:

<cflocation URL=&quot;/reports/myreport.rpt?prompt0=#myfirstparameter#&prompt1=#mysecondparameter#(etc.)&quot;>

Values are chosen by the user. The order of parameters is equal to the order of params in the parameter list for the report (in Crystal Designer).

You can also mock up the code that calls the viewer, but it's not really necessary.

HTH,
PH

 

[ibearian]

Sorry Philhege.. being a bit thick here.

by encapsulating the parameters in the url the crystal report will be able to pick up the critera ?

Do i need no code to call the crystal report at all (apart from the <CFLOCATION> tag.

just sound to good to be true

 

[jbmwk75]

philhege - can you post some example code showing specifically how you call these and send parameters? I'm new to CF and have tried cfreport, etc. to no avail. I have to make Crystal reports 9.0 work with CF MX and have had nothing but headaches. Any help is appreciated.

 

[philhege]

jbmwk75,

See my post above. Works for 8.0. You may need to tweak the parameter names for CR9 (I don't have it so I don't know). That's all there is to it; further examples would be pointless.

 

[ibearian]

phil, i know its been a long time... but i have tried and it works for a discrete parameter but i can't get it work for a range. I have tried putting more prompt1, prompt2, prompt3 and so on but that doesn't work do you know of any way ?


sorry but thanks

ibearian.

PROJECT H
mailto:ibearian@projecth.co.uk

 

[ibearian]

oooooh yeah got it working by using two parameters and using the between function in the selection critera.

Just now have knightmares with APS login and NT/sql login....but thanks it works !!!!!!

ibearian.

PROJECT H
mailto:ibearian@projecth.co.uk