|
Home > Archive > MS SQL Server Reporting Services > May 2005 > Two data Sets to 2 Tables in a report?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Two data Sets to 2 Tables in a report?
|
|
| Antony Altobelli via SQLMonster.com 2005-05-27, 9:23 am |
| Hi all,
My daily question is:
I have a report with two data sets, First dataset gets the top five
performers and the other dataset gets the bottom two performers.
I want to diplay each data set result on table of its own on the same
report. meaning I want to drag two tables on the report designer and drag-
and-drop fields from data set one onto table1 and similarly from dataset 2
onto table 2. Is this possible?
Cheers!!
Tony
--
Message posted via http://www.webservertalk.com
| |
| scraejtp 2005-05-27, 11:23 am |
| Yes. Just go to the data tab and create a second dataset by clicking on the
drop down and clicking "new dataset" and then setup the connection and query.
Then on the table right click it, and change the dataset name to whichever
has the fields you want to display.
"Antony Altobelli via webservertalk.com" wrote:
> Hi all,
>
> My daily question is:
>
> I have a report with two data sets, First dataset gets the top five
> performers and the other dataset gets the bottom two performers.
>
> I want to diplay each data set result on table of its own on the same
> report. meaning I want to drag two tables on the report designer and drag-
> and-drop fields from data set one onto table1 and similarly from dataset 2
> onto table 2. Is this possible?
>
> Cheers!!
>
> Tony
>
> --
> Message posted via http://www.webservertalk.com
>
|
|
|
|
|