Sub queries in Active Reports

Oct 24, 2009 1 Replies
K

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


Vote
Twitter Facebook LinkedIn
K

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

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required