RS 2008, Datasets Based Upon Filters
I have a Filter/Parameter on a report where the user can select multiple values. I would like the report to create a new dataset for each value selected, is this possible if so how? ThanksPete
November 18th, 2010 10:37am

Use lists to create an "report object" like table, graph, etc for each value of the report parameter used. Attaching what Rajesh wrote before:- I hope this might help Check this link : http://technet.microsoft.com/en-us/library/ms159121.aspx To Add a LIST -------------- In Layout view, in the Toolbox, click List. On the design surface, drag a box to the size you want the list to be. Alternatively, click the design surface to create a list of fixed size. Drag a field from the Datasets window onto a table cell, matrix cell, or containing object or page. Note: If the Datasets window does not appear, in the View menu, click Datasets. -------------- To move a list -------------- In Layout view, click any empty space within the list to select the list. Point to the shaded border of the list, and then drag the list to a new location. ---------------- To delete a list ---------------- In Layout view, right-click any empty space within the list, and then click Delete. Alternatively, click any empty space within the list, and then press DELETE. Note: Deleting a list deletes all objects from the report that are contained within the list. -------------------------- To add a group to a list -------------------------- In Layout view, right-click the list, and then click Properties. On the General tab, click Edit details group. This opens the Details Grouping dialog box. On the General tab, do the following: In Name, type the name of the group. In Group on, type or select the expressions by which to group the data. (Optional) In Document map label, type or select an expression to use as a document map label. (Optional) If this group is a recursive hierarchy, for Parent group, type or select an expression to use as the recursive group parent. (Optional) Click Page break at start or Page break at end to place a page break at the beginning or end of each group instance. (Optional) On the Filters tab, select or type expressions by which to filter the data within the group. (Optional) On the Visibility tab, select the visibility options for the item. For more information about visibility, see Hiding Report Items. (Optional) On the Data Output tab, select the data output options for the item, and then click OK. -------------------------------------------------------------------------------- Rajesh Jonnalagadda http://www.ggktech.com Or you can even use a matrix as shown in the blog link below http://road-blogs.blogspot.com/2010/05/better-way-of-repeating-charts-based-on.htmlCheers, Jason P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)
Free Windows Admin Tool Kit Click here and download it now
November 18th, 2010 11:35am

Use lists to create an "report object" like table, graph, etc for each value of the report parameter used. Attaching what Rajesh wrote before:- I hope this might help Check this link : http://technet.microsoft.com/en-us/library/ms159121.aspx To Add a LIST -------------- In Layout view, in the Toolbox, click List. On the design surface, drag a box to the size you want the list to be. Alternatively, click the design surface to create a list of fixed size. Drag a field from the Datasets window onto a table cell, matrix cell, or containing object or page. Note: If the Datasets window does not appear, in the View menu, click Datasets. -------------- To move a list -------------- In Layout view, click any empty space within the list to select the list. Point to the shaded border of the list, and then drag the list to a new location. ---------------- To delete a list ---------------- In Layout view, right-click any empty space within the list, and then click Delete. Alternatively, click any empty space within the list, and then press DELETE. Note: Deleting a list deletes all objects from the report that are contained within the list. -------------------------- To add a group to a list -------------------------- In Layout view, right-click the list, and then click Properties. On the General tab, click Edit details group. This opens the Details Grouping dialog box. On the General tab, do the following: In Name, type the name of the group. In Group on, type or select the expressions by which to group the data. (Optional) In Document map label, type or select an expression to use as a document map label. (Optional) If this group is a recursive hierarchy, for Parent group, type or select an expression to use as the recursive group parent. (Optional) Click Page break at start or Page break at end to place a page break at the beginning or end of each group instance. (Optional) On the Filters tab, select or type expressions by which to filter the data within the group. (Optional) On the Visibility tab, select the visibility options for the item. For more information about visibility, see Hiding Report Items. (Optional) On the Data Output tab, select the data output options for the item, and then click OK. -------------------------------------------------------------------------------- Rajesh Jonnalagadda http://www.ggktech.com Or you can even use a matrix as shown in the blog link below http://road-blogs.blogspot.com/2010/05/better-way-of-repeating-charts-based-on.htmlCheers, Jason P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)
November 18th, 2010 11:35am

Hi Pete, By generally, if there is a dataset in the report, for example, the dataset query is SELECT ProductKey, ProductName FROM DimProduct In order to filter it by a multi-value parameter which name is Keys, we can modify the dataset query to SELECT ProductKey, ProductName FROM DimProduct WHERE (ProductKey IN (@Keys)) After that, we can use the dataset which is filtered by a multi-value parameter without create a new one. However, if it is not what you want, please elaborate your requirement with an example. Then I will provide you further assistance. For more information about using Multivalue Parameters, please refer to the link below: http://msdn.microsoft.com/en-us/library/aa337292(SQL.100).aspx Thanks, Tony ChainPlease remember to mark the replies as answers if they help and unmark them if they provide no help
Free Windows Admin Tool Kit Click here and download it now
November 22nd, 2010 2:06am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics