Hi thanks for welcoming me , you have helped me (and I'm sure many other people) with your work. I for one am very appreciative, thank you!
With regards to the questions, yes a regular SQL command works fine and I am using an ODBC driver. It is PL/SQL blocks that seem to cause errors (but the blocks are not incorrect since they work fine in the Rapid SQL and TOAD tools).
For now however, that^ is not important if I can figure out how to do what I want with these subreports. I can try to clarify what I am trying to do again.
I have one report that runs perfectly well (record selection done using SQL command). Now I want to create another report that uses a different datasource from the first report but uses two columns from the first report (the field data in the details section) to use as part of the selection criteria in the second report (same column/table type).
This is possibly better understood using an example:
Suppose I have a report where one of the fields in the details section (a column of data) returned is a date. Each record can have a different date. Now I want to make another report suing a different datasource that will select records using that data from each record in the first report as selection criteria in the new report because the table in the different datasource has a column which is of date type and I can set the date type in that colum to >= to the date in each record from the first report to select data.
^ This is suprisingly difficult to explain!
Anyway, I'm not sure how to make this happen.
IP Logged
