SQL Reporting Services Newbie

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Strategies » SQL Reporting Services Newbie

SQL Reporting Services Newbie

Rate Topic

Display Mode

Topic Options

Author

Message

spittes

Posted Wednesday, February 13, 2008 9:37 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, November 21, 2014 4:14 AM
Points: 2, Visits: 16

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

Jack Corbett

Posted Saturday, February 16, 2008 9:05 AM

SSChampion

Group: General Forum Members
Last Login: 2 days ago @ 6:24 AM
Points: 10,421, Visits: 13,603

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 »

Permissions