﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>SQLServerCentral / SQL Server 2005 / SQL Server 2005 Strategies  / SQL Reporting Services Newbie / Latest Posts</title><generator>InstantForum.NET v2.9.0</generator><description>SQLServerCentral</description><link>http://www.sqlservercentral.com/Forums/</link><webMaster>notifications@sqlservercentral.com</webMaster><lastBuildDate>Sun, 26 May 2013 03:10:48 GMT</lastBuildDate><ttl>20</ttl><item><title>RE: SQL Reporting Services Newbie</title><link>http://www.sqlservercentral.com/Forums/Topic455177-361-1.aspx</link><description>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)</description><pubDate>Sat, 16 Feb 2008 09:05:56 GMT</pubDate><dc:creator>  Jack Corbett</dc:creator></item><item><title>SQL Reporting Services Newbie</title><link>http://www.sqlservercentral.com/Forums/Topic455177-361-1.aspx</link><description>I am new to SQL 2005 Reporting ServicesI have the following report in a Reporting ProjectATLANTIC						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.721I 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".</description><pubDate>Wed, 13 Feb 2008 09:37:21 GMT</pubDate><dc:creator>spittes</dc:creator></item></channel></rss>