Hi,

My report uses a stored procedure as datasource.
But in my .Net app I want to set the data of my report myself with the method:

<code>
rptDoc.SetDataSource(myDataSet)
</code>

I don't want to the report to get the data again with the stored procedure.
I export my report and using a DB profiler I found out that the report executes the stored procedure during export again.
I want the report to use the datasource I set and not more.

What do I have to do to achive that?
I thought I just don't set the Logon info and parameter values so the report can't connect to a DB. But then export doesn't work. any ideas?

thanks and bye
juergen

Hi,

thanks for the reply.
I am not sure how to set the database location to DataSet actually.

the property

<code>
rptDoc.Database.Tables[0].Location
</code>

is a string. what do I have to set there? And what about the ConnectionInfo and Parameters. Can I just leave them?

bye juergen

Ah OK,

I thought I could change the location to DataSet im my .Net application :-(
I need the report with a stored procedure location as well.

I guess I have to make 2 versions of the same report?

juergen