SharePoint

Validate Start date and End date parameter in SSRS

0You need to add a function to validate the parameters. Go to the Report Properties under the Report menu and place this code to the Code Tab.

Then go to the Report Parameters and Add named it XXX with the datatype as string. Checked the Hidden and Allow blank value ckeckboxes. In Available Values Read more about Validate Start date and End date parameter in SSRS[…]

SharePoint

Get distinct values of a column of a SharePoint list using SQL Server Reporting Services

1This issue is very common when you are pulling data from SharePoint list to load parameter values. In this post let us discuss the solution for the same. Step 1 : Create a report and Go to the Report Tab at the top. Step 2 : Go to the Report properties and then code and write the Read more about Get distinct values of a column of a SharePoint list using SQL Server Reporting Services[…]