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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy