Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Crystal Reports and Coldfusion
- Thread starter Krelek500
- Start date
NorthStarDA
IS-IT--Management
check out this faq
faq232-2648
dealing with crystal reports
faq232-2648
dealing with crystal reports
- Thread starter
- #3
NorthStarDA
IS-IT--Management
ok, i guess i don't understand what you mean by 'dreamweaver wont accept it'. are you trying to preview the page after you put in the cfreport tag and its giving you problems?
what have you tried so far, and what does the error say when you try to use CFREPORT?
as far as how to use it:
live docs description of cfreport, also dreamweaver has a good code reference in the reference tab of the code panel.
what have you tried so far, and what does the error say when you try to use CFREPORT?
as far as how to use it:
live docs description of cfreport, also dreamweaver has a good code reference in the reference tab of the code panel.
- Thread starter
- #5
I get an error with the follow message.
The report file you have specified either does not exist or is not accessible to the ColdFusion service. Please verify that the name of the report file is spelled correctly and that the file is located in a directory which is accessible to the ColdFusion service.
I am just starting to use coldfusion and do not know much about configuring the pages.
The report file you have specified either does not exist or is not accessible to the ColdFusion service. Please verify that the name of the report file is spelled correctly and that the file is located in a directory which is accessible to the ColdFusion service.
I am just starting to use coldfusion and do not know much about configuring the pages.
NorthStarDA
IS-IT--Management
in that case i would have to refer you back to the faq, the last section refers to installation of crystal reports 8.5 for working with cf, have you completed this step?
- Thread starter
- #7
NorthStarDA
IS-IT--Management
is it possible the directory where the reports are stored does not have sufficient privileges for CF to access it?
also, were your reports created with 8.5?
also, were your reports created with 8.5?
- Thread starter
- #9
NorthStarDA
IS-IT--Management
well if the folder is in your web root, or same folder as your files or underneath you're probably fine for permissions. if not, you can check it by going to the security tab in that folders properties and make sure there is either an 'Everyone' or IUSR_#machinename# and that one of them has read access. Other than that I'm not sure what would be causing that error, i used crystal with CF5 and an older version of crystal reports and have long since abandoned it.
I've heard that you can CFLOCATION directly to the report file and it will open, but I have not tested that theory.
I've heard that you can CFLOCATION directly to the report file and it will open, but I have not tested that theory.
ColdFusion and Crystal reports stopped playing together with versions CF 5 and Crystal 8. I don't even think Crystal supports the use of the <cfreport> tag anymore. If you have the Crystal Reports Engine installed on the server, you can call your reports directly with <cflocation>.
Hope This Helps!
Ecobb
"My work is a game, a very serious game." - M.C. Escher
Hope This Helps!
Ecobb
"My work is a game, a very serious game." - M.C. Escher
Ecobb - are these reports populated with current data on the fly or are you just running a report you created with data attached from whenever it was run? Can you provide more specifics and possible code to make this work? I'm using ColdFusion MX 6.1, Crystal 9/10, and Oracle 9i. Thanks.
FYI - I just found this on Macromedia's website as a possible fix for cfreport. I've not tried it myself but it was just published June 30, 2004 so hopefully it works.
- Status