November 5, 2013 at 11:19 am
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..........
November 11, 2013 at 6:34 am
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
November 12, 2013 at 9:37 am
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply