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!

  • Congratulations gkittelson 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. crystaluser10

    Group Sorting by Formulas

    lbass - {@days}: if {@datediff}<30 then totext("Current") else if {@datediff}>=30 and {@datediff}<60 then totext("30 Days") else if {@datediff}>=60 and {@datediff}<90 then totext("60 Days") else if {@datediff}>=90 and {@datediff}<120 then totext("90 Days") else if {@datediff}>=120 then...
  2. crystaluser10

    Group Sorting by Formulas

    synapsevampire - Sorry, new at this. {@NOT Specified} is just a group name formula I'm using: if isnull({ReportsStatic.brokername}) or {ReportsStatic.brokername}="" then " *Not Specified" else {ReportsStatic.brokername} + " " +"-" + " " + {ReportsStatic.correspondentbrokercode} and same...
  3. crystaluser10

    Group Sorting by Formulas

    I do a group sort by a formula. The formula is not available to sort by. The report has 2 groups. I am summarizing the data in group 1 then calculating a percentage. Formula 1 DELQ (supressed in detail) if {@groupDelqCode}="30 Days" or {@groupDelqCode}="60 Days" or {@groupDelqCode}="90 Days"...

Part and Inventory Search

Back
Top