Search results for query: *

I am running Crystal Reports 8.5. I have a main report and inserted two subreports. I need to know how to calculate the difference between the totals in the three reports EX. Fac RPT1 SR1 SR2 Total % Not Comp. Comp. AAAA 245...

LBass, Your suggestion worked! Thanks very much for your input. And thanks to the others for their information.

LBass, Grp 1 = Coalition Grp 2 = Business Unit Grp 3 = Facility Grp 4 = SerialNumber and I am using group 4 as my detail line. I am wanting to total the number of Laptops by the business unit or grp 2 and total the number of Desktops by business unit or grp 2. I am trying to use the running...

LBass, Your sugestions have worked great. This report continues to be expanded. I now need to have the Hardware Type field totals by business unit. In other words I need to count the number of laptops per business unit and the number of desktops per business unit. The following is what I have...

Lbass, Your suggestion worked! Thanks. I am also grouping by facility and business unit. I need to get the count for each facility and each business unit. If I have 15 machines at a facility that meet the criteria you suggested, then I need the facility group count of 15. Any suggestions?

I am using CR 8.5. Trying to generate a report using the not operator and getting erroneous information. I need the report to list all machine names that do not have a particular software on it. I am using the (Not(PCSOFT.Sftfileid) in [8420,8421,8422]). I am grouping the report by machine name...

I have the following database table and am trying to select records where the like nodeid existed yesterday, but does not exist today. The following is example data in the table. Both fields are text. NODEID DATE 110011 2003-06-02 110011 2003-06-03 111100 2003-06-02 In this...

I am trying to update a field when I have duplicate records. However, I do not want to update the most recent record. I have a date field that I have sorted by so the oldest duplicates would be listed first. Serial_No Tag_No Date U_Delete bcertu as12345 20020102 bcertu...