In the end I did this
CRTable.Location = CRTable.Location
Seems to work.
If I do not set the location I can only run the report against the database it was written against.
I was doing
CRTable.Location = CRTable.Table
as this was what was suggested to me and appeared to work.
However...
I have written an ASP app using the activex viewer that allows users to add their own reports and run them in the web.
This has been working fine until now. I use the usual methods for running the report and logging it onto the correct database etc. Some users have written reports using table...
Forgot to say I am using ODBC.
If I do the following
Set CRTables = Session("oRpt").Database.Tables
For each CRTable in CRTables
CRTable.SetLogOnInfo cstr(ODBC),cstr(Database),cstr(User),cstr(Pass)
alert CRTable.Location
Next
It is showing me the correct database. i.e. Live
However...
I am using Crystal 9 and MS SQL Server 2000 and the activeX viewer to launch my reports in the web using ASP.
All of my reports use stored procedures.
The majority of these reports use a Command to call the sp and the following code to set the log on details in the web.
Set CRTables =...
If I click print properties in Crystal the printer is set to A4. If I print the report from Crystal it comes out A4.
If I print the same report from the web it goes to the printer as Letter.
I'm not sure how to set a report to be A4.
I am using the smartviewer activex viewer to view reports via the web. When I print the report from the viewer the paper size is always letter. I can change this from the print dialog to be A4.
However I do not want the user to have to do this everytime they want to print a crystal report.
Does...
I am printing a report from a web browser using the activex viewer and it comes out in letter size. I can change this to A4 by selecting advanced on the printer properties on the window that opens when I click print. However I need to change this programatically so that everything is printed A4...
I have recently been looking at integrating crystal with ASP. I have been using the SmartViewer ActivreX
Everything seems to be okay when I pass the parameters to the report.
However I also need to run reports that have parameters which will prompt the user to enter them (as would happen if...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.