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

Applying Custom Grouping Expand / Collapse
Author
Message
Posted Wednesday, September 29, 2010 5:08 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, November 25, 2013 3:38 AM
Points: 10, Visits: 68
Hi guys,

I was wondering if someone can help as I am new to SSRS reporting services.
I have developed a simple report using one view.
This report runs well but I have encountered one issue.

So far the reports looks like this:

1st Main Group is by email address and within that there is another group displaying four priorities which are also grouped. So this is the layout:

EMAIL
Priority 1 (details)
EMAIL
Priority 2 (details)
and so on....

I have created a page break but it does it for each EMAIL group therefore each Priority is displayed on a seperate page.

I need it to show one EMAIL group displaying all Priorities on one page
(in total there are four email addresses that will have four different priorities).
Apologies for the lengthy explanantion.

Thanks in advance
Post #995085
Posted Wednesday, September 29, 2010 8:35 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, January 13, 2014 10:46 AM
Points: 509, Visits: 14,593
If you set the page break on the email group and don't page break on priorities, you should get something like this:

email1
priority1
priority2
priority3
priority4
----page break----
email2
priority1
priority2
etc.

Are there details below each priority or can you make the priority the detail-level group?
Post #995299
Posted Wednesday, September 29, 2010 10:22 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, November 25, 2013 3:38 AM
Points: 10, Visits: 68
Hi thanks for your reply.
I managed to do what you have suggested.
I created many groups which caused the report not to be properly grouped.

Cheers
Post #995419
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse