Adding a dataset problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Krzysztof - 17 Jul 2008 15:33 GMT

Good Morning,

I have a very frustrating problem. I have a report that needs two datasets
from two different data sources. i have reaports that already have multiple
datasources, and eveything is okay. THis report however, when i add the
dataset and source, once i save the report, it chages the datasource. let me
explain:

dset A uses dsource 1

i added

dset B that uses dsource 2

everything sets up ok, then, i go into the properties of dset A, and it has
dsource 2 as the dsource

if i change that back to 1, then it changes dset B's dsource to 1 also

This is really driving me nuts!

TIA ~K

Reply to this Message

Krzysztof - 17 Jul 2008 15:39 GMT

Nevermind, I figured it out.

For those who might need to know:

When adding the second dataset, when you choose the datasource, the source
you used for the first dataset will prefill the space. All i did was change
it. This was changing the source for both sets. Instead, choose New Data
Source from the drop down menu, and all will be good.

>Good Morning,
>
[quoted text clipped - 18 lines]
>
>TIA ~K

Reply to this Message

Bruce L-C [MVP] - 17 Jul 2008 15:43 GMT

Are you using report specific data sources or shared datasources. I always
use shared datasources. I have several reports that have multiple datasets
with the datasets using different data sources. I have never see this
problem. What version of RS are you using?

If you are using report specific data sources can you try shared
datasources?

I suggest starting over with a clean report.

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

> Good Morning,
>
[quoted text clipped - 22 lines]
>
> TIA ~K

Reply to this Message