tags:

views:

10

answers:

1
Q: 

SSRS - Dataset(s) order of execution

I have a report that runs a Stored Procedure in Oracle. This procedure fills several tables with data in Oracle. I then want to query those tables and load several Tablix(s) in my SSRS report. I need the Stored Proc to run first. How can I ensure the Stored Proc runs before the DataSet queries that I use to fill the Tablix(s)?

A: 

This is a perfect explanation....

http://blogs.msdn.com/b/robertbruckner/archive/2008/08/07/dataset-execution-order.aspx

MikeTWebb  2010-10-27 16:22:18

related questions

.NET Table Adapters: Get vs. Fill?
How can I read multiple tables into a dataset?
.Net: Convert Generic List of Objects to DataSet
Synchronize DataSet
How to wire a middle tier of Objects to a data tier consisting of a DataSet?
How do I refresh the relationships in a dataset?
What triggers ConstraintException when loading DataSet?
Why is a SQL float different from a C# float
Point ADO.Net DataSet to different databases at runtime?
Should I return a strongly typed dataset from a webservice?
How many DataTable objects should I use in my C# app?
How to convert Typed DataSet Scheme when one of the types was changed?
DataSet.Select and DateTime
Select rows in dataset table based on other dataset table
Object initialization in C# (.Net)
What are the disadvantages of Typed DataSets
Read Access File into a DataSet
DBUnit dataset generation
Handling XSD Dataset ConstraintExceptions
VB.NET Get underlying system.type from nullable type
Get the DefaultView DataRowView from a DataRow
PHP Script to populate MySQL tables
C#: What Else Do You Use Besides DataSet
Is there some way of recycling a Crystal Reports dataset?
Datatable vs Dataset