CODEWITHSUNDEEP
reporting-servicesssrs-2008
prav
prav

Reputation: 450

Find the length of the report to have a Not to Print message

I have a SSRS 2008 R2 report, based on the user selection of paraneters, the report is growing horizontally so I need to find the length of the report dynamically to have a message "Not to print"

How to find the length of the report dynamically here I need to check for A3 size.

Upvotes: 0

Views: 93

Answers (1)

Jamie F
Jamie F

Reputation: 23789

I don't think there's a way to find out the width directly. But if you know the columns based on the parameters, then you can calculate the width by simply adding the width of the columns.

Use this as a formula in the visibility of a TextBox with your message.

Depending on your parameters the formula might be something like:

=IIF(Parameters!FieldList.Value.Count > 8, false, true)

Upvotes: 1

Related Questions