Multi-table DataSets in VS2005 SRS Report designer

Hi all,

I need to use a multi-table dataset as a datasource for my report items in a SRS2005 report.

But from designer, I can only see the first table.

Can any one tell me if it is possible to use multiple tables in a dataset for SRS report?

Thanks,

Samson

If the report is deployed to the server, you will need a custom data extension to support multi-table datasets, as demonstrated here. Alternatively, you can use the ReportViewer controls for local report rendering. Then you can bind the report to any table in the dataset, as explained here.

sql

multiples charts and tables on the same report from multiple datasets

Hi,
I am trying to use Reporting services toi create a report with a number of
charts and tables from the same datasource but multiple datasets. When I
created a table and dragged the data fields into the column it is
=First(Fields!OrderID.Value, "DataSet1")
It keeps repeating until the end of rows where in the dataset I used top5
SQL what should be the correct way to do it?
Also I am wondering if I can modify the color of and space between bar chart
items.
Thank you in advance,
SunnyRemove "First" from your code, so you end up with =Fields!OrderID.Value.
Also, in the charts, you might have to change your values. At least for me
the values shows up as =Count(Fields!OrderID.Value), and I usually don't
want to have "Count" at all.
You can change the background color of a chart, just right click and choose
properties. (DOn't remeber where, but you'll find it if you look for it.)
DOn't think you can change the spacing, except with just changing the size
of the chart.
Kaisa M. LIndahl
"Sansanee" <sansanee@.nospam.com> wrote in message
news:ufPXgHlNFHA.3704@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I am trying to use Reporting services toi create a report with a number of
> charts and tables from the same datasource but multiple datasets. When I
> created a table and dragged the data fields into the column it is
> =First(Fields!OrderID.Value, "DataSet1")
> It keeps repeating until the end of rows where in the dataset I used top5
> SQL what should be the correct way to do it?
> Also I am wondering if I can modify the color of and space between bar
chart
> items.
>
> Thank you in advance,
> Sunny
>

Multiple Tables with DrillDown in one report

Hi NG,
i try to put 3 tables on a report who filled up by three different named
datasets (but with same structure).
All datasets are filled from the a AS-cube with the same MDX-Statement. The
difference between the datasets are the different parameters.
And here is my problem:
I start to develop the report with the designer...integrate the first
MDX-Statement and create a drillDown-Table. Everything works fine. After
that i put another table on the reportpage, bind the second dataset on it,
insert grouping to the table and so on. But the drillDown wont
work....there is no show-and-hide toggle (the +-sign)
Also...i could not copy the first table and put it on the same report...if
i do it, i get compile-errors.
Anybody here with an example which includes tow tables with drilldown who
based on the same dataset?
regards
FrankFrank Matthiesen wrote:
forget the question...i was to blind. I fixed it.
frank

Multiple tables in a report?

I have 2 datasets defined and 2 tables in my report. I
want to have the results of one dataset in one table, and
the results of the other dataset in the other table. Is
there a way to specify which dataset I want the table to
use? The report designer only lets me use an aggregate (= First(Fields!name.Value, "dataset2")) in the 2nd table.
This syntax allows me to specify the dataset, but I don't
want just the first record, I want all the records. This
doesn't seem like it should be complicated. Anyone?Right click on table, go to properties, and you should see a datasetname
property. Enter the respective dataset name
"Jerrad" wrote:
> I have 2 datasets defined and 2 tables in my report. I
> want to have the results of one dataset in one table, and
> the results of the other dataset in the other table. Is
> there a way to specify which dataset I want the table to
> use? The report designer only lets me use an aggregate (=> First(Fields!name.Value, "dataset2")) in the 2nd table.
> This syntax allows me to specify the dataset, but I don't
> want just the first record, I want all the records. This
> doesn't seem like it should be complicated. Anyone?
>

multiple resultsets

I am just having many problems trying to call a procedure with multiple
parameters in multiple datasets. The proc works fine in query analyzer with
each parameter specified. I've got all the fields in each of the datasets,
and I've drug them all into the report layout. right now, my rpt is failing
with this:
The value expression for the textbox 'fieldname' refers to the fields
'fieldname'.
Report item expressions can only refer to fields within the current data set
scope or,
if inside and aggregate, the specified data set scope.
Can anybody tell me how to get around this? each of the datasets, when run
individually, work fine. (using the ! exclamation to run) but i receive
this error for one of the datasets when trying to preview the entire report.
-- Lynn
LynnI fixed that error. Somehow the fields of dataset1 got into the fields of
dataset5. but, now i get this:
An error has occurred during report processing.
Annot read the next data row for the data set DataSet3.
There is insufficient result space to convert a money value to varchar.
Again, each procedure call works fine in QA.
-- Lynn
"Lynn" wrote:
> I am just having many problems trying to call a procedure with multiple
> parameters in multiple datasets. The proc works fine in query analyzer with
> each parameter specified. I've got all the fields in each of the datasets,
> and I've drug them all into the report layout. right now, my rpt is failing
> with this:
> The value expression for the textbox 'fieldname' refers to the fields
> 'fieldname'.
> Report item expressions can only refer to fields within the current data set
> scope or,
> if inside and aggregate, the specified data set scope.
> Can anybody tell me how to get around this? each of the datasets, when run
> individually, work fine. (using the ! exclamation to run) but i receive
> this error for one of the datasets when trying to preview the entire report.
> -- Lynn
> Lynn|||I fixed that error, too. Now the report returns. But no values are returned
for Dataset1, dataset3 and dataset5. And, dataset2 and dataset4 only contain
duplicates.
for example, dataset2 is supposed to be like this:
Symbol #Trades Volume Total $
..
...
...
but i get only this:
CRNX 213
It returns only Symbol and #trades, and it displays only one, replicated
over and over. Same for dataset4. It should be:
EndPoint #Trades Volume Total $
...
....
.....
but i get only 5 of these:
6BM6 2
Any direction?
-- Lynn
"Lynn" wrote:
> I fixed that error. Somehow the fields of dataset1 got into the fields of
> dataset5. but, now i get this:
> An error has occurred during report processing.
> Annot read the next data row for the data set DataSet3.
> There is insufficient result space to convert a money value to varchar.
> Again, each procedure call works fine in QA.
> -- Lynn
>
> "Lynn" wrote:
> > I am just having many problems trying to call a procedure with multiple
> > parameters in multiple datasets. The proc works fine in query analyzer with
> > each parameter specified. I've got all the fields in each of the datasets,
> > and I've drug them all into the report layout. right now, my rpt is failing
> > with this:
> >
> > The value expression for the textbox 'fieldname' refers to the fields
> > 'fieldname'.
> > Report item expressions can only refer to fields within the current data set
> > scope or,
> > if inside and aggregate, the specified data set scope.
> >
> > Can anybody tell me how to get around this? each of the datasets, when run
> > individually, work fine. (using the ! exclamation to run) but i receive
> > this error for one of the datasets when trying to preview the entire report.
> >
> > -- Lynn
> > Lynn