Passing parameters in URL to SSRS reports in SP library

You have possibility to set some parameters for controlling full-page SSRS report rendering (it refers to Toolbar, Parameters WebPart, etc.).

Continue reading “Passing parameters in URL to SSRS reports in SP library”

Advertisements

Combining data from Project’s Custom fields and SharePoint lists into one view

If you want to combine data from MS Project (project info + custom fields) with data from SharePoint lists (eg. Project Site), you can simply create view in SQL Management Studio…

Continue reading “Combining data from Project’s Custom fields and SharePoint lists into one view”

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”