开发者

sql server 2005 reporting services-- how to use multiple datasets in report

I'm new to SQL Server reporting services, and am trying to decipher an existing report. It's nothing too bad, but I notice it does have two report datasets defined. (They are generated via separate stored procedures)

I'm trying to figure out where and how the report datasets are linked together so the Fie开发者_如何学JAVAlds collection has both sets of columns available and the report has a single rowset to traverse. Is there a section in the report layout where a joining of datasets is defined? I'm using Visual Studio 2005 to design and preview the report fwiw.

Thanks for your help!


in many conditions we need to use from multiple datasets. usually these datasets get a same report parameter and return the results. for example suppose that you have a report that get you the list of passed lessons by a student. in this report you want to know min and max of this student number. for this report you get a student id as a input parameter and pass this parameter to first dataset and get the list of passed lessons. the second dataset get this parameter too for generating the max and min of student numbers.

both of these datasets get this parameter. may this parameter be the common point of the datasets.


Since I cant see the report. I can at least suggest this. Many use the second dataset for selection values on parameters. Perhaps your report has a parameter that is using the second dataset to display a list of choices for that parameter.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