As you may have heard, using a SQL-generated cursor is easier than what your attempting. To get started using the report writer with SQL code, it may be easier to use the Query Wizard to create a temp table that you can use with the Report Wizard. Once you do a few of these, you can switch to the Query Designer and the reports will be a snap. Good Luck!


>I am trying to design an report that uses informtion from three tables (calibration master, calibration details and calibration companies). I tried the obvious approach and added all three tables to the dataenvironment, and the persistent relationships (as defined in the dbc) were showing. But when I preview the report, I am unsuccessful in making all three tables move together.
>
>The calibration details (many) are related to the cal. master by the tool number (one). The calibration companies are related to the cal. master by the two letter calibration co. code.
>
>I am able to create these relationships programatically in the command window and have the tables move properly in browse mode. But what is the secret to successfully opening these three tables in a private datasession for the report? Its gotta be something obvious, but I'm not finding anything like this in help, tastrade or solutions.
>
>TIA,