SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Reporting grouping design- while invoking Sub report.


Reporting grouping design- while invoking Sub report.

Author
Message
Saintmount.Sql
Saintmount.Sql
SSC Journeyman
SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)

Group: General Forum Members
Points: 79 Visits: 507
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.
Attachments
Mohamed I.
Mohamed I.
SSC-Enthusiastic
SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)

Group: General Forum Members
Points: 192 Visits: 348
Hi

What element do you use ?
Matrix or table ? (i tablix row grouping only )

w00t !!!GOOGLE IS YOUR BEST FRIEND!!! w00t
Saintmount.Sql
Saintmount.Sql
SSC Journeyman
SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)

Group: General Forum Members
Points: 79 Visits: 507
HI,
I will be using Tablix for the design.

Thanks,
Mohamed I.
Mohamed I.
SSC-Enthusiastic
SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)

Group: General Forum Members
Points: 192 Visits: 348
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
Saintmount.Sql
SSC Journeyman
SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)

Group: General Forum Members
Points: 79 Visits: 507
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.
Mohamed I.
SSC-Enthusiastic
SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)

Group: General Forum Members
Points: 192 Visits: 348
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
Saintmount.Sql
SSC Journeyman
SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)

Group: General Forum Members
Points: 79 Visits: 507
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.
Mohamed I.
SSC-Enthusiastic
SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)

Group: General Forum Members
Points: 192 Visits: 348
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
Saintmount.Sql
SSC Journeyman
SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)

Group: General Forum Members
Points: 79 Visits: 507
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.
Mohamed I.
SSC-Enthusiastic
SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)SSC-Enthusiastic (192 reputation)

Group: General Forum Members
Points: 192 Visits: 348
You re welcome Smile

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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search