Hide / show column in SSRS using parameter

In SSRS reports you can easily determine which table columns are visible by default.  Not everyone knows that you can give user possibility to choose which columns should be visible.

Continue reading “Hide / show column in SSRS using parameter”

Advertisements

“The definition of this report is not valid or supported by this version of Reporting Services.”

Sometimes reports stop working after uploading newer report definition (RDL) – but definition is 100% proper?

Example of error message:

The definition of this report is not valid or supported by this version of Reporting Services. The report definition may have been created with a later version of Reporting Services, or contain content that is not well-formed or not valid based on Reporting Services schemas. Details: '.', hexadecimal value 0x00, is an invalid character. Line 4632, position 10.

Continue reading ““The definition of this report is not valid or supported by this version of Reporting Services.””

Displaying SharePoint RichText field as HTML interpreted in SSRS

SSRS Reports have a placeholder property HTML – Interpret HTML tags as styles. That property allows you to use HTML tags while displaying report.

devenv_2016-01-19_14-28-40

We have to face the problem when we want to display SharePoint`s RichText field content is SSRS Report. RichText field may contain some characters that are stored different in SharePoint DB and cannot be interpreted by SSRS as HTML (eg. :, &, {, <, >,  list elements, etc.)

Continue reading “Displaying SharePoint RichText field as HTML interpreted in SSRS”