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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
String Problem
I have a Database which uses a String Data Type for an Invoice Number. I have designed a Crystal Report to prompt for value(s) which are used as Invoice numbers to query the Database. I have based the Group Sort on the Invoice Number. My problem is during a print preview numerals which are not...- sl71
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Formula to check for keywords in detail line(s) to enable formatting.
Thanks lbass. After I implemented your second formula it worked perfectly. I realise I was a little short on detail in my description and greatly appreciate your assistance.- sl71
- Post #5
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Formula to check for keywords in detail line(s) to enable formatting.
Thankyou for your assistance lbass. Have tried what you suggested but it suppressed no matter whether Consulting 3 was present or not. Appears the Sum formula counts the number of Consulting 3's present for the total print run (in my Example 10 invoices with Consulting 3 appearing 2 times)...- sl71
- Post #3
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Formula to check for keywords in detail line(s) to enable formatting.
I have a Crystal Report which is acting as an Invoice. My Detail Section contains a Product Name field which can contain records Consulting Consulting 2 Consulting 3 Parts There is often a mixture of these items in a report. I wish to suppress a text field in the Page Footer section of the...- sl71
- Thread
- Replies: 4
- Forum: Business Objects: Crystal Reports 4 Other topics
