Sub queries in Active Reports

Point-Of-Sale Software - - MS Point Of Sale software discussed here 

Yahoo!   Google   Windows Live   del.icio.us   digg   Netscape

Subject Author Date Sub queries in Active Reports Keith 10-24-2009  RE: Sub queries in Active Reports Keith 10-26-2009
Posted by Keith on October 24, 2009, 4:24 pm Please log in for more thread options 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 Posted by Keith on October 26, 2009, 9:01 am Please log in for more thread options 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 Similar Threads Posted Repository of queries and reports November 17, 2007, 10:32 am Fonts in RMS Active Reports September 26, 2007, 1:14 am Active Reports *.qrp does not exist September 16, 2008, 12:22 pm Date Filtering in RMS Active Reports November 8, 2006, 4:01 pm Finding null or no values in active reports November 20, 2005, 11:34 pm Manager should allow Active Reports to be organized in folders April 17, 2006, 5:00 pm Add font capability to Report Columns in Active Reports February 20, 2008, 12:56 pm General Queries July 26, 2007, 3:14 am RE: LIST OF SQL QUERIES FOR RMS April 6, 2008, 1:59 pm RE: LIST OF SQL QUERIES FOR RMS April 6, 2008, 10:16 pm