SSRS Report Parameters Interactive

• gp-sql-novi

  SSC Veteran

  Points: 285

  More actions

  June 19, 2019 at 4:36 pm

  #3655352

  Hi,

  I have a table that has a dept_id, sect_id, div_id, item_id, and description.  The data will be reported on base on the users entry on dept_id, sect_id, div_id and item_id. For some reason I cannot work out the parameter entries in such a way that it is interactive depending on the user input. I mean when user

  • Input dept_id, the sect_id will be automatically populated with all valid sect_ids with the same dept_id, and div_id will be pre-selected base on dept_id and sect_id combination
  • When user input sect_id with entering dept_id, then dept_id will be pre-selected base on the sect_id and div_id will be populated base on dept_id and sect_id combination
  • When user input div_id then sect_id will be populated together with dept_id

  So far, I was able to do the first one, by setting a query/dataset on the default values and available values on the parameter properties but not the second and third,i'm getting error like a "forward passing... not supprted" sort of error.  The 3 parameters can accepts null and blank set on their properties.

  Sample data below:

  Dept    Section    Division    Item     Description

  1          1              1               1          Data 1

  1          1               1               2         Data 2

  1          1               2               3         Data 3

  1          1               2               4         Data 4

  1          2               3               5         Data 5

  1          2               3               6         Data 6

  2          1              4                7         Data 7

  2          1               4               8         Data 8

  How do I set up the report to achieve the behaviour I want, any clue or ideas will be much appreciated.

  Thanks

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  June 20, 2019 at 5:10 pm

  #3655858

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.