cached datasets?

[woyler]

Hello all,

I have a report with a table and a chart. It uses dataset1 as the data source.

All works fine.

I create a new dataset called dataset2.

The queries are exactly the same. The only differences between the 2 datasets is the database server and the fact that one of the columns is a smallint (in dataset2) and an int(in Dataset1)

I change the datasetName property of both the table and the chart to use dataset2.

When I run the report I get a conversion error stating that there was an overflow of int2 while using dataset1. I have verified the report is not using dataset1 anywhere. If I delete dataset1 and run the report the error goes away. If I add it back, I get the error again. Why is the report looking at dataset1 if it is not referenced at all in the report? Does SQL RS cache the datasets and verify each when it compiles?



regards,

Bill

 

[xlbo]

If the dataset is associated with the report it will run when the report is called whether or not any of the data is used in the report

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[woyler]

So, if I have a report with one table, and want to have this report deployed for use with 3 different servers;
I will create 3 datasets , one for each server.
I change the datasource for the table to the dataset I want to use for each particular server. Are you saying, the mere existence of the other datasets forces the report to validate each one regardless if it is used in the report?

 

[woyler]

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1979741&SiteID=1&mode=1

 

[xlbo]

That link bombs out btw....

How do you propose to change the dataset used for the table at runtime ?

I would've thought it would be easier to use 1 dataset and utilise a dynamic connection string that accepted a parameter to tell it which server to use....

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[woyler]

The link seems to work from here. It was just the same conversation in a msdn forum. I dynamic connection string was what I wanted to do initially, but I could not find enough info to accomplish it. On the SQL RS server I have 3 links (one for each location) The location the user selects will determine the connection string. How can I determine which location (folder) the user is in, then pass a dynamic connection?

 

[xlbo]

Within the link, pass a parameter to the report. Use that parameter to define the connection string in an IIF statement or in code

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question