Multiple groupings in table details row

Is there a way to have multiple groupings for a single dataset in a table's
detail row? I need to be able to hide individual grouped data, but still
need to see the hidden data aggregated in the footer row of the table.
The purpose is to make the report easy to read for troubleshooting by hiding
issues that aren't that important but still need to be calculated. Any help
would be greatly appreciated.No
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"joelnbtx" <joelnbtx@.discussions.microsoft.com> wrote in message
news:9783877A-C8AA-4E51-A49F-4EB1D6CC2463@.microsoft.com...
> Is there a way to have multiple groupings for a single dataset in a
> table's
> detail row? I need to be able to hide individual grouped data, but still
> need to see the hidden data aggregated in the footer row of the table.
> The purpose is to make the report easy to read for troubleshooting by
> hiding
> issues that aren't that important but still need to be calculated. Any
> help
> would be greatly appreciated.sql

multiple exports files from one report?

Hi
I have a simple report I would like to run for 60 users. Is there a way to
have one report cycle though a dataset and create 60 exported .mhtml files? I
really don't want to create 60 reports and 60 subscriptions :(
All the exported files would reside in the same folder.
Any help would be much appreciated!
Thanks,
MarcusHi,
You should take a look at the Data Driven subscription. This will enable to
generate multiple reports, with different parameters, just the way you want.
For more info:
http://msdn.microsoft.com/library/en-us/rswork/htm/rms_subscribing_v1_7oj9.asp
--
| Jan Pieter Posthuma
--
"Marcus K" wrote:
> Hi
> I have a simple report I would like to run for 60 users. Is there a way to
> have one report cycle though a dataset and create 60 exported .mhtml files? I
> really don't want to create 60 reports and 60 subscriptions :(
> All the exported files would reside in the same folder.
> Any help would be much appreciated!
> Thanks,
> Marcus|||Thanks, I'm not sure what I've done, but I can't get the data-driven
subscrition option to show up. I've already stored the credentials in the
report. It must be something with the security on the site, but I've got
everyone as Site Administration during our testing... weird
"Jan Pieter Posthuma" wrote:
> Hi,
> You should take a look at the Data Driven subscription. This will enable to
> generate multiple reports, with different parameters, just the way you want.
> For more info:
> http://msdn.microsoft.com/library/en-us/rswork/htm/rms_subscribing_v1_7oj9.asp
> --
> | Jan Pieter Posthuma
> --
>
> "Marcus K" wrote:
> > Hi
> >
> > I have a simple report I would like to run for 60 users. Is there a way to
> > have one report cycle though a dataset and create 60 exported .mhtml files? I
> > really don't want to create 60 reports and 60 subscriptions :(
> >
> > All the exported files would reside in the same folder.
> >
> > Any help would be much appreciated!
> >
> > Thanks,
> > Marcus

multiple datatables passed to one report?

Is it possible to pass multiple datatables to one report (within one dataset)?

My stored procedure would have two or more select statements.

Only one resultset is supported.

You could add a parameter to the stored procedure (or write a wrapper). The parameter determines which resultset is returned. You would then define multiple datasets in the RS report and call the stored procedure with different parameter values.

-- Robert

|||

Thanks, I guess I need to research multiple datasets in the report. I imagine there is a custom assembly involved?

|||

Using multiple datasets in a report has nothing to do with custom assemblies.

Multiple datasets just means you need to have multiple data regions (list, table, matrix, chart) in the report to show the data.

-- Robert

multiple datasets

Is it possible to have more than one dataset in a report?

I'm trying to create a parameter that draws its drop down box values from a query that is seperate from the result set.

Thanks

Yes, you can have multiple DataSets in reports. You can set up a DatsSet to be the source for valid parameter values like you describe.

-Chris

Multiple dataset in a single report

Let's say we have two (logical) sections within a report, one that displays a record from table_A and on the other one displays a Barchart based on the values fetched from table_B.
Could we assign seperate queries (resultset) to above mentioned situation ?
p.s. Right now, we are doing it through JOIN between tables A and B. However, we would like to not use that.If you have different, tables, matrixes, etc within a report you may assign
a different result set to each one...Just define the multiple queries, and
make the assignment in the properties of the table/matrix
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Kam" <Kam@.discussions.microsoft.com> wrote in message
news:642C9A77-A4C2-44EE-B639-AC8C31E9776A@.microsoft.com...
> Let's say we have two (logical) sections within a report, one that
displays a record from table_A and on the other one displays a Barchart
based on the values fetched from table_B.
> Could we assign seperate queries (resultset) to above mentioned situation
?
> p.s. Right now, we are doing it through JOIN between tables A and B.
However, we would like to not use that.

