Hi,

I am using Seagate Info 7.5.2, Database - Oracle 8i

When I run a report in "Info Report Designer" it runs fine with the expected output.

But when I schedule the same report in Info Desktop, it fails.
The error message given in the properties of the failed report is nothing but the "path" where the Seagate report is saved on the server.

Any idea on why the report fails?

Sheetal.

I have the same setup, but need a little more info if you wouldn't mind. Are you running this report using the Baan driver or ODBC to Oracle. Also, try this too, when you schedule the report, on the logon tab, check the checkbox at the bottom left called: Test connectivity only. This might give you a more meaningful message to see if you have any data source connection issues. What format are you trying to publish the report in: Crystal, Excel, Rich Text, etc. I have found that the layout on some reports will fail if sent to Excel because it can't resolve them.

Gilbert Guymer
Database Administrator
Lufkin Industries, Inc.

Hi Gilbert,

I am running this report using ODBC to Oracle.

I checked the "Test connectivity" checkbox when scheduling the report. The report gives status as "DB Tested".

I am trying to get an "Excel" output of the report. However, the report layout is quite simple. It has just the table, formula fields being displayed.

One thing I'd like to mention about the report is that it uses 4 subreports. I don't know as to whether this should cause problems cuz I have 3 more Seagate reports that are using 4 subreports and they are running fine in Info Desktop.

I have checked the "Set location" in each of the sub reports for correct "Server Name" and "User ID". It seems to be okay.

Sheetal.

I have had occasions where some reports would not generate into Excel due to a change in the report layout. Crystal Decisions web site has some helpful documents and one of those is: "Exporting to Microsoft Excel" (scr_exportexcel.pdf). I'm sorry if I can't be more specific, but I don't know what your report looks like, and why this sometimes happens, other than it does. I don't think your subreports are an issue unless there is some alignment problem from the data being returned by those subreports.

If the report generates to Crystal Report format OK, then examine the layout of the report. Use the document I mentioned as a guide for this. Best of luck and let me know how it turns out.

Gilbert

The problem in the report was solved by the arrangement of the sub-reports. Previously, all the 4 sub-reports were in the same section. Now, 2 sub-reports are placed in one section, and the other two in a separate section.

The report now gives correct output in Excel format.

However, I am still not clear as to why this should make a difference...but it worked!!

Thanks.
Sheetal.