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?
Printable View
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?
have u try to suppres blank page or not?
Yes I have
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