multiple dataset fields in one table

How to use multiple dataset fields in one table.

Example:

I have one table --Table1.

Two DataSets --DataSet1,DataSet2

Table1 refers DataSet1.I want to use DataSet2 field in Table1.It is taking SUM if did this but I don't need sum.

A table can only be associated with 1 dataset.|||

thanx Adam.

Can you give me the solution

|||

It depends on the data and what else you are doing in the report. What I've done in the past is either

combine the data into 1 dataset in the query or|||

if you only want to use a SUM-Value from your second dataset,

this shouldnt be a problem

go to the field in your table where you want the SUM-Value

-> Expression -> Datasets -> <Dataset2> -> Sum(<yourValueToSum>)

this inserts a Sum-Function for your value over the scope of dataset 2

greets

|||

you could do something like this

=Sum(Fields!fieldnam.Value, "Dataset Name")

and it would get the value from the specified dataset

Multiple dataset calculation

I have 3 tables pulling data from 3 different datasets. In my 3rd table i need to sum the table1-column2 to table2-column3.

e.g.

=Fields!Column2.Value,"Dataset1"+(Fields!Column3.Value, "Dataset2")

This does not work.

Please help.

You cannot do cross-dataset operations except at an aggregate level, i.e.

=Fields!Column2.Value+Sum(Fields!Column3.Value, "Dataset2")

Multiple Data sources for a dataset

Hey everyone,

I am trying to combine like data from two different data sources into a single data set. Is there anyway I can do this? It seems like I can only add one data set, but is there some sort of workaround I could use?

thanks,

Keith

Not within the report I'm afraid.

However when building your own application, if you use the report viewer control then you can use .Net datasets to populate data sources. You could therefore populate the dataset manually in C-sharp or VB from the various data sources and pass that to the report viewer control.

The other option is to write your data delivery extension using the reporting services extensible object model.

|||What are the datasources? If they are two different database systems (SQL Server, Oracle, etc), you can consider using linked servers to combine the data before SSRS ever receives it. Just be aware of the performance implications of doing so.

HTH...

Joe

Multiple Data Sources for 1 Dataset?

I have to create a join between tables on SQL Server & a table/file on an
AS400(DB2).
I can create the 2 different data sources just fine, but I cannot figure out
how to join the data into 1 dataset, since you can only use 1 data source.
Has anyone been able to do this? Help!Hod did you go with this question Lori?
I have the same problem.
Thanks
Todd
"Lori" wrote:
> I have to create a join between tables on SQL Server & a table/file on an
> AS400(DB2).
> I can create the 2 different data sources just fine, but I cannot figure out
> how to join the data into 1 dataset, since you can only use 1 data source.
> Has anyone been able to do this? Help!|||I ended up having to create a linked server (on SQL Server) to connect to the
AS/400. I then used a SP to do the query statement. Let me know if you can
find any better way. The linked server does work, it's just not pretty. :-)
"Tango" wrote:
> Hod did you go with this question Lori?
> I have the same problem.
> Thanks
> Todd
> "Lori" wrote:
> > I have to create a join between tables on SQL Server & a table/file on an
> > AS400(DB2).
> > I can create the 2 different data sources just fine, but I cannot figure out
> > how to join the data into 1 dataset, since you can only use 1 data source.
> > Has anyone been able to do this? Help!|||A painfully learned suggestion. Even though with 4 part naming you can do a
heterogenous join, don't. It will pull on the data from the tables locally
to do the join. Use openquery, bring the appropriate data into a temp table
and then join with the temp table. If you have a query with a join (regular
join, not heterogenous) or you have a parameter then even with all the
tables in the query going against the same database it is likely to bring
over all the data locally to process the result. Hence my strong suggestion
to stay away from 4 part naming and use openquery (even though a pain)
instead.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Lori" <Lori@.discussions.microsoft.com> wrote in message
news:39D2A369-C0EC-44E1-B5AB-48A78DA74DB9@.microsoft.com...
>I ended up having to create a linked server (on SQL Server) to connect to
>the
> AS/400. I then used a SP to do the query statement. Let me know if you
> can
> find any better way. The linked server does work, it's just not pretty.
> :-)
> "Tango" wrote:
>> Hod did you go with this question Lori?
>> I have the same problem.
>> Thanks
>> Todd
>> "Lori" wrote:
>> > I have to create a join between tables on SQL Server & a table/file on
>> > an
>> > AS400(DB2).
>> > I can create the 2 different data sources just fine, but I cannot
>> > figure out
>> > how to join the data into 1 dataset, since you can only use 1 data
>> > source.
>> > Has anyone been able to do this? Help!