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

Report Grouping Expand / Collapse
Author
Message
Posted Tuesday, November 05, 2013 11:19 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 04, 2014 8:08 AM
Points: 123, Visits: 100
Grouping Question - Best advice

Here's my dataset

DocNum ItemNumber ItemType QtyOnHand

MO001 Item A LotTracked 5

MO001 Item B NotTracked 100

MO001 Item C LotTracked 2

MO001 Item D SerialTracked 10

MO002 Item A LotTracked 5

MO003 Item D SerialTracked 10

I have a report - user enters parameter - DocNumber

First Group is DocNumber (only group right now)

I want to add a second group (I think) which is dependent on Item Type (Item Type will always be one of three variables and will always be the same for every item number.

If a document (like MO001) has three different item types I would like three different displays - one for each type - in this group (?). Example

MO001 - Group 1

NotTRacked (Group 2 or is it details/body?)

Item B

LotTracked (Group 2/3 or is it details/body?)

Item A

Item C

SerialTracked (Group 2/4 or is it details/body?)

Item D

What's the most logical way to achieve my desired result? Do I create three groups (one for each type?) and 'hide' if no data is part of dataset?


Any advice/guidance is appreciated..........











Post #1511573
Posted Monday, November 11, 2013 6:34 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 1:10 PM
Points: 3,015, Visits: 1,250
Within your tablix you have a group (DocNumber) and a details row at present. Create another group level between the two existing items, by adding a child group to the DocNumber level, or a parent to the details level.

Your group level should now be DocNumber...ItemType...(Details).

Fitz
Post #1513119
Posted Tuesday, November 12, 2013 9:37 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 04, 2014 8:08 AM
Points: 123, Visits: 100
Thanks - that's what I ended up doing. Works great except having hard time getting the DocNumber group to repeat on each page. Group Properties doesn't do it - I researched and another forum suggested using advanced mode in grouping - but every time I tried that I got an error message.

I'll eventually figure it out.............thanks for your response.

This forum is really a great asset to anyone trying to learn a challenging subject.
Post #1513524
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse