exibitionsoftware
asked on
SQL Reporting Matrix Table Layout
I am using SQL Reporting in .NET 2003 to convert several reports originally designed in ActiveReports for VB 6. Several of these reports require the matrix tool to pivot the data. This tool works wonderful for this task, but I have run into one very big snag. The report sub-totals on a grouping which is easy enough, but the user requires that the grouping have a line above it to show them where the subtotal is across the page (Legal-Landscape) and wants the sum to be BOLD.
I have not been able to find any way to get the line to continue for that cell across the entire page, it ends where the "detail" section begins.
Example 1 - Active Reports
Week 1 Week 2 Week 3 Week 4
March $10.00 $20.00 $30.00 $40.00
April $5.00 $10.00 $1.00 $8.00
--------------------------
Total: $15.00 $30.00 $31.00 $48.00
Example 2 - SQL Reporting:
Week 1 Week 2 Week 3 Week 4
March $10.00 $20.00 $30.00 $40.00
April $5.00 $10.00 $1.00 $8.00
----------------
Total: $15.00 $30.00 $31.00 $48.00
As you can see the line is on the wrong side basically, and I can't find any way to get it on the right side without having it duplicate for each detail record.
My last problem comes to groups, I need to have a group title appear directly above the row names.
Example - Active Reports:
Monthly Earnings:
May
June
July
Example - SQL Reporting:
Monthly Earnings:
May
June
July
Thanks in advance!
I have not been able to find any way to get the line to continue for that cell across the entire page, it ends where the "detail" section begins.
Example 1 - Active Reports
Week 1 Week 2 Week 3 Week 4
March $10.00 $20.00 $30.00 $40.00
April $5.00 $10.00 $1.00 $8.00
--------------------------
Total: $15.00 $30.00 $31.00 $48.00
Example 2 - SQL Reporting:
Week 1 Week 2 Week 3 Week 4
March $10.00 $20.00 $30.00 $40.00
April $5.00 $10.00 $1.00 $8.00
----------------
Total: $15.00 $30.00 $31.00 $48.00
As you can see the line is on the wrong side basically, and I can't find any way to get it on the right side without having it duplicate for each detail record.
My last problem comes to groups, I need to have a group title appear directly above the row names.
Example - Active Reports:
Monthly Earnings:
May
June
July
Example - SQL Reporting:
Monthly Earnings:
May
June
July
Thanks in advance!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
HTH - (Hope This Helps) ;o)
Group headings can be directly above the row as they are part of the same column. If the Group Heading and Row fields are above/below eachother, then it could just be the alignment of the cell data (Right, Centre, Left).
Group headings can be directly above the row as they are part of the same column. If the Group Heading and Row fields are above/below eachother, then it could just be the alignment of the cell data (Right, Centre, Left).
ASKER
Thanks for the help on the line, fixed that problem and I will award points accordingly. As for the group header, perhaps you could give me more details. My problem isn't actually getting the group header to display, it's where it is displaying.
In the existing report which they insist must be copied identically, the "group heading" is directly above the row name such as:
Group Heading
Row 1
Row 2
Row 3
In SQL Reporting it wants to put the Group Heading in a column to the left of the row name such as:
Group Heading
Row 1
Row 2
Row 3
Any ideas on that one?