Hi, I have a report with a multi-valued parameter . For each value i want to create a new table with page breaks between them. I have created one table that needs to be repeated for x amount of values in the parameter. Is this possible in SSRS 2005? Thanks

Hmm, I am afraid it is not possible. Can you create constant number of tables and set visible =true according to the parameter?Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Hi Colie, Well there is a ways around this issue: 1. You can create table for each value and when the value is checked , the table will be visible (set the hidden property with expression (=iif(Paramters!Param1.Value=Value1,false,true)) 2. You can use the Matrix instead of Table , the Matrix will give you a dynamic rows. Please tell me if this solution doesn't work for you so we can think of anther one. Karim Sameh Wahba "collie12" wrote in message news:b8883e88-de91-4ee5-ab0c-80db2c1c0304... Hi, I have a report with a multi-valued parameter . For each value i want to create a new table with page breaks between them. I have created one table that needs to be repeated for x amount of values in the parameter. Is this possible in SSRS 2005? Thanks Karim Sameh Wahba

Hi Colie, Well there is a ways around this issue: 1. You can create table for each value and when the value is checked , the table will be visible (set the hidden property with expression (=iif(Paramters!Param1.Value=Value1,false,true)) 2. You can use the Matrix instead of Table , the Matrix will give you a dynamic rows. Please tell me if this solution doesn't work for you so we can think of anther one. Karim Sameh Wahba "collie12" wrote in message news:b8883e88-de91-4ee5-ab0c-80db2c1c0304... Hi, I have a report with a multi-valued parameter . For each value i want to create a new table with page breaks between them. I have created one table that needs to be repeated for x amount of values in the parameter. Is this possible in SSRS 2005? Thanks Karim Sameh Wahba

Hi, You can generate RDL programmatically using an XmlDocument for SSRS 2008 - see here http://msdn.microsoft.com/en-us/library/ms170239.aspx. Most likely, it could be done for SSRS 2005 as well.Sergei

Hi colline, Yes, it is possible in SSRS 2005. You can archieve it via following these steps: 1. Create a new dataset, like this: select prdt from tbl where prdt in (@multiparameter) 2. On the report body, drag a List, and insert a Table into this List. The list grouping on expression is =Fields!prdt.value. In the newly added Table, place the =Fields!prdt.value. 3. In the List properties settings, select pagebreak as you want. After the above steps, the list will create table for each parameter value, which is what you are looking for. thanks, Jerry

Jerry, Is it possible to use this same functionality to create a list over multiple tables. For example, I have 13 tables all built off of varying datasets. What I would like to do is create a user defined parameter that returns the values for the list. Thus creating all 13 tables for each of the values in the list. Thanks, Frank

Jerry, Is it possible to use this same functionality to create a list over multiple tables. For example, I have 13 tables all built off of varying datasets. What I would like to do is create a user defined parameter that returns the values for the list. Thus creating all 13 tables for each of the values in the list. Thanks, Frank

hi Jerry, i am new to programming. I want to do something similar to this but in visualstudio 2008, C#. Here is what i need to do.:- * i have to create a page consisting of address info of an employee, which consists of set of tables like Present address, permanent address, office address etc.(The number of such categories are to be fetched from database) * I have a table in database named AddressCategories which consists of values like Present, Permanent, office etc. When i add a new row in AddressCategories table in database, dynamically a new Table is to be created in my frontend. How shall i do this ? ? please help me

hi Karim, i am new to programming. I want to do something similar to this but in visualstudio 2008, C#. Here is what i need to do.:- * i have to create a page consisting of address info of an employee, which consists of set of tables like Present address, permanent address, office address etc.(The number of such categories are to be fetched from database) * I have a table in database named AddressCategories which consists of values like Present, Permanent, office etc. When i add a new row in AddressCategories table in database, dynamically a new Table is to be created in my frontend. How shall i do this ? ? please help me

hi Sergei, i am new to programming. I want to do something similar to this but in visualstudio 2008, C#. Here is what i need to do.:- * i have to create a page consisting of address info of an employee, which consists of set of tables like Present address, permanent address, office address etc.(The number of such categories are to be fetched from database) * I have a table in database named AddressCategories which consists of values like Present, Permanent, office etc. When i add a new row in AddressCategories table in database, dynamically a new Table is to be created in my frontend. How shall i do this ? ? please help me