Blank Report

[FredMilano]

I have a report that I have created in a earlier version of OpenOffice using Oracle Report Designer. The reports have been running fine until the latest release. In most cases, I tracked down the problem to the fact that I had slashes in some of the data fields in the DB and when I removed them, I get the report back. However, I have one case where it seems to be something else. I use the following query against a DB table with all the fields in the query. Then I define the report against the query:

SELECT "Video"."TITLEA" AS "TitleA", "Video"."SERIES" AS "Series Name", "Video"."COST" AS "Cost" FROM "Video" "Video" ORDER BY "Series Name", "TitleA"

When I run the report, it opens a blank Gray Screen and no data at all. If I drop the Series Name field on the report it comes out fine. So, are there any other "bad" characters that might be in the data. Or any other suggestions about what the problem may be? (By the way, the reports all continued to work until I added new data. Then all of a sudden I have this problem with the various reports.)

Thanks in advance for any insights.

[RoryOF]

Perhaps the space in "Series name" causes the problem. Try using an underscore in both the database and the query.

[FredMilano]

Perhaps the space in "Series name" causes the problem. Try using an underscore in both the database and the query.

Thanks. Just tried that (only in the query since the Table's Field Name was SERIES anyway. Same problem.

[FredMilano]

Anyone else have any ideas? Is there anything in the actual data that can cause this problem?

[SmikeCarl]

Same problem with my copy of report builder in OO 3.4.1 on Windows 7 machine. Previously had problems with reports not being saved. Could not get out of report builder. Killing OO was the only way out. When reopened the database in OO the report would fail. Now it tries to execute & all I get is a gray screen. (OO version of the blue screen?)

[SmikeCarl]

Found a work around on the blank report problem: There appears to be a problem with how DBF data is read when transferring from Microsoft Access to OpenOffice Base. A couple of fields were responsible for the blank report.

To get ORB working I:
1. Deleted the existing report.
2. Opened the DBF file in Lotus.
3. Redefined the fields in question (adding field width).
4. Saving the DBF file under a new name.
5. Opening the new DBF file in OpenOffice.
6. Recreate the report in ORB

Problem solved!