Search results for query: *

thanks for your help

I'm pulling information for the in the Select Section for current month based on the formula below: Month ({v_bss_GDI_Attendance_B.DateStamp}) = Month (CurrentDate) This works well until I have gone 1 full year and I have two January's then I will have two entries for January (one 2004 and one...

Thanks I'll try both approaches..

I have two reports that run well directly from crystal but error out on line 23 when run from RAS. I'm running crystal 9. I've stripped all subreports from the report and still have the problem. Other reports using the same ODBC run fine. The error message is shown below Thanks in Advance...

We are using Crystal 9 and tables are sequel tables. thanks for your help.. ron

I've got two tables that I need to link. Field Table 1 is AddressNo (String) to Field Table 2 ShipTo (Number). The only way I was able to do this was to link them via a formula changing the AddressNO from a string to a number using the ToNumber() function and linking AddressNO...

I'm not familiar with this type of database. The structure is as follows The master table in Database AAmmddyy.dbf with a companion AAmmddyy.cdx file Each day’s data is data is stored in a table name with a prefix (AA,AB,AC )and the days date. If I appended all the “mini” tables together...

That is correct. I want to add $100 to sum of Aaa; $250 to sum of Bbb. $0 to sum of Ccc. Using Crystal Version 9 MCODE 10/4/04 10/5/04 10/6/04 10/7/04 Aaa $168.64 $169.50 $172.32 $164.32 with $100 salary addin Aaa $268.64 $269.50 $272.32 $264.32 Bbb $165.25 $108.81...

I don't need details of employees. Only one group "MCode: Aaa,Bbb,Ccc, etc". To the sums below I would add $100 each day for Aaa; $250 each day to Bbb; $0 each day Bar; etc. Same amount every day. MCODE 10/4/04 10/5/04 10/6/04 10/7/04 Total Aaa $168.64 $169.50 $172.32 $164.32 $674.78...

I have a payroll cross-tab report that summarizes houly wages by PayGroup. I want to add constant per day for Salaried Employees PayGroups: Salary/ Sales=$150,Admin=$100,Service=$75 ,Guest=$125. Can I write a formula that adds in the salaried totals sample summary of hourly dollars are...

Thanks --- I'll start working thru the logic. rrg

I need to calculate a running total of elapsed hours for a period and so the day overtime occurrs it is shown It is simple if I run it for the entire period but I have problems when I run it for a partial period that does not include the first working day.. Example:. During Period 36 which...

I have a report that lists a %Labor by day of total revenue for several Labor categories. Is there any way that I can get a weighted average of these days and put it into the Row Totals. Is there any way to put a label on the cross tab to show what the colum name is. For example Main COl...

I've got Identical reports for three locations (Report1,Report2,Report3). The only difference is Location which is hard coded in the Select Menu. I want to set up 3 security codes Location 1 = 116 Allows Report1 to run Location 2 = 272 Allows Report2 to run Location 3 = 433 Allows...