Reporting grouping design- while invoking Sub report.

Question

Post reply

Reporting grouping design- while invoking Sub report.

Saintmount.Sql

Ten Centuries

Points: 1023
More actions
May 25, 2013 at 1:02 pm

#277817

HI,
I am working on SSRS Grouping with Subreport. I’m trying to get solution for the issue. But I'm unable to achieve it.
Please let me know if anyone know regarding the below issue.
Please find attached screen for more clarity.
Thanks in advance.
Regards,
SaintMount.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Mohamed I. SSCrazy Points: 2774 More actions · Answer 1

Hi

What element do you use ?

Matrix or table ? (i tablix row grouping only )

:w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t:

Saintmount.Sql Ten Centuries Points: 1023 More actions · Answer 2

Saintmount.Sql

Ten Centuries

Points: 1023

May 25, 2013 at 5:08 pm

#1618555

HI,

I will be using Tablix for the design.

Thanks,

Mohamed I. SSCrazy Points: 2774 More actions · Answer 3

maybe the subreport element has not been correctly configured ?

How do you call the subreport ?

Are the parameters well configured ?

Is the subreport path correct ?

:w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t:

Saintmount.Sql Ten Centuries Points: 1023 More actions · Answer 4

HI,

I've subreport item in Main report.

I will be invoking the subreportin general property ( by selecting subreport in drop down list)

parameter mentioned as -> =Join(Parameters!GroupLEVEL3DATADistrict_ID.Value, ",") in sub report property parameter section & to pass value subreport.

Subreport

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

Dataset parameter ->=Split(join(Parameters!GroupLEVEL3DATADistrict_ID.Value,","),",")

Thanks

Mohamed I. SSCrazy Points: 2774 More actions · Answer 5

Why do you use a "Parameter!" ?

Maybe you need to use a "Field!", because the call to the subreport must be linked to a data value that comes from the tablix located on the parent report

i think it is not a good idea to use the split/join method

did you test correctly the subreport ?

:w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t:

Saintmount.Sql Ten Centuries Points: 1023 More actions · Answer 6

Awesome!...

When i use "Field!"value in subreport working fine.

Another thing is,I trying to display No data Message when particular sub report don't have records.

Can you give me idea on these.

Thanks

Mohamed I. SSCrazy Points: 2774 More actions · Answer 7

Yes you must set the configuration of the tablix on the subreport

- It is called something like 'no row message'

You have to put a text on it

But I am not sure the parent report will consider It

You have to test

:w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t:

Saintmount.Sql Ten Centuries Points: 1023 More actions · Answer 8

Hi,

I've applied in sub report level.

Sub report group properties->visibility(show or hidden based on exp)

=IIF(RowNumber("DataSet") > 0, False, True)

& Mentioned no row message in sub report tablix property...

I'm getting No data message along with Empty space ( its equivalent to sub report page size).

Trying to suppress the empty space.

Thanks

Mohamed I. SSCrazy Points: 2774 More actions · Answer 9

You re welcome 🙂

If you want to suppress the empty space, it must be set on the parent report i think

You need a flag coming from the subreport saying "no row" and then hide the line

Mohamed

:w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t: