I am trying to create a report that lists all the checks processed each day which includes both purchases and payments. I need to use a subquery to make it happen. The report complains with an error "TenderEntry.TransactionNumber" could not be bound..... I can run the query just fine inside SQL Management Studio.
Does anyone have an example of this type of query that works with Active Reports?
thanks,
Keith
After further experimenting, I found the solution to the problem. I had to us an alias (AS te) for the TenderEntry table. Then it worked in the Active Report.
Interesting that the query without the alias worked just fine when executed in SQL Management Studio....
Keith
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.