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!
-
Query runs in SQL Server not in Db2
The following query runs fine in SQL Server but cracks when run in Db2. Is there anything I can do to optimise it? Any help would be appreciated. select i.itemkey, ix.itemname, ix.itemshortname, ix.color, ix.itemsize, ip.price, ip.saleprice, ip.sale_price_start, ip.sale_price_end... -
Strip unwanted commas from text object if value is null
I am new to Crystal Reports. I am using version 8 against DB2 database. I have a text object that displays 3 different fields from the database. The values are seperated by commas. field1, filed2, filed3 If the values are null I do not want to display hanging commas. Is there a formula I can...- mpunhani
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 1 Formulas
