Is there a way to display "No records" if a row group is empty?

• pkarandi

  SSC Enthusiast

  Points: 197

  More actions

  May 11, 2015 at 12:00 pm

  #398440

  I have a tablix that looks like this (grouped on Dept) to show the number of service calls for each department:

  Dept Requester Name

  -------- --------------------

  Desktop Jones

  Porter

  Harrison

  Network Howard

  Jackson

  Desktop and Network are the only two departments. The report user has a parameter on department to select "All", "Desktop", or "Network"

  Also, the user has two parameters to select a "From" and "To" date.

  Of course, if the user only selects one department (Desktop or Network), the report comes back with just those values, which is fine.

  But, my problem is when the users selects All departments. Right now, if one of the two groups is empty, it simply does not show in the tablix at all. What I am trying to figure out is: if one of them is empty, is there a way I can display "No records" for that group?

• pkarandi

  SSC Enthusiast

  Points: 197

  More actions

  May 11, 2015 at 12:16 pm

  #1797059

  Ugh... Sorry - that textual layout of the report eliminated the blank spaces.

  I'm trying to avoid doing an screenshot because the actual report has many more superfluous fields that aren't important to this problem...

• mister.magoo

  SSC-Forever

  Points: 47174

  More actions

  May 11, 2015 at 12:20 pm

  #1797061

  Without any specifics or test data, the best I can do is say -

  Make sure your dataset contains at least one row for every group (think outer join) and then within the tablix, you can have two rows in the group, one with all the columns, one with just one textbox that says "No records" or whatever. Set the visibility of each row based on the first value of one of the columns in the dataset for that group (think First(Field!column.Value)), such that the row with all the columns is visible when the First value is non-null, and the other row is visible when that First value is null.

  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]