Share
Report
1,669Hi 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
All responses (
Answers (
