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 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: *

  • Users: bbgbp
  • Order by date
  1. bbgbp

    Group Specified on a non recurring field - another twist

    Thanks for the post, LB. I should have mentioned that I'm using Crystal 8.5. The report is being run off a single SQL stored procedure which is shared by other reports, so I can't change it to do this modification within the sp. Any other ideas?
  2. bbgbp

    Modify Date Field

    Sure. Create a formula using Date(). For example, if your field is UserDateTime, create a formula using Date(UserDateTime). This will strip the time off your datetime field and just return the date.
  3. bbgbp

    Group Specified on a non recurring field - another twist

    I have a situation which I'm sure many people have run into: My recordset contains items which need to be grouped by manufacturer status. If the status of a particular item is unavaiable but other items by the manufacturer are available, the manufacturer status needs to be set to available...
  4. bbgbp

    Help with formula

    Can you post the formula you tried? Without know what you've done so far, here's an idea: Create the formula @Prompt: if weekend = ?Prompt Week then reghrs + othrs else 0 Create the formula @RestOfTime: if weekend <> ?Prompt Week then reghrs + othrs else 0 Then, create a group by...

Part and Inventory Search

Back
Top