Wednesday, March 7, 2012

Report Blank on Render?

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.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
"Eric_H" wrote:
> 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.
>|||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.

No comments:

Post a Comment