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

  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.

    You are teh MAN!! or woman......lol....thanks so much!!
  4. MB57630

    Concatenate comments for a contract - multiple records.

    I have the report grouped only by contract.The multiple comments are at the contract level and I set up the formulas as suggested in the comments. It is a large report with many contract details but I only need the first 5 lines of the comment section. I am using CR2008.
  5. 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