how to link different dataset in one report or...

i have a report that needed to create many dataset(coz its complicated
to combine all of the using union).the problem is how can i combine it
all at the layout and make a link to all of them...i have try using
many table but in the end, the result is not what i expected...so how
do i link it?if using table how can i link the table with each
other...<<<<tq>>You can't really combine datasets. You are going to have to either generate a
query in the report designer or write a stored procedure which extracts data
from your different tables/data sources.
The only other thing you can do is design a subreport of your main report.
This can use a different dataset, but there must be some link between the two
which you specify.
HTH,
Magendo_man
"wiraperkasa" wrote:
> i have a report that needed to create many dataset(coz its complicated
> to combine all of the using union).the problem is how can i combine it
> all at the layout and make a link to all of them...i have try using
> many table but in the end, the result is not what i expected...so how
> do i link it?if using table how can i link the table with each
> other...<<<<tq>>
>|||tq magendo_man..ok i know how to generate a query in the report
designer...but write a stored procedure...i'm not quite sure about
it..can you explain to me...
and also..how to use the subreport(is it at the layout?) and hoe to
link between the two dataset..if u have any website that u want to
recommend...:)...tq|||You need to have access to the SQL server database to write a stored
procedure. It can take the form of a query, very similar to those you
generate in Visual Studio for Reporting Services. If you are using SQL 2000
you will probably need to use SQL Server Enterprise Manager and/or SQL Query
Analyzer.
You create a sub-report as you would any normal report in Visual Studio,
i.e. as a seperate report. You then need to go to your main report design and
drag a sub-report control on to the report body and configure the link to
your previously created sub-report. You should get info about this in the
help for Reporting Services in Visual Studio.
HTH,
Magend_man
"wiraperkasa" wrote:
> tq magendo_man..ok i know how to generate a query in the report
> designer...but write a stored procedure...i'm not quite sure about
> it..can you explain to me...
> and also..how to use the subreport(is it at the layout?) and hoe to
> link between the two dataset..if u have any website that u want to
> recommend...:)...tq
>|||maybe we can try to use sub-report...
"magendo_man" wrote:
> You need to have access to the SQL server database to write a stored
> procedure. It can take the form of a query, very similar to those you
> generate in Visual Studio for Reporting Services. If you are using SQL 2000
> you will probably need to use SQL Server Enterprise Manager and/or SQL Query
> Analyzer.
> You create a sub-report as you would any normal report in Visual Studio,
> i.e. as a seperate report. You then need to go to your main report design and
> drag a sub-report control on to the report body and configure the link to
> your previously created sub-report. You should get info about this in the
> help for Reporting Services in Visual Studio.
> HTH,
> Magend_man
> "wiraperkasa" wrote:
> > tq magendo_man..ok i know how to generate a query in the report
> > designer...but write a stored procedure...i'm not quite sure about
> > it..can you explain to me...
> > and also..how to use the subreport(is it at the layout?) and hoe to
> > link between the two dataset..if u have any website that u want to
> > recommend...:)...tq
> >
> >