Skip to Content
Former Member
Feb 06, 2012 at 04:46 PM

sub report shows zero values from sql command although the sql itself have



Please, help - the crystal behave not normal at all.

I have a report that is consists of 3 sub reports

I run sql command to get the result from oracle.

All I do, is put the returned values on the report surface.

The first sub report is fine.

When I switch to the second sub report, the Crystal runs the first sql command, (Of the firsr sub report) and then the sql command of the second sub report.

But, on the report surface, we get only zero values.

I took from oracle monitoring tool the exact query the crystal runs, and run it manually and got real non zero values.

What seems to be the problem??