Here is what Matthew Small had provided me to be able to pull up the
reports:
"I'm talking about using ASP.Net instead of CF for Crystal if CF doesn't
work so well for you.
I don't know how familiar you are with CR or ASP.Net, but here is a portion
of the code that I actually use. The Crystal Report has already been
created in the report designer before we use it.
-----------------------------------------------------------------------
Imports CrystalDecisions.CrystalReports.Engine
'Create SQL Data Connection Information
....
' Runs a stored procedure on the SQL server and gets the information from it
' into a Data Adapter SQLQuery.CommandText = "create_showorder "
+ show.selecteditem.value + ";
SQLAdapter.SelectCommand = SQLQuery
SQLAdapter.Fill(SQLDataSet)
SQLConn.Close
' Declaration of a CrystalDecisions.CrystalReports.Engine.ReportDocument
' object
Dim crReportDocument As ReportDocument = New ReportDocument
' Load a pre-created Report into the reportDocument object
crReportDocument.Load("c:\inetpub\intranet\webpages\crreports\announcers
scoresheet.rpt")
' Set the datasource of the ReportDocument to the results of the Stored
Procedure
crReportDocument.SetDataSource(SQLDataSet.tables(0))
' Set the printer to print to. such as "//servername/printername"
crReportDocument.PrintOptions.PrinterName = printerstring
' Start printing (copies, collate, startpage, endpage)
crReportDocument.PrintToPrinter(PrintNumber.SelectedItem.Value, true, 0,
0)
'-----------------------------------------------------------------------
----
That's it. Aside from the SQL data operations, the CR itself only takes
five lines after the report has been created."
Good luck!
Regards,
Eric Hoffman
Datastream Connexion
"The reasonable man adapts himself to the world; the unreasonable one
persists in trying to adapt the world to himself. Therefore all
progress depends on the unreasonable man."
-- George Bernard Shaw
-----Original Message-----
From: Josh Remus [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 2:51 PM
To: CF-Talk
Yes. And an example would be appreciated, either on the list or sent
directly. If I have to do this in ASP, so be it.
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 31, 2003 3:40 PM
> To: CF-Talk
> Subject: RE: Bloody CFReport
>
>
> I have an asp example somewhere here...are you just trying to get the
> report to show up at all at this point?
>
>
> Regards,
>
> Eric Hoffman
> Datastream Connexion
>
>
> -----Original Message-----
> From: Josh Remus [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 31, 2003 2:03 PM
> To: CF-Talk
>
> I took a look at some of the ASP examples, and of course they made it
> look like you needed about 200 lines of code to accomplish calling
> Crystal. Now, likely that's not true, but I haven't found a good,
> simple ASP example online yet. I don't have any issue rolling a
> non-CF solution for this one piece.
>
> Josh
>
> > -----Original Message-----
> > From: Dan O'Keefe [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, July 31, 2003 2:52 PM
> > To: CF-Talk
> > Subject: RE: Bloody CFReport
> >
> >
> > What about calling it from an ASP page. I played around with that
> > some time ago, and I have a project where I will need to do that soon.
> >
> > Dan
> > =================== Previous Message Below ===================
> >
> >
> > -----Original Message-----
> > From: Ian Skinner [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, July 31, 2003 2:28 PM
> > To: CF-Talk
> > Subject: RE: Bloody CFReport
> >
> >
> > You might be in trouble. I fought with this myself about a year ago
> > for a project. I learned at that time that Crystal NO LONGER
> > supports CFReport. They have gone their own way, and they want you
> > to use THEIR system. I can only offer you sympathy and a hardy Good
> > Luck. I never did get it to work, and we ended up rolling our own
> > CF - RTF report system.
> >
> > --------------
> > Ian Skinner
> > Web Programmer
> > BloodSource
> > Sacramento, CA
> >
> >
> > -----Original Message-----
> > From: Josh Remus [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, July 31, 2003 11:21 AM
> > To: CF-Talk
> > Subject: Bloody CFReport
> >
> >
> > Okay - I've seen in many cases out there while googling for help
> > that many people have been unable to get CFReport to work at all. I
> > believe I have installed it correctly, however I must be doing some
> > slight thing wrong that is keeping me from my goal. I have tried
> > several different things,
> > including:
> > 1. Moving the report in question from ODBC to Native, etc.
> > 2. Trying a simple report (with no database fields involved) -
> > this worked fine. But as soon as I added even one database field,
> > it
> failed.
> > 3. Combinations of username and password, no user name, no
> > password, all of the above.
> >
> > The error that I'm getting most of the time is: "An unexpected error
> > occurred while using the Crystal Engine. Error number 599 occurred
> > (Cannot open SQL server.)." I believe the call is getting to
> > Crystal, just not getting back. My RESPONSE.INI file has the
> > following lines in
> > it:
> >
> > [ReportStatus]
> > ReportSucceeded=0
> > ReportErrNumber=599
> > ReportLibInfo=<P>Crystal Library = C:\WINNT\System32\CRPE32.DLL
> > (2/10/2001
> > 1:43) <BR>DLL Version = 8.80, Engine Version = 8.80
> >
> > The code for the page in question is this:
> > <cfreport report="c:\Inetpub\wwwroot\crm_production_tree\PEPs\test.rpt"
> > username="#Request.UserName#" password="#Request.Password#"
> > type="microsoft"> </cfreport>
> >
> > The file does exist, I can open it, verify the database, refresh
> > data, etc., from the server machine successfully. Request.UserName
> > & Password are correct. I've also tried hard-coding them in. I've
> > tried it with and without the type="microsoft".
> >
> > I'm hoping that someone will have some new idea on what to try. I
> > appreciate any help I can get!
> >
> > Thanks!
> > ---
> > Josh Remus
> > Network Manager
> >
> >
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
