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

    Highlight Maximum Percentage

    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 =...
  2. mdsaville

    Highlight Maximum Percentage

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

    Highlight Maximum Percentage

    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 =...
  4. mdsaville

    Highlight Maximum Percentage

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

    Highlight Maximum Percentage

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

    Automate conversion of datareports to PDF then email

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

    Highlight Maximum Percentage

    Crystal XI
  8. mdsaville

    Highlight Maximum Percentage

    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?

Part and Inventory Search

Back
Top