SSRS Subreports

• 88dreamer

  SSC Rookie

  Points: 33

  More actions

  December 15, 2022 at 8:14 am

  #4125900

  Hi,

  I have a main report with the following data and 3 parameters : pColumnA (single selection) , pColumnB(multiselect), pColumnC(multiselect)

  

  And I have 2  subreports:  SubreportB - containing  ColumnB values, Subreport C containing ColumnC values.If Column B has duplicates, I want to see SubreportB & SubreportC (in different pages-> 1 value= 1 page), Otherwise just SubreportC(in different pages-> 1 value= 1 page).

  In order to achieve this I have added a List with following grouping:

  

  I am able to show only subreports with more than one value in Column B with : IIF(COUNT(ColumnC)>1, FALSE, TRUE) ;

  Do you have any idea how to show Subreport C for single values, without showing the values already displayed in the first group?

  Ex:

  If pColumnA="A"

  SubreportB: 1111 | SubreportC: 1111A| SubreportC: 1111B

  Subreport :  2222A

  Thanks in advance.

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  December 16, 2022 at 9:10 am

  #4126423

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

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