SSRS 2005 Dynamic Table Generation
Hello, I am attempting to build a report that allows the user to select the value of 4 different parameters. The final parameter allows the user to select multiple values. My question is as follows. Based on the users selections, is there a way to generate the required number of tables dynamically? For instance, if the input for the final parameter is A, B, & C can the appriopriate number of tables be generated for the same dataset (Sales) without having to build a table for SalesA, SalesB, and SalesC? Or do I have to build the maximum number of tables and use an expression to determine visibility based on the parameters. Note: max number of possible tables is more than 100. Thanks, Frank
November 19th, 2010 1:54pm

Hi Frank, What are trying to achieve with dynamic table generation?Sergei
Free Windows Admin Tool Kit Click here and download it now
November 21st, 2010 7:23am

Hi Frank, Based on your information, I get that you want to display the tables dynamically based on the parameters’ value you selected. As we could not get the number of tables which need to show, so we could not design the table in advanced, then set their visibility, of course this method is not grace as well. To achieve this requirement, I would recommend you follow these steps: 1. Create a multi-value parameter Sales, just as you mentioned in your statement. 2. Filter the dataset utilizing this parameter, as this is a multi-value parameter, please select the IN operator when you create the Filter for your dataset. 3. Design one table to display Sales and other information based on your requirement. 4. Drag a list control on your report body, set it grouped by Sale Datafiled. 5. Lay the table into the list. Preview the report, select the multi-value parameter, if you select two value, it will show tables, if you select five value, it will show five tables. Thanks, Challen Fu
November 24th, 2010 1:02am

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

Other recent topics Other recent topics