News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) difference data show d...

Microsoft Dynamics AX (Archived)

difference data show depend of priviledge SSRS Report

(0) Share

Report

Report

Posted on by Rvp_

85

Hello master i need your help,

is it possible in SSRS report that it will show different data if we use Administrator priviledge and not administrator?

i have example

when i use administrator priviledge the report show like this :

and when i use with not administrator priviledge the report show like this :

when i use administrator the report show true data that i want, but when i use another user the the report show wrong data

if it is possible, what should i do to make the report in another user show tre data

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at

Like (0)

Report

RE: difference data show depend of priviledge SSRS Report

Hi Rahmat,

Can you tell what type of addresses these are and where they come from. Initially, it do think it doesn't make sense to have another address based on being a system administrator or having another role. What is the exact business requirement here?

A system administrator should monitor and setup the application, but should not be the only person who can print the correct address. That idea is wrong.

Well, there are some commands where you can find out if the user has the system administrator role. To be able to implement having another address, you need to implement coding. You can either search within the security role assignment table for persons having system administrator role or look at coding in the application where Microsoft did evaluate if a user has the system administrator role or not. E.g. it is used on the workfow history form or related classes. But again, in my opinion it is not the system administrator who should perform business tasks in the application.
Blue Wang on at

Like (0)

Report

RE: difference data show depend of priviledge SSRS Report

Hi Rahmat,

I think that is ok.

You can set a UserID parameter to retrieve the corresponding character to execute the expression.

I see that your request is only different in address, then you can use replace() to replace the displayed content.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans