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 Chriss Miller 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: MB57630
  • Content: Threads
  • Order by date
  1. MB57630

    Sum records without supressed amounts.

    thread767-1436620 I have a report where the records are visually suppressed if there are duplicates. It is not suppressing the row, which is how I want it, but when I total the amounts it is totaling all the values, including the suppressed amounts. Is there a way to total the amounts like the...
  2. MB57630

    Select Case Statement in a crystal command

    I am trying to create a command in crystal with the following and I keep getting errors...somethin about an interval qualifier at the end of the statement. Any ideas?? SELECT * FROM KCMS.FCT_WEK_LVL_COU WHERE CASE WHEN rpt_cd in ('58','59','60','62','63') Then 'LCM Themed' WHEN rpt_cd...
  3. MB57630

    Concatenate comments for a contract - multiple records.

    I have a report that is pulling several thousand contract records because the comments create a new record each time they are entered. I would like to concatenate the comments into a single record.....at least the first 5 comments. I found the following solution and it would have worked but it...

Part and Inventory Search

Back
Top