Blank Report

[kken]

If my report has no data then it returns a blank report. No report header or page header. Does anyone know how I could rectify this problem so if no records returned I will still get my headers?


Thank you

 

[kenhamady]

Are you previewing from within an application, or standalone CR? Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[HowardHammerman]

If you are accessing your report directly using the crystal report designer, you can't get there from here. It can't be done. Remember, what Crystal gives you is a giant do-loop that processes each record. If there are no records, no report.

If you are calling crystal from an application such as VB then you can test for the existence of one or more records and then if there are none, print a polite message.

Howard Hammerman, On-site/Phone Crystal Reports Training/Consulting

http://www.hammerman.com

 

[kken]

Hi ken & Howard:
Thank you for the response. Let me give a more info. I am using it through the web. Also when testing in preview it also comes up blank. This is really confusing for me because I have other reports that when there are no records it still shows me my headers, but of course no details. I do not see the difference between the reports.


Thank you

 

[kenhamady]

Does this report have a page header?
Have you done any conditional suppression? Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[kken]

Yes it has a page header and no there is no conditional supressing. Actually there is no surpressing at all in the report. It is fairlly strait forward.

 

[kenhamady]

There isn't by any chance a second page that you aren't seeing.

I put a page break after the report header, and now a report with 0 records gives me 2 pages, the first is blank (report header with its page break) and the second is the page header. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[kken]

No just one blank page, no page breaks inserted.

 

[kenhamady]

When you get this blank page in preview, are there any section abbreviations along the left just past the vertical ruler? Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[kken]

There is nothing except the blank page

 

[kenhamady]

Sorry, I am stumped. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[kken]

Thank you for trying

 

[kenhamady]

If it were my report, I would try rebuilding the report from the ground up, testing it at various points to see at what point it starts to behave differently than your other reports.

Please post the answer if you figure it out. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/