XML Output doesn't include NULL TextBoxes in Table areas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Maxwell2006 - 27 Feb 2006 23:02 GMT

Hi,

I have a Table in my report and I chose "AttributeNormal" for
DataElementStyle property of the all text boxes within the table's detail
row.

The problem is that SQL RS doesn't output text boxes with null values.

Is there anyway to force SQL RS to output null textboxes as blank
attributes?

Thank you,
Max

Reply to this Message

Peter Yang [MSFT] - 28 Feb 2006 03:36 GMT

Hello Alan,

For a single textbox, you may want to use the following expression:

iif(isnothing (variable), variable, "")

However, for tables that linked to dataset, if no result is returned, no
line will be shown in the tables.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

Reply to this Message