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 dencom 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: doc1000101
- Content: Threads
- Order by date
-
Grouping formula?
Completely stumped on this one. Table 1 layout: PO Job Suffix 123 123456 001 456 123456 000 987 123456 010 Table 2 layout: Job Suffix Due Date 123456 001 12/12/2018 123456 000 12/10/2018 123456 010 11/11/2018 I need to group by job due date where the suffix...- doc1000101
- Thread
- Replies: 10
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Creating view and changing data type
Pervasive Version 11.31 Working on a crystal report and I need to link two tables, however the data types on one of the fields is different. I think the easiest way for me to deal with this is to create a new view and change the data type. For simplicity we'll say: Table A, field 1 is integer...- doc1000101
- Thread
- Replies: 1
- Forum: Pervasive: Pervasive.SQL
-
Select/Command issues
Ive got 3 tables I need in this report and one of the fields I need to link in 2 of the tables are different table1 = 001 table2 = 0010 I have tried creating a command that uses RIGHT('0000'+ISNULL(FIELDNAME,''),4) to add a leading 0 to table1. But when I try to link only inner and left...- doc1000101
- Thread
- Replies: 6
- Forum: Business Objects: Crystal Reports 4 Other topics
