Search results for query: *

It's not that I am not providing the necessary information, I would gladly share all of the information. I guess I don't quite understand what it is you need to see in order to help. I am real new at this, so I appologize for my lack of understanding. -Sorry you gave up on this. Anyone...

estimate was not an attempt to implement your earlier suggestion? estimate is the percentage adjustment to the prior years actuals. Group #1 Name: @fund Group #2 Name: @DEPT Group #3 Name: @type Group #4 Name: @CRECode When I modified the estimate variable with your formula, it changed the...

Sorry. Guess I missed a few answers, was a long day. (PH) 2006 (GH1a) @estTotal whileprintingrecords; //Sum ({@YTDAmount}, {@fund}) {@Yr1Total} (GH2) @reset whileprintingrecords; numbervar estimate:=0 (GH3) @estimate Sum ({@YTDAmount}, {@Type})*{@factor2} (details)@estimate Sum...

Sorry- Report Structure looks like this: Year 2004 2005 2006 2007 2008 (GH1a) 100.00 250.00 515.00 XXXXX XXXX Revenue (GH3) 100 125.00 137.50 150 180.00 (GH3) 1,000 1100 1200 1300 1300.00 (GF2) 1200.00 1475.00 XXXXX XXXXX XXXXX Expense (GH3) 900.00 910.00 1000.00 1100.00 1100.00 (GH3)...

If I understand this right, it is actually summarizing the prior year's data with this command Sum ({@YTDAmount}, {@Type})*{@factor2}. The YTDAmount is in reference to 2005 actuals. When I try to build a running total, there are no tables or fields that match up to the 2006 calculated data...

Hello, I'm unable to do something that should be straight forward... I'm using CR 9 with SQL. In my report I have 5 columns (2004, 2005, 2006, 2007, 2008). 04 and 05 are actual YTDAmount numbers from SQL data base. 06, 07, 08 are based on a formula (05*factor of %increase). In the group...

After re-reading my post, i guess i was not real clear. in each section i have a beginging total, total revenue, and total expense. I am trying to sub-total those three sections in multiple fields per column. Maybe i am still not clear. 8,114.80 begining number 112,183.95 revenue subtotal...

CR 19 ODBC [RDO] CONNECTION SQL DATABASE i have a report that is 4 columns. columns 2-4 are based off of column 1. i.e. column 2 is a percentage factor of 1. I can sum the y-t-d total for column 1 in GF2, but can't get grand totals from the sub totals in columns 2-4. example: 2004...

I have not figured out how to sum the calculated columns, how did you do that?