sub report

[daniel_b]

Hi everybody!
I want to know if there is an option to add a sub report to a report in vb6. I know that it can be done in access very easily, but I don't know how to do it in vb...
thanks.
Daniel

[Hack]

Other than the printer object, VB has no reporting capabilities. What software are you using to produce this report?

[daniel_b]

I meant sub-report for the datareport designer... sorry if it wasn't clear enough...
In access I had no problem to make few sub-reports for every report... in vb I just can't find how...

[brucevde]

The DataReport is pretty limited and does not support sub-reports.

[daniel_b]

Do you know about a tool that will support it?

[brucevde]

The only reporting tool I ever used is Crystal Report which does support sub-reports and has loads of features. Not sure if the free version (4.6 - current version is 11) which comes with VB supports sub-reports. Check in the \Common\Tools folder your VB CD.

It might be possible to simulate sub-reports in DataReport using a Hierarchical recordset but I would need more information about the layout and requirements of the report.

[daniel_b]

Well... thanks... I don't have crystal report v.11... And the free one doesn't support it...

My problem with your second idea, is that I need more then one sub report, and the report-writer doesn't support recoredset with two child commands...
For more info about the exact structure I need you can look here (http://www.vbforums.com/showthread.php?t=394348)
Thanks alot
Daniel