This is a migrated thread and some comments may be shown as answers.

MultiDatasources

2 Answers 48 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Arash
Top achievements
Rank 1
Arash asked on 25 Oct 2010, 10:04 AM
Hi,my problem is that I have to use more than one stored procedures for different parts of my report.
For example if I have three parts in the report I have to use three stored procedures which provide the data.

2 Answers, 1 is accepted

Sort by
0
Patrick
Top achievements
Rank 1
answered on 25 Oct 2010, 01:18 PM
One suggestion would be to create a master report, containing just the header information; i.e. company name, report title, page number and date/time the report was generated, etc. Then add the 3-subreports, the datasource of each would be the results returned by the 3-stored procs.
0
Arash
Top achievements
Rank 1
answered on 26 Oct 2010, 04:11 PM
thanks for the suggestion
if it is possible show me an example
Tags
General Discussions
Asked by
Arash
Top achievements
Rank 1
Answers by
Patrick
Top achievements
Rank 1
Arash
Top achievements
Rank 1
Share this question
or