Wrox Programmer Forums
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
Old January 4th, 2008, 02:45 PM
Registered User
Join Date: Jan 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Creating a report and need assistance w/ SQL Logic

I am working on below report.
The report has actual hours and forecast hours grouped by resource
name on a monthly basis per project.
I am utilizing a matrix and it looks like below.

Resource Name

                  Jan-07 Feb-07 Mar-07
             Actual|Forecast Actual|Forecast Actual|Forecast
Project Name1
Project Name 2
Project Name 3

The actual and forecast hour information is stored in two views along
with month and project name information. I am doing a union of the
the two views to produce the above matrix view.

Now, I need to add 'variance' difference between actual and forecast
hours in the mix. The new matrix should look like below.

Resource Name

       Jan-07 Feb-07
       Actual|Forecast|Variance Actual|Forecast|Variance
Project Name1
Project Name 2
Project Name 3

I am having trouble calculating variance in the above solution. I am
wondering if any SQL/SRS experts/gurus can help me with this problem
or suggest a different method.

Let me know if I can answer any questions to explain the issue
further. Thank you in advance for your time and effort.


Similar Threads
Thread Thread Starter Forum Replies Last Post
creating ssis packagte for sql server to sql serer Laxmikant_it ASP.NET 3.5 Professionals 0 November 26th, 2008 12:23 AM
redundant SQL logic fkish SQL Language 3 November 12th, 2007 01:28 PM
Creating report problem Vince_421 Access VBA 8 February 26th, 2007 05:33 PM
Creating report programmatically liliarum BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 1 July 6th, 2004 09:34 AM
Mixing Data access logic and business logic polrtex BOOK: Professional Jakarta Struts 0 December 15th, 2003 07:19 PM

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