Graph/view doesn't return records while they're query-able

(0) Share

Report

Posted on by Jeroen J

Dear reader,

I have a form in which a graph is included. Graph and view are public (ofcourse, I guess?).
Being a systemadministrator with this role, I get to see a beautiful graph with the values I was expecting. As soon as I remove the sysad role, I'm told that "a chart cannot be displayed because the view or filter criteria that you selected did not return any records".
Well, that could make sense. However, if I open advanced find, I can query all records that I was looking for. So, I do have access to them (not being sysad that is), but they're just not shown on the graph.

I have this uncomfortable feeling that I'm overlooking something here. Any other security thing that I'm missing? Any ideas or clues?

Thanks in advance,
regards,
Jeroen

*This post is locked for comments

I have the same question (0)

All responses (17)

Answers (0)

Suggested answer

Rawish Kumar 13,758 on at

Like (0)

Report

Hi Jeroen,

This is very strange - what i can suggest you to have a look on the role. and see if permission has been given on system charts and user charts and other important aspects of data visualization.

let me know how it goes. Also is there any other role/users for which it is working

?

Was this reply helpful? Yes No
Jeroen J 12 on at

Like (0)

Report

Hi Rawish,

thanks for getting back to me this quick! (and thanks for aknowledging I'm not a complete idiot finding this strange :)

To start off with your last question, that was exactly what I was investigating at the moment. The only role that does show data on this specific graph, is Systemadministrator.

To make things a bit more spicy, I copied the sysadmin role to a new one and distributed it to myself. Without any changes in it, I can't see the records I was expecting.

Well, we all (probably) know that Sysad has quite some hidden privileges, but I never before encountered one of this category.

Any more ideas maybe? (since I'm running out pretty fast)

regards,

Jeroen

Was this reply helpful? Yes No
Suggested answer

Rawish Kumar 13,758 on at

Like (0)

Report

haha! you made it more mysterious.

i cant think any more solution but to check this in other environment - i am sure you would have other dev and testing environments etc.

Was this reply helpful? Yes No
Jeroen J 12 on at

Like (0)

Report

Oh, but I dó.

I have a development and a testing environment. Unfortunately, they're exact copies of production and are showing the same behaviour :(

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Is the chart using a personal view (i.e. a saved Advanced find view)?

If it is, then share this personal view with your other users in your Dynamics 365 (CRM) instance

Was this reply helpful? Yes No
Jeroen J 12 on at

Like (0)

Report

I wish it where true, but all is public unfortunately...

Was this reply helpful? Yes No
tw0sh3ds 5,600 on at

Like (0)

Report

On the top right of your chart you should have the button "View the records that are used to generate the chart". When you click it, can you see any records in the view that will pop out on the screen?

Was this reply helpful? Yes No
Jeroen J 12 on at

Like (0)

Report

In this case, it's not there. Probably because no records are returned.

Was this reply helpful? Yes No
tw0sh3ds 5,600 on at

Like (0)

Report

No, it should be there even if there are no records. Can you post some screenshot of the chart?

Was this reply helpful? Yes No
Jeroen J 12 on at

Like (0)

Report

By all means (you'll probably get why this is about to drive me nuts):

even when hoovering over the header (which usually shows the Reload, Records and Enlarge buttons), nothing happens. So, this might be pointing out that the chart itself really isn't showing..?

Was this reply helpful? Yes No