Filtering on dataset not working on server

• robertfz

  SSC Veteran

  Points: 200

  More actions

  January 14, 2015 at 4:37 pm

  #397873

  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

• mister.magoo

  SSC-Forever

  Points: 47068

  More actions

  January 14, 2015 at 4:59 pm

  #1770307

  Display the parameter ADAuthorizations on the report and compare dev to live?

  MM
  

  ---

  
  select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

• Forum Etiquette: How to post Reporting Services problems
[/url]
• Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]
• How to Post Performance Problems - by Gail Shaw
[/url]