Tags » SSRS

How to pass parameter to SSRS report from MS CRM(C#.NET)

Scenario :
> We have CRM and SSRS report ,
> CRM has Button/URL text field on form.
> SSRS have a parameter Called “
378 more words


How to Connect CRM with SSRS in visual studio.

Steps to create connection between CRM and Reports project in Visual studio so that you can Create/customize SSRS reports in visual studio.

Step 1 : Create SSRS project in visual studio 234 more words


Job schedule at a glance

I often asked myself: can some of the SQL Server jobs I have be the reason of database slowness users are currently experiencing? On multiple occasions that was indeed the case and I had to reschedule some of them, because there were too many running at the same time. 239 more words


Multiple column SQL pivot

Here is an example of a pivot query that will show up to 3 contractors and their address by projects

These are the tables:

Contactors… 138 more words


How to get SSRS Report ID from SSRS Report Name

We needed to find SSRS Report ID from SSRS Report Name. Following query:

where name = ‘AbcReportName.rdl’


How To copy SSRS reports to a new server even if I am not the owner of the reports


During my search for a way to bulk copy SSRS reports from one server to a new one my first option is  to  going through each report and downloading the report definition file and then uploading the file to the new server. 131 more words

SQL Server