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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Main Report Field not working as parameter in SQL Expression
Kray4660, Thanks for the suggestion. I should have mentioned that I already tried that. When I did. It gave me the "cannot bind multipart identifier timItem.ItemID" error. I can't seem to get around this error regardless of how try and demarcate the actual parameter field. The above is the only...- DrBrentRD
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Main Report Field not working as parameter in SQL Expression
CR 10.0.5.820 For Sage I have the following SQL Expression that doesn't work. The issue is with the last select statement which tries to pull the criteria from the main report ("timItem"."ItemID") table, which is the same table both of the nested queries are using. I've tried every permutation...- DrBrentRD
- Thread
- Replies: 3
- Forum: Business Objects: Crystal Reports 1 Formulas
