Hi everyone,
Thanks for the previous help@@ :) :)
I have to show the following as shown below and in the attachment.
Basically, for ticket # 121212, two different categories of errors are shown for PC Issues and Network
issues. The List needs to be GROUPed by the Ticket #, Create Date.
PC ISSUES NETWORK ISSUES
Ticket # Create Date Error Type Desription Count Description Count
121212 6/20/2016 36 Mouse problems 1 Cable Problems 10
Keyboard Problems 4 NIC Card Problems 20
OPS Problems 5 Network Software 60
So, I have created the subject Q in Framework Model with two different Subject Q's and Created two lists in Report Studio, one for PC ISSUES and ONE FOR NETWORK ISSUES and it is working. It looks good except when there is additional Network Issues but the rows of PC Issues end, I don't know how to make sure the page breakdown happens correctly. In the other word, have the page to breakdown when the the LONGER LIST is finished so the user can see the GROUPING # (Ticket #) or the it runs to the next page but without the TIcket #. So, they can't tell which Ticket # belongs to the remaininig listing from the Networking issues.
Thanks so much for your time. I greatly appreciate it. :) :)
My apologies guys, :D
I attached a better mockup explaining my issue. So. the left listing (PC ISSUES) is shorter than the right listing (Networking Issues)so, I'm trying to somehow make the both listing to end at the same LINE rather than one GROUP breaks down before the other GROUP.
Thanks again for your recommendations and here is a better attachment.
group span property can help in this scenario
OK, let me try it. Thanks so much
Ok, Question:
I have only four data items to work with for presenting these types of Issues.
TICKET #,
CREATE DATE
ERROR TYPE
DESCRIPTION
So, if I create two Queries within Report Studio with different Query Filters and drag the column into a single list,
would that work? In order to keep the NETWORK ISSUES Description and Count at the same TOP level as it shows
in the mock up.
I hope I don't have to write a customize SQL to drive this.
8) 8)
Let me know what you recommend.
Thanks a lot!!
No worries! I had to anchor the queries to a master query for each list.
I surprised myself to be honest!! :o :o :o ::)
- Used three Queries in Report Studio. One Master and two with filters for different Types.
Dropped one Master List and Two Children List into the Master List.
Established Group Span.
Hided some of the columns in Children.
Works like a charm.
Thx a lot!