Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Reporting grouping design- while invoking Sub report. Expand / Collapse
Author
Message
Posted Saturday, May 25, 2013 1:02 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 23, 2013 7:58 AM
Points: 43, Visits: 506
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.


  Post Attachments 
grouping design- while invoking Sub report.bmp (14 views, 1.48 MB)
Post #1456808
Posted Saturday, May 25, 2013 4:52 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, June 6, 2014 7:41 AM
Points: 41, Visits: 165
Hi

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

Post #1456822
Posted Saturday, May 25, 2013 5:08 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 23, 2013 7:58 AM
Points: 43, Visits: 506
HI,
I will be using Tablix for the design.

Thanks,
Post #1456823
Posted Sunday, May 26, 2013 7:32 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, June 6, 2014 7:41 AM
Points: 41, Visits: 165
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 ?

Post #1456862
Posted Sunday, May 26, 2013 9:26 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 23, 2013 7:58 AM
Points: 43, Visits: 506
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
Post #1456867
Posted Sunday, May 26, 2013 1:12 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, June 6, 2014 7:41 AM
Points: 41, Visits: 165
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 ?
Post #1456906
Posted Sunday, May 26, 2013 5:39 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 23, 2013 7:58 AM
Points: 43, Visits: 506
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
Post #1456932
Posted Monday, May 27, 2013 5:39 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, June 6, 2014 7:41 AM
Points: 41, Visits: 165
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
Post #1457069
Posted Monday, May 27, 2013 9:53 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 23, 2013 7:58 AM
Points: 43, Visits: 506
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
Post #1457124
Posted Monday, May 27, 2013 12:46 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, June 6, 2014 7:41 AM
Points: 41, Visits: 165
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
Post #1457139
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse