CR10 Blank Report

[rajeshgooner]

I have a report that runs of a native oracle driver connection.

The table linking is quite complex and involves linking two fields from one table to the next in one example.

The report has two parameters which are both referenced in the selection formula. In addition there are also a number of other conditions specified in the selection formula.

The report is pretty intensive on its use of running totals.

The subreports are linked to a combination of parameters and formulas. They are used to display charts.

for certain parameter combinations, the report runs fine, however, for others a blank page is received. This could be due to the fact that some data is not brought back but there should be some rows returned???? And the group tree indicated that something has been returned as well as the record count. However, all i get is a blank page. Any ideas as to why this may happen? I understand it may be a database or table linking issue but am not sure what is causing CR to behave in this way.

 

[Turkbear]

Hi,
Be Sure your tables are linked with Left Outer Joins - without this ,any failure to retreive a matching record from any of the linked table(s) will result in NO record from any table, including the 'master'..

 

[Madawc]

if that doesn't work, do an experimental version in which you knock out particular selection rules. Find out which one is doing its job too well.

You can turn any command into a comment by entering // at the start. And restore it by removing the //.

It helps to give your Crystal version, since newer versions have extra options, and some extra problems. I use Crystal 8.5.

Madawc Williams (East Anglia, UK)