Search results for query: *

Thanks Synapsevampire, I tried using the CDate function instead of DateSerial. The formula compiles fine but get the same run time error, "A Summary has been specified for a non recurring field". Would appreciate feedback. I am using CR 10 Regards, AA

Hello All, I get a parameter value called ReportYear1 of Type "Date" from the Main Report. 1)Have a formula in Main Report as: @MyMain whileprintingrecords; shared numbervar reportyear := year({?ReportYear1}) This is placed in main report header 2)Have a formula in subreport as: @ReportYear...

The problem is solved. It was because of cartesian product or data inflation. In the department table for each department(Dept field) there are several work center(T_CWOC) records which was inflating the numbers. The only field that I need from the Department table was T_DSCA which I got from...

Hello synapsevampire, The data in overheadlaborhours table is as follows: Acctg_date Work_Dept Activity Acct Hours 12/08/05 601 OVERHEAD 9001-000 40.0 12/08/05 601 OVERHEAD 9102-000 8.0 ... 12/15/05 603 OVERHEAD 9101-000...

Hello All, Using CR 10. I am creating a Subreport called "Overhead Hours". The Main report is called "Overhead Dollars". There are three tables in each report. There are no variables passed from the Main to the Sub report. The Overhead Dollar report gives correct values for each Month and YTD...

Hello All, I am using CR10 with SAS datasets. I have a report with three groups: Departments.Dept Overheads1.Overhead_Type Overheads1.T_LEAC I have added "Overhead Dollars" to Group1 and then drilled down successfully to Overhead_type and T_LEAC. I now wish to add "Overhead Hours" to...

Hello synapsevampire, THANKS for your solution. It is resolved. Happy Holidays, AA

Hello All, I am using CR10 and have two Groups in the report. Group #1: Departments.Dept (Values: 603, 632, 653 etc) Formula: AMNT_Dec_Dept_Sum = Sum ({@AMNT_Dec},{DEPARTMENTS.DEPT}) Group #2: Overheads.Overhead_Type(Values:OH Dollars Fringe, OH Dollars Labor, OH Dollars NonLabor) Formula...

Thanks Synapsevampire, Have been trying to resolve the problem. Definetely, the database is not returning the data I want. I tried changing the datasource location to the same table in another location. I get the error: Failed to Open a Rowset. I tried creating a new report just for...

Thanks synapsevampire, I have placed the formula at Group Header, Group Foooter and also at the Details level. It always give 0 for the @Nov_Month. I found that when I browse the field T_AMNT it has values which are not from the table. I removed the table with Database Expert and put it back...

Hello All, 1) I am using the following CDateTime function to get data for T_AMNT field. It gives correct values for period 1/1/2005 to 12/31/2005 @TotalYearlyAmount if {TTFGLD106530.T_DATE} >= CDateTime(2005,01,01,00,00,00) and {TTFGLD106530.T_DATE} <=CDateTime(2005,12,31,00,00,00) then...

Thanks a LOT lbass. I was setting the variable MySum to 0 in the formula in which I was trying to accumulate MySum. I have corrected it and now the Sum of @CurrentDollarBCWP adds up correctly in the Report Footer of the subreport. Below is the summary of the report and subreport. 1) The Main...

I am using the following to get the Total(MySum) in the subreport. In GROUP Header whileprintingrecords; shared numbervar MainVal1; shared numbervar MainVal2; shared numbervar CurrVal; shared numbervar MySum:=0; if MainVal1 = 0 then Currval :=0 else Currval :=({@CurrentDollarBCWS}/ MainVal1)...

Hello Synapsevampire and lbass, Thanks for your response. The formula @CurrentDollarPRTM placed in the subreport Group Header gives correct result. It returns Currval. A similar formula @CurrentDollarPRTMSum(Placed in Report Footer) returns MySum instead of Currval does not return any value...

Hello All, I am passing two values from the Main Report to a subreport as follows: ***** Main Report **** whileprintingrecords; shared numbervar MainVal1 :={#RTotal1}; shared numbervar MainVal2 :={@CurrentPRTMSum}; **** Declaring the following in subreport **** whileprintingrecords; shared...

Hello lbass, Here are some more formulae that I have used in the report. 1)@CurrentAHMC = if ( ( {?ReportPeriodStart} <= {TTICST002530.T_CMDT} ) and ( {TTICST002530.T_CMDT} <= {?ReportPeriodEnd} ) ) then {TTICST002530.T_AHMC} else 0 2)@CurrentAHMCSum = sum ({@CurrentAHMC} )...

I used Export->Report Definition to print the report. It prints most but not all of the report. Some of the formulas are missing in the report. Is there another method to print the entire report. AA

Hello lbass, I was trying to get the report definition file but it seems I have one installation file missing. Will try to get it later. Below is the list of formulas used for @CurrentCostVariance which may have problems. @CurrentPRTM: if ( ( {?ReportPeriodStart} <= {TTICST002530.T_CMDT} )...

Hello lbass, My report is nearly complete except for one field. I was using the following formula for CurrentCostVariance which was incorrect: {@CurrentPRTM} - {@CurrentAHMC} I changed it to: sum({@CurrentPRTM},{DEPARTMENTS.DEPT}) - sum({@CurrentAHMC}, {DEPARTMENTS.DEPT}) This formula...

Hello lbass, I am not sure if I have to open another thread. Since this is related to the last query I am requesting it in the same thread. I used the Insert-> Summary on @CurrentPRTM to create (Sum of @CurrentPRTM). I am now trying to find variance as follows: @CurrentScheduleVariance =...