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!

exibitionsoftwareAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
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

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.