CrystalReport with a subreport that uses a SQL StoredProcedure with Parameters.How do
:afrog: CrystalReport with a subreport that uses a SQL StoredProcedure with Parameters.
How can i make the subreport pass the parent reports Parameters to the subreports sql-stored-prcs.
i.e. how do i map parent report parameters to the subreport storedprc parameters so that it does not ask for them during VB Automation?:afrog:
Re: CrystalReport with a subreport that uses a SQL StoredProcedure with Parameters.How do
Right click on the Sub-Report and then choose the "Change Sub-Report Links" menu item. On the screen that appears it is just a matter of setting the right options. Just make sure the fields/formulas you select from the main page, have the same datatype as the parameters of the stored procedure.
