January 14, 2015 at 4:37 pm
Hi,
I have a report that works fine during local development however when it is deployed to a SSRS server it is not displaying values in the parameter list, Unit. This list comes from a dataset that is filtered by a parameter called ADAuthorizations. I've verified ADAuthorizations has a value on the server and we've verified that the data for the dataset is returning from the SQL Server. It appears that something might be wrong in the filtering of the dataset with ADAuthorizations or is not displaying for some reason. Does anyone have some suggestions on why this report behaves differently on the server and how to fix it?
The dataset has an expression of UserId, an operator of In, and a value of ADAuthorizations. ADAuthorizations is an array of values.
Thanks,
Robert
January 14, 2015 at 4:59 pm
Display the parameter ADAuthorizations on the report and compare dev to live?
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply