[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 871
  • Last Modified:

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!

0
exibitionsoftware
Asked:
exibitionsoftware
  • 2
1 Solution
 
simon_kirkCommented:
Hi,

In Matrix controls the subtotals have 2 areas within the cell.  One for the initial cell and one for the repeating cells.

There should be a green triangle at the top right of the SubTotal cell.  Click this and then set the top border to the style you are after.  Alternatively you could set the background of the cell to a light grey to clearly indicate that it is a totaled field.

For the group title, you just need to use the group header, as this will repeat with every grouping level of the detail section.

HTH
0
 
exibitionsoftwareAuthor Commented:
HTH,

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?
0
 
simon_kirkCommented:
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).
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now