Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Reporting Services Newbie Expand / Collapse
Author
Message
Posted Wednesday, February 13, 2008 9:37 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 14, 2012 4:42 AM
Points: 2, Visits: 14
I am new to SQL 2005 Reporting Services

I have the following report in a Reporting Project

ATLANTIC
Volume 44274 5541 3045
FTE 478.966 49.987 25.857
Over 8 FTE 27.463 2.316 2.56
CMB
Accs 10211 6358 477
FTE 254.483 114.3 63.073
Over 8 FTE 14.285 8.839 5.721

I need to create an Expression that would take the Volume and divide it by the Sum of FTE and Over 8 FTE.
Volume, FTE, Over FTE are a Group called "Flag".

Post #455177
Posted Saturday, February 16, 2008 9:05 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:07 AM
Points: 11,157, Visits: 12,899
First off, you probably would have gotten quicker response had you posted this in the Reporting Services forum.

Your expression sounds fairly simple to me, if I understand correctly. In the textbox where you want the expression (or in computed field in the data set) set the formula to: =Volume/(FTE + Over 8 FTE). Based on what you are saying they are all at the same group level. If they are at different group levels you can reference the textbox values using the ReportItems collection. I can't remember the exact syntax, but you could use BOL to find the syntax. It would be something like: =ReportItems!VolumeTxtBox.Value/(ReportItems!FTETxtBox.Value + ReportItems!Over8FTETxtBox.Value)




Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #456637
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse