I have written SQL query to display created cases and closed cases based on team.But for a agent login it need to only his data.and admin need to see his data as well as agent data.After deploying the rdl it shows same data with different user security roles.any help on this would be appreciated.
i have a similar question and i used a fetchxml query to build ssrs report , but not sure what condition i need to add so that logged in user will see records based on business unit
I'm sorry - I'm not sure what you mean.
Can we not use parameter to filter only the current logged in user data
The only other way is to use FetchXml datasource for that purpose.
Tried that also.but with respect to user login it is not showing data.
In order to respect security you should use a Filtered view instead of regular one.
So the query should be like the following:
Select
i.incidentid
,i.name
from FilteredIncident i
I have written a query like
Select case when c.statecode=0 then c.createdon else c.resolvedon,ad.name from incident as a
Left join systemuser as ac on c.owininguser=ac.systwmuserid
Left join team membership on ac.systemuserid=teammembership.systemuserid
Left join team as ad on team membership.teamid=ad teamid
Where c.createon>=dateadd(day,-7,getdate())
And ad.name='abc'
Group by createon,ad.team,resolvedon
Can you please provide the queries you used?
SQL queries
Hello,
What did you use to build the report - T-SQL or FetchXml?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,524 Super User 2024 Season 2
Martin Dráb 228,469 Most Valuable Professional
nmaenpaa 101,148