Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kuberacupidagra

    Subreport: A summary has been specified in a non-recurring field

    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
  2. kuberacupidagra

    Subreport: A summary has been specified in a non-recurring field

    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...
  3. kuberacupidagra

    Joining three tables in a Subreport

    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...
  4. kuberacupidagra

    Joining three tables in a Subreport

    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...
  5. kuberacupidagra

    Joining three tables in a Subreport

    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...
  6. kuberacupidagra

    Null values

    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...
  7. kuberacupidagra

    Adding Totals in Detail

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

    Adding Totals in Detail

    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...
  9. kuberacupidagra

    cdatetime function for Year and Month

    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...
  10. kuberacupidagra

    cdatetime function for Year and Month

    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...
  11. kuberacupidagra

    cdatetime function for Year and Month

    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...
  12. kuberacupidagra

    Subreport Formula

    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...
  13. kuberacupidagra

    Subreport Formula

    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)...
  14. kuberacupidagra

    Subreport Formula

    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...
  15. kuberacupidagra

    Subreport Formula

    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...
  16. kuberacupidagra

    Sum Formula

    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} )...
  17. kuberacupidagra

    Print Entire Report

    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
  18. kuberacupidagra

    Sum Formula

    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} )...
  19. kuberacupidagra

    Sum Formula

    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...
  20. kuberacupidagra

    Sum 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 =...

Part and Inventory Search

Back
Top