ssrs order of operation question

• stan

  SSC Eights!

  Points: 972

  More actions

  November 13, 2024 at 8:32 pm

  #4481338

  hi i need "sample size" in my report's 4th data region which is a grid with 2 additional full grid with comments.  It is shown in the image.

  i want to add a 3rd additional comment row to the same tablix .  I want its visibility to depend on "sample size" being less than 10.  I think i know how to handle visibility in a text box.  i'll have to deal a bit with the rules for the borders in these additional rows.

  from what i've seen of the report there are 2 ways to find sample size <10...

  1. the last column in this grid's core dataset is 'N/A' when the sort field in that dataset row is 3.   there can be at most 1 row with sort field = 3 but i believe there might be no rows where sort field = 3.    if an N/A appeared, the sample size had to be less than 10.
  2. count(*) from a table inserted to with this user's samples BY the 3rd dataset (via proc) of 8 datasets in this report.   the predicate would be where userid=parameter @userid.   the core dataset for this grid (4th region) is the 7th of 8 datasets.  and it actually depends on the table to which the inserts were made for this user by the 3rd dataset.  but those total counts below but "attached" to the grid come from totally different datasets in this report.

  the biggest question i have is on order of operation.   and this is my preferred approach.   how can i be sure that if i add a dataset that gets sample size and sets the value of a new internal parameter, that it will run after that 3rd dataset that inserts records for this userid to that table i mentioned and before my new text box needs that count?  it would use count(*) ...where...

  ...or if the expression in this new text box instead depends on this grid's core dataset, that i can locate the value in the row marked with a sort value of 3 if such a row even exists?

  

   

  • This topic was modified 4 hours, 52 minutes ago by  stan.