all groups > sql server reporting services > august 2006 >
You're in the

sql server reporting services

group:

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


how to link different dataset in one report or... wiraperkasa
8/21/2006 12:32:46 AM
sql server reporting services: 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>>>
RE: how to link different dataset in one report or... magendo_man
8/21/2006 2:31:02 AM
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

[quoted text, click to view]
Re: how to link different dataset in one report or... wiraperkasa
8/21/2006 8:20:29 PM
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
Re: how to link different dataset in one report or... magendo_man
8/22/2006 1:32:02 AM
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

[quoted text, click to view]
Re: how to link different dataset in one report or... xuyuntaosky
10/28/2006 11:37:01 AM
maybe we can try to use sub-report...


[quoted text, click to view]
Got something to say? Click here to post a reply to this thread.
Don't see what you're looking for? Try a search.
View other messages in the sql server reporting services group.
AddThis Social Bookmark Button
View Other Months
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
home · blog · groups Questions? Comments? Contact the dn