ADO connection using multiple tables

Comments

• mbsoft

  June 2005 edited 8:01AM

  CatchEm35 wrote:

  I need the functionality of the report server with dialog boxes, so I must use an ADO Query within the report to access a MySQL database as I understand the functionality. When I create an ADO query to use within the report, I can join two tables together and the database fields show up in the data tree. However, if I add anything else to the query, then the fileds are not accessable in the data tree. (it shows the ADO connection but no fields)
  
  If I join three tables - the data tree does not show ANY of the fields in the tables
  If I add a paramater to two joined fields - data tree does not show ANY of the fields in the tables.
  
  Is this a program limitation, error, or am I doing something incorrectly? Is there any way to access the dialogs without the ADO connection?
  
  Using the latest version dated 05.22.05

  Still something is wrong within your query.
  
  That's the reason no fileds are available in your report.
  
• CatchEm35

  June 2005 edited 8:01AM

  I did review the query for accuracy and it appears correct. I'm using the query builder, and the same queries work in other programs. At this point I believe there is a program error, in that any two tables I try may be joined but not a third.
• CatchEm35

  June 2005 edited 8:01AM

  mbsoft - you were correct, and thank you greatly. The built in query designer in fast report is causing the problem. I must admit I'm somewhat new to this and so I went to my MySQL component and designed the query there. Copy, past, and the ADO fields become available.
  
  Thank you again.