Crystal - ASP

[feemi]

I have an ASP that displays a simple (non parameterized) report. This report displays okay, but I cannot refresh the data. I get an error stating that the server has not yet been opened. I would like this report to display refreshed data when the report is initialized on the page. Then I will remove the Refresh option in the Report Viewer. Any help would be appreciated.

 

[dcm]

feemi: Make sure your ASP includes the SetLogonInfo step as this connects your report to the data source - this is probably the cause of your error message David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner

 

[feemi]

I have the following code in the ASP. The connection always fails. The ODBC system DSN is Automation. I have reviewed the Crystal report and it has the same setting. Am I missing a DLL or something?

set crtable = session("oRpt&quot.Database.Tables.Item(1)
crtable.SetLogOnInfo "Automation", "pubs", "sa", "bailey"
Response.Write crtable.TestConnectivity

 

[mmaz]

Do you have more than one table in your report? If you do, you will have to use the SetLogonInfo method for each table.