You’re offline. This is a read only version of the page.
1,673
Hi everyone
I've got a strange error I haven't seen before.
I've got an SSRS report that I populate with 2 temp tables and a dataprovider. One of the temp tables is a header table with 1 field in it: a string field which contains a formatted date. The other temp table holds the rest of the data for the report. The properties/security settings for each table are exactly the same.
In my dataprovider, I take the date parameter from the report's query and put it into the header temp table, and then I display it on the report, something like this:
str dateParm = this.parmQuery().dataSourceTable(tableNum(MyTable)).findRange(fieldNum(Mytable, TransDate)).value();
When I run the report as SysAdmin, I see all the data on the report, including the formatted date from the header temp table. When I run the report with diminished security roles, I still see all the data in the report, but don't see the data from the header temp table.
Has anyone got any idea where this kind of security would be set up, or does any one know what's going on here?
Thanks
*This post is locked for comments
I have the same question (0)Hi
In case anyone ever runs into this problem in the future, the way we resolved this was by taking the temp tables (both of them), and adding them into the Permissions/Tables section of the privilege corresponding to the menu item that calls the report. It doesn't make sense, but it worked!
Thanks
Share
Report
All responses (
Answers (
