Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
worldsoft
Starting Member
2 Posts |
 Posted - 2007-11-28 : 13:10:59
|
Hi. I have a report which has several datasources which require a table to be populated before they read from it. i.e. The first thing that needs to happen whenever the report is run, is a call to a stored procedure which populates the table the report datasources are based off of. The SP takes several minutes to complete and MUST complete before any of the datasources fetch their data.How can this be achieved?I can not find anything in the Visual Studio Report Designer which allows to me to instruct Datasource B to not execute before Datasource A has completed (or any other way to call a data population SP, before the data reader SP's execute). Thanks. |
|
|
tm
Posting Yak Master
160 Posts |
Posted - 2007-11-28 : 14:29:48
|
| Create another report as a main report to call the stored procedure. Put your actual report that you have already created as a sub report.This should run your main report stored procedure first to populate the table and your sub report displaying the new data.I did a quick test and it seems to work. |
 |
|
|
worldsoft
Starting Member
2 Posts |
Posted - 2007-11-29 : 02:57:20
|
| Thanks TM, that seems to have done it.Will require some thorough testing before I know for sure.Thanks :) |
|
|
|
|
|
|
Pre-Populating Report Tables