Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7
This is the forum to discuss the Wrox book Professional SQL ServerReporting Services by Paul Turley, Todd Bryant, James Counihan, George McKee, Dave DuVarney; ISBN: 9780764568787
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old February 4th, 2007, 02:42 AM
Registered User
Join Date: Mar 2006
Location: Toronto, Ontario, Canada.
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default Matrix report issue

I developed a report using the new matrix control. In the report I have 2
rowsgroups(monthname of the orderdate as parent,the orderdate as the 2nd one)
and 1 columngroup(year of the orderdate). In the details field i have 4
column fields Ordercount,Order valuee in $'s, Shipped value in $'s,Total
Shipped value in $'s.

In my dataset i have restricted it for 2 years 2005 and 2006. the report
runs as desired breaking the month datewise and showing the values of each
date for the 2 years side by side.

The problem however is that i need to add a new column at the end,i.e.,
after the value for 2007 has been rendered.

In this column i need to find out the difference between the ordercount in
2007 as compared to 2006 for each date monthwise.

Can any one please tell me how can i access the ordercount values for a
particular date for the 2 year values and put the difference in the new
column at the end.

The report shud look something like this

                          2006 2007
January ordcnt ord($) ship($) tot($) ordcnt ord($) ship($) tot($)|C
1/1/2007 2 25 50 70 15 56 400 50 13
1/2/2007 3 100 150 200 45 566 456 456 42
1/31/2007 6 300 430 600 56 356 567 563 50

I just need to put in place the last column depicted by C above which is the change in ordercount in the matrix report. Any help will be greatly appreciate.


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing Report on Dot Matrix Printer ashu_from_india Crystal Reports 27 April 20th, 2011 12:56 PM
Displaying Matrix Report Ahmed-Deq Classic ASP Basics 3 February 19th, 2008 11:56 PM
fusion between matrix and tabular report.. johnnygut Reporting Services 0 November 16th, 2006 04:15 PM
matrix report rhbandagi Classic ASP Databases 0 March 24th, 2006 04:06 AM
matrix report output saravananedu Oracle 1 March 3rd, 2005 10:20 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.