February 13, 2008 at 9:37 am
I am new to SQL 2005 Reporting Services
I have the following report in a Reporting Project
ATLANTIC
Volume4427455413045
FTE478.96649.98725.857
Over 8 FTE27.4632.3162.56
CMB
Accs102116358477
FTE254.483114.363.073
Over 8 FTE14.2858.8395.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".
February 16, 2008 at 9:05 am
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
Consultant - Straight Path Solutions
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply