Hi Thom A,

All the stored procedures used in the reports are from same database and all uses the same user/login SSRS_login.
When a user,user_A login into the application...

Hi Phil,

I am not that familiar with deploying SSRS reports,but i know that there is a common/generic login in database for SSRS reports to run.All the user who runs...

Hi All,

I have used  GROUP By ReportId order by ReportId OFFSET 0 ROWS to remove the HASH MATCH (Aggregate).
This removed HASH MATCH (Aggregate) and Stream Aggregate is in place now.But now in...

Hi,
[dbo].[IncidentFormSearchModel] is a view created from couple of tables.
And IncidentStatus column comes from another view and it is joined to  [IncidentFormSearchModel] view.
Yeah,the IncidentStatus column in view is...