I need to print tickets for a conference tickets and paper is alreay of a specific size and dimension. something like below ------------------------------------------- Neeraj | some custome data (Print this section only on the first page if tickets ) Saini | (HEADER) are more then 1 page then skip this section) CA | ----------------------------------------- Ticket 1 |Ticket 7 (start printing from 2 row and 1 column) | ---------------------------------------- Ticket 2 |Ticket 8 | ---------------------------------------- Ticket 3 |Ticket 9 | ----------------------------------------- Ticket 4 |Ticket 10 | ---------------------------------------- Ticket 5 |Ticket 11 | ---------------------------------------- Footer | custome data (Print this section only on the first page if tickets | (FOOTER) are more then 1 page then skip this section) ---------------------------------------- it seems to me that for this kind I could use List control to display the reports and directly set the dimensions and size so that it could fit my requirement. 1) not able to find how to use it. 2) how to print the ticket on the 2 row 2 column. (see the diagram above) 3) Am i doing the right thing or there is something else i should do to resolve this problem.

how to add 2 column list control in ssrs usually i see it in a 1 column there is a control (Datalist )in the asp.net which has a property RepeatColumns Do we have something similar in the ssrs list

Please refer the comment at http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/ec3e709c-3e89-405c-8812-3abcbc99054c Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH

Hi, SSRS supports multi column reports. To enable multi columns report 1. open the report in designer and click outside the report layout area or select Report from property window dropdown. 2. in the properties window, locate columns property and click the + sign to drill down 3. Set the number of columns in the columns property (2,3 or 4) as required/possible by the report layout. 4. While previewing, right click on the report output area and select print layout to see the multi column output. Note : in normal preview mode, multi column does not get output as desired. please d select print layout. hope this helps.Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH

Thanks for your reply It does create the 2 columns in the report but the list is shown in the first column only what i want to show is something like this. -----Column 1-----------Column 2-------- Neeraj | some custome data (Print this section only on the first page if tickets ) Saini | are more then 1 page then skip this section) CA | ----------------------------------------- Ticket 1 |Ticket 7 (start printing from 2 row and 1 column) | ---------------------------------------- Ticket 2 |Ticket 8 | ---------------------------------------- Ticket 3 |Ticket 9 | ----------------------------------------- Ticket 4 |Ticket 10 | ---------------------------------------- Ticket 5 |Ticket 11 | ---------------------------------------- Footer | custome data (Print this section only on the first page if tickets | are more then 1 page then skip this section) but currently is show like this 2 column remains blank while rendering ----------------- Neeraj Saini CA | ------------------ Ticket 1 | ---------------------------------------- Ticket 2 | ---------------------------------------- Ticket 3 | ----------------------------------------- Ticket 4 | ---------------------------------------- Ticket 5 | ---------------------------------------- Footer |

I meant that i need to display 2 column list control in the ssrs

Hi NeerajSaini, Based on your information, I think you could utilize three tables to display your records. The first table is used to display your custome data, the second table is used to display Ticket1, Ticket2,.....Ticket6. The third table is used to display Ticket7, Ticket8,....Ticket11, you should add a filter to the second and third table to filter some records based on your requirement, as there is no such a suitable data region control to fit your scenario, you have to merge different data region controls to achieve the similar report layout. Of course, this is not a grace method, just a workaround for you, thanks for your understanding. Thanks, Challen Fu Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

You can't display 2 columns in the control list as far as I can tell. A workaround would be to have one column in the query source which is the value that will be selected when you pick an item from the list. You then create a second column which contains all the values you want to display but just concatenated together as a string and give it a name as you normally would in a select statement. In report deisgner or visual studio, when you select parameter properties (I'm using VS 2008) under the available values section, for valueField specify the name of the column you want to be selected when you pick an item from the list but under labelField specify the name of the concatenated list because that is what you want to display when the user clicks on the drop-down.

You can't display 2 columns in the control list as far as I can tell. A workaround would be to have one column in the query source which is the value that will be selected when you pick an item from the list. You then create a second column which contains all the values you want to display but just concatenated together as a string and give it a name as you normally would in a select statement. In report deisgner or visual studio, when you select parameter properties (I'm using VS 2008) under the available values section, for valueField specify the name of the column you want to be selected when you pick an item from the list but under labelField specify the name of the concatenated list because that is what you want to display when the user clicks on the drop-down.