Master / Detail and SQL Server Stored Procs

rbuser

I'm currently in the processes of trying to see whether I am able to convert
from Crystal Reports to ReportBuilder.
The problem I'm having is creating subreports in detail bands and linking
the subreports to a field in the master.
I am using Stored Procedures all the time which take in the linked field (as
a parameter) in order to retrieve
the relevant detail records.

Now in crystal you simply assign the Linked Field in the master to the
parameter for the stored proc which the
subreport is based on. I realize that Report Builder doesn't support SQL
Server Stored Procs so
how can you simply call up a report which takes in a master fieldID which
then calls the stored procs
filling in the parameters as and when it needs to so all the subreports are
called and the Linked Field cascades
down the report?

Thanks in advance

James.

digitalmetaphors

ReportBuilder doesn't handle this for you because Delphi already does.

You'll need to set up the TStoredProc components and link them so that
parameters are supplied to the detail stored procs as the record position
changes in the master stored procs. The Delphi help should address all of
this...

--
Cheers,

Tom Ollar
Digital Metaphors Corporation