Search results for query: *

You are absolutely correct. I provided the wrong information on what I was counting. See below for the correct Grouping and Summary information. Group 1 = command.logdate (daily) Group 2 = command.username Group 3 = command.actionnum GF1 = Count(command.itemnum) "page indexed per day" GF3 =...

That is a screen shot of the Percentage used in GF3 based on the count of itemnum in GF1 which is grouped by logdate.

Here is my select statement. --Indexed Documents select e.actionnum, u.username, u.realname, aq.queuename, e.batchnum, idp.itemnum, idp.filepath, e.logdate from hsi.scanninglog as e join hsi.archivedqueue as aq on aq.batchnum = e.batchnum join hsi.itemdatapage as idp on e.batchnum =...

Below is what each of my groups are by. And what each of my fields are calculated by. Please see the attachment for a screen shot of the percent summary. Group 1 = command.logdate (daily) Group 2 = command.username Group 3 = command.actionnum GF1 = Count(command.actionnum) "page indexed per...

The percentages are a group level summary based on the total of the group one level higher. The summury is placed in the group footer. I'm not using a manually entered formula to calculate the percentage. Maybe the attached screen shot will help...

To help with the emailing part... Use CDO to do the sending. Below is a VBScript that shows how to use CDO to send and email without getting the security prompts. Dim objMsg Set objMsg = CreateObject("CDO.Message") Dim iCounter 'Importance Const cdoLow = 0 Const cdoNormal = 1 Const...

Crystal XI

I have a report that is grouping some totals for users productivty. Once of the columns is the percentage based on the daily total. All my data is correct, but I would like to highlight either the maximum percentage or the entire row based on the maximum percentage. How can I do that?