Search results for query: *

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

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

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

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

I have a formula called @CurrentBCWS and when I browse the data it gives two values: 3913 and 4338. I create another formula called @CurrentBCWSsum = sum({@currentBCWS}) and the value is: 267,870. What could be going wrong here. Thanks for your help. AA

Hello All, I am using Report -> select expert to pull YTD data. I am trying to populate another field called monthly data. How can I pull in the entire YTD data and then extract monthly data from it. Thanks, AA

Hello All, Is there a way in Crystal Reports to prompt user to input a value(suppose for the month of a year)and then use that value to select records. Thanks, AA

Hello All, I wish to print my entire design part of the report(not the data). I would like to print the design part of report, plus the formulas, plus the groups etc. associated with the report. As of now I can only send the report to the printer and not the formulas, groups and other details...

My Crystal Reports is reading SAS datasets. These datasets are on a server and I can read it fine. I now copied the datasets to my Thumb Drive(Z Drive) along with the Crystal Reports. Now the formulae give errors and when I browse for data they are empty. The report has not changed and also...

Hello All, I have grouped the below data by T_CWOC. I can drill down the Work Center and get details of T_PRTM and T_AHMC. Both T_PRTM and T_AHMC are summed fields. There are some other fields in the report which are formula fields. Work Center Department Production Time Man Hours...

Hello All, I have a field named Production Time(PRTM) which is updated in the table once a month. I have to report the accumulated PRTM for the year, basically, YTD_PRTM. I am extracting todaymonth from current month and totalling for the year. todaymonth = month(currentdate) For todaymonth...