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!
Search results for query: *
- Users: thethuthinnang
- Order by date
-
SQL for Multiple Databases?
I am a n00b to Crystal and SQL so I hope I can explain this properly. I am trying to query multiple companies that would be selected by the user. So I need to be able to allow multiple values for the parameter {?CompanyCode} below. A simplified version of my SQL query: SELECT...- thethuthinnang
- Thread
- Replies: 1
- Forum: Business Objects:Crystal Enterprise
-
Need to look in a second table when a record is not in the first table
The left table is orders_invoice and they are linked with doc_ctrl_num. I am also experimenting with SQL - UNION but no luck with that yet. I'm really new to Crystal and databases in general.- thethuthinnang
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Need to look in a second table when a record is not in the first table
I am trying to add a field to my report from one of two tables. If the record doesn't exist in the first table I want Crystal to look for it in the second. The result of this formula is a blank report: If IsNull({arp.due_date}) Then {art.due_date} Else {arp.due_date} Can I do this with a...- thethuthinnang
- Thread
- Replies: 3
- Forum: Business Objects: Crystal Reports 1 Formulas
