Adding data from 2 seperate tables / data sets

Hi There
is it possible to add a total field from table a dataset a to table b
dataset b & finally, is it possible to do a calculation on those results.
(like a percentage of 2 fields)
i have an offered & answered column in one table & a messages played column
in another table with different data set.
i need to add the messages played to the answered column then give the
difference between offered & answered in the form of a percentage.
thanks in advance for assistance.best to do the join and math in the query
"Tango" wrote:
> Hi There
> is it possible to add a total field from table a dataset a to table b
> dataset b & finally, is it possible to do a calculation on those results.
> (like a percentage of 2 fields)
> i have an offered & answered column in one table & a messages played column
> in another table with different data set.
> i need to add the messages played to the answered column then give the
> difference between offered & answered in the form of a percentage.
> thanks in advance for assistance.
>|||Hi, I've the same problem as Tango
But, I can't join and math the query because one has a specific condition
and the other one has an other specific condition.
There's no solution to join 2 data sets?
Thanks in advance
"Antoon" wrote:
> best to do the join and math in the query
> "Tango" wrote:
> > Hi There
> >
> > is it possible to add a total field from table a dataset a to table b
> > dataset b & finally, is it possible to do a calculation on those results.
> > (like a percentage of 2 fields)
> >
> > i have an offered & answered column in one table & a messages played column
> > in another table with different data set.
> >
> > i need to add the messages played to the answered column then give the
> > difference between offered & answered in the form of a percentage.
> >
> > thanks in advance for assistance.
> >|||Not realy, you can put somthing like Fields!x.Value = Sum(Fields!y.Value,
"scope") where x and y are different datasets. But thats probably not enough.
However IMHO, I don't think you could join anything in a report that you
couldn't join in a query.
Select * from
(query1) a,
(query2) b
where a.key = b.key
should do the trick, I would think
"Nicolas BRESSAN" wrote:
> Hi, I've the same problem as Tango
> But, I can't join and math the query because one has a specific condition
> and the other one has an other specific condition.
> There's no solution to join 2 data sets?
> Thanks in advance
> "Antoon" wrote:
> > best to do the join and math in the query
> >
> > "Tango" wrote:
> >
> > > Hi There
> > >
> > > is it possible to add a total field from table a dataset a to table b
> > > dataset b & finally, is it possible to do a calculation on those results.
> > > (like a percentage of 2 fields)
> > >
> > > i have an offered & answered column in one table & a messages played column
> > > in another table with different data set.
> > >
> > > i need to add the messages played to the answered column then give the
> > > difference between offered & answered in the form of a percentage.
> > >
> > > thanks in advance for assistance.
> > >|||thanks,
the problem it's the same database but with different conditions.
I'll try your solution
"Antoon" wrote:
> Not realy, you can put somthing like Fields!x.Value = Sum(Fields!y.Value,
> "scope") where x and y are different datasets. But thats probably not enough.
> However IMHO, I don't think you could join anything in a report that you
> couldn't join in a query.
> Select * from
> (query1) a,
> (query2) b
> where a.key = b.key
> should do the trick, I would think
> "Nicolas BRESSAN" wrote:
> > Hi, I've the same problem as Tango
> >
> > But, I can't join and math the query because one has a specific condition
> > and the other one has an other specific condition.
> >
> > There's no solution to join 2 data sets?
> >
> > Thanks in advance
> >
> > "Antoon" wrote:
> >
> > > best to do the join and math in the query
> > >
> > > "Tango" wrote:
> > >
> > > > Hi There
> > > >
> > > > is it possible to add a total field from table a dataset a to table b
> > > > dataset b & finally, is it possible to do a calculation on those results.
> > > > (like a percentage of 2 fields)
> > > >
> > > > i have an offered & answered column in one table & a messages played column
> > > > in another table with different data set.
> > > >
> > > > i need to add the messages played to the answered column then give the
> > > > difference between offered & answered in the form of a percentage.
> > > >
> > > > thanks in advance for assistance.
> > > >|||You could also try subreports.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Nicolas BRESSAN" <NicolasBRESSAN@.discussions.microsoft.com> wrote in
message news:721271CD-50E6-4C20-A385-6DB090F8584D@.microsoft.com...
> Hi, I've the same problem as Tango
> But, I can't join and math the query because one has a specific condition
> and the other one has an other specific condition.
> There's no solution to join 2 data sets?
> Thanks in advance
> "Antoon" wrote:
>> best to do the join and math in the query
>> "Tango" wrote:
>> > Hi There
>> >
>> > is it possible to add a total field from table a dataset a to table b
>> > dataset b & finally, is it possible to do a calculation on those
>> > results.
>> > (like a percentage of 2 fields)
>> >
>> > i have an offered & answered column in one table & a messages played
>> > column
>> > in another table with different data set.
>> >
>> > i need to add the messages played to the answered column then give the
>> > difference between offered & answered in the form of a percentage.
>> >
>> > thanks in advance for assistance.
>> >|||How we can make a subreport?
"Bruce L-C [MVP]" wrote:
> You could also try subreports.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Nicolas BRESSAN" <NicolasBRESSAN@.discussions.microsoft.com> wrote in
> message news:721271CD-50E6-4C20-A385-6DB090F8584D@.microsoft.com...
> > Hi, I've the same problem as Tango
> >
> > But, I can't join and math the query because one has a specific condition
> > and the other one has an other specific condition.
> >
> > There's no solution to join 2 data sets?
> >
> > Thanks in advance
> >
> > "Antoon" wrote:
> >
> >> best to do the join and math in the query
> >>
> >> "Tango" wrote:
> >>
> >> > Hi There
> >> >
> >> > is it possible to add a total field from table a dataset a to table b
> >> > dataset b & finally, is it possible to do a calculation on those
> >> > results.
> >> > (like a percentage of 2 fields)
> >> >
> >> > i have an offered & answered column in one table & a messages played
> >> > column
> >> > in another table with different data set.
> >> >
> >> > i need to add the messages played to the answered column then give the
> >> > difference between offered & answered in the form of a percentage.
> >> >
> >> > thanks in advance for assistance.
> >> >
>
>|||Subreports work great for a 1 to 1 or a 1 to many relationship of the data.
A sub report is just a regular report with parameters (first get the report
working standalone). Then you drag and drop the report onto your other
report, do a right mouse click and set the parameter mapping. Read up on
subreports in books online.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Nicolas BRESSAN" <NicolasBRESSAN@.discussions.microsoft.com> wrote in
message news:A9582474-CB42-40D5-A605-3455CAE81518@.microsoft.com...
> How we can make a subreport?
> "Bruce L-C [MVP]" wrote:
>> You could also try subreports.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Nicolas BRESSAN" <NicolasBRESSAN@.discussions.microsoft.com> wrote in
>> message news:721271CD-50E6-4C20-A385-6DB090F8584D@.microsoft.com...
>> > Hi, I've the same problem as Tango
>> >
>> > But, I can't join and math the query because one has a specific
>> > condition
>> > and the other one has an other specific condition.
>> >
>> > There's no solution to join 2 data sets?
>> >
>> > Thanks in advance
>> >
>> > "Antoon" wrote:
>> >
>> >> best to do the join and math in the query
>> >>
>> >> "Tango" wrote:
>> >>
>> >> > Hi There
>> >> >
>> >> > is it possible to add a total field from table a dataset a to table
>> >> > b
>> >> > dataset b & finally, is it possible to do a calculation on those
>> >> > results.
>> >> > (like a percentage of 2 fields)
>> >> >
>> >> > i have an offered & answered column in one table & a messages played
>> >> > column
>> >> > in another table with different data set.
>> >> >
>> >> > i need to add the messages played to the answered column then give
>> >> > the
>> >> > difference between offered & answered in the form of a percentage.
>> >> >
>> >> > thanks in advance for assistance.
>> >> >
>>