Do not run a Stored Procedure for each dataset in a report... How?

[Jair RC]

I have a Stored Procedure that returns data in different ways, depending on one parameter, for example, with some groups or just a listing. For each block of this data, I have a Dataset that runs this Stored Procedure and thus run the same report several times a Stored Procedure, generating a lot of processing in the database.

You can run the Stored Procedure only once to bring the data from the database and group them in different ways in the report itself, preventing them from being made several requests to the database?

My message is faulty? Blame the Google translator... :biggrin:

Regards,

Jair

[Edward]

Hi Jair,

If your stored procedure could be called in the way when all required for rendering report data comes during one procedure call.

We have methods for sorting, grouping and representing data as a master-detail for report data.

Please pass data to the DataSet in your application, than register that DataSet in the report Dictionary and data will be retrieved from the database only once.

Thank you.

[Jair RC]

Thanks, Edward

I'll try to do the way you suggested me.

Hugs
Jair

(Obrigado, Edward
Vou tentar fazer da maneira que você me sugeriu.
Abraços,)

[Andrew]

Ok! Let us know about the result.

Thank you.