Report Builder 3.0

Report Builder 3.0 has some minor additions that make your life a better world.

On that i’ve just found is the ability to know what renderer is being used. Why is that useful? Well in all the training I do on Reporting Services I always highlight the issues with Excel exporting.

The main issues are due to columns and cells being merged and thus preventing users from sorting data once its in excel.

One of the solutions is to optionally display items so they don’t cause these problems. Historically you’ve had to provide a parameter that asks the user if they want an Excel friendly format.

Well now you have a global variable RenderFormat that allows you to provide custom formatting based on the renderer that is being used.

To access the variable you can use the following.

=Globals!RenderFormat.Name

Published Friday, July 23, 2010 10:11 AM by simonsabin

Comments

No Comments