Groups | Blog | Home
all groups > sql server reporting services > march 2006 >

sql server reporting services : Report Blank on Render?


Eric_H
3/9/2006 4:01:33 PM
Hello Everyone,

I have a Sql Server report which, when there is no data returned in the
dataset, goes entirelyt blank. Static text is wiped out, no page
header, nothing, just a blank screen. How can I at least get my static
text to stay there?

Thanks.
Amarnath
3/9/2006 9:30:28 PM
Hi Eric,

Is it working in your preview ? you need to place all your field titles
hardcoded. If it comes from the dataset then you will get the page empty. If
u require it in a tabular form use tables.

e.g assume both in a text box and in the body.
Employee No
=Field!emp_no

Amarnath



[quoted text, click to view]
Eric_H
3/10/2006 7:34:01 AM
Hi Amarnath,

No, it shows up blank in the preview, text is not contained in the
table, it is just textboxes on the form with static text. The titles
are hardcoded, that's why this is confusing. No error messages, just a
pure white report.
AddThis Social Bookmark Button