Display the rows horizontally once the end of a page is reached
Hi, I have a report that has only 4 columns. I would like the report to be formatted in such a way that once the rows are all displayed till the height of a page instead of spanning to a new page the successive rows should be displayed as another tablix in the same page side by side. This should continue till the width of the page is complete and then it should move to the next page. That is the display should be first top to down then right (as a seperate tablix) till the width of the page is utilized. Can any provide me the steps to do this or point to some link that will help to achieve the same. I'm using a tabular report for this report Thanks and regardsVenkatesh. S|MCTS(WCF, ADO.NET 3.5)|eMail: heman_1978@hotmail.com
October 28th, 2010 9:08pm

Hi, You can achive this by using multi column report. After adding a new report, set the columns property to a desirable value based on the content you expect to print on the page. Then, in the first column pane do your designing. SSRS would render the page in multi column layout. Note : While previewing, you have to select the print layout (right click in the preview windows and choose), to see the multi column layout. under normal preview it does not appear so. Please refer http://p2p.wrox.com/content/articles/creating-mailing-labels-sql-server-reporting-services more on having multi column report layout (mailing label layout) Hope this helpsPlease click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH
Free Windows Admin Tool Kit Click here and download it now
October 28th, 2010 11:27pm

Hi Bilani, This solves only 30% of my problem only. As per my requirement I cannot put the contents directly in to the body of the report. I need to have a tablix and bind the dataset to the tablix. This is because I need to group the report based on few fields. So I did the following 1) I adjusted the column no to be 3 When I run the report I do not get the expected result. I see that columns of the tablix are all broken down, What I would like to have is that first display the contents from top - down and when the end of page is reached I would like to have the next set of rows to be displayed in the second column of the body. I'm I missing some setting. Venkatesh. S|MCTS(WCF, ADO.NET 3.5)|eMail: heman_1978@hotmail.com
October 29th, 2010 9:27pm

Hi VenkateshSrini, Currently, there is no process that i am aware of to handle this situation. This question had been asked here several monthes ago, however, there is no solution/workaround so far. I would suggest you submit a feedback at https://connect.microsoft.com/SQLServer/Feedback and hope microsoft provide a related feature to do it in the next release. thanks, Jerry
Free Windows Admin Tool Kit Click here and download it now
November 1st, 2010 10:55pm

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

Other recent topics Other recent topics