Custom data processing extension with dataset

I have been getting to grips with writing a custom data processing extension for using a supplied dataset. I have got it working OK so far, but I don't see how to make use of relational data. There's plenty of code for walking through the fields, but nothing to walk through the tables. Since this clearly has to be possible can someone tell me where I'm going wrong?

Thanks

John Williams.

John,

A CustomReportItem only has one reporting services dataset, which is only a single table, so there are no tables to walk through.

Ian|||

This seems extraordinary! Is there really no way of reporting on more complex data when using a data processing extension?

I suppose theoretically it might be possible to write one dpx for each table, using one table in the main report and one in a sub-report, etc. But when running the reports how would you pass the dataset across ensuring that each dpx received the data that it needed?

We were hoping to use SSRS as a drop in replacement for Crystal Reports, but this is a major blow as it will mean extensive rewriting of our application in order to store the data in to temporary tables in SQL server in order to report on it, and then delete the data afterwards.

|||
Each subreport has its own datasets, separate from the main report's datasets. It is just that you can only have one dataset per data region.

Ian