Crystal Reports

[mikki]

I am new to crystal reports. I have created a report in visual basic using the crystal report designer. The report contains a subreport. When running the report the first page of the report is blank. Can someone help?

[aliank]

have u try to suppres blank page or not?

[mikki]

Yes I have

[ExcalibursZone]

I use Crystal reports daily (joy of joys but I've found that if there is an empty record, the report will display an empty page, even if you have suppress blank section on.

The only thing I found that worked is to use the same criteria in your main report as you have in your sub report and supress on that instead: IE

Database = Users.DBF (or whatever)
In the suppress formula for the group header (or any section)

Crystal:
If IsNull({Users.UserID}) or {Users.UserID} = "" then true else false;

VB:
If IsNull({Users.UserID}) or {Users.UserID} = "" then
Formula = True
Else
Formula = False
End If

The VB is for Crystal 8.

The Group needs to be based on the criteria you want to show or supress.

I wish Seagate would have put in Object style access to subreports and such: If Subreport.OutPut = <> Then True else false ...

Heh that would be fun.

Your subreport should be based on the same database, or at least have it as a group. Be wary of 1-many situations though.

-Excalibur