March 15, 2010 at 6:26 am
I am using SSRS 2005 to build reports. I am hosting a dashboard on SSRS report.
I am using 3 tables to load my KPIs.
It so happened that the list of KPIs outrunned and the dashboard is now displaying in 2 pages.
Although it is okey for other drillthrough reports, it is requirement to include the whole list of KPIs into on sheet/page instead of 2 pages.
Kindly advice the best way in which these 3 tables can be put into one page.
I tried setting, Try fitting table in one page for the last table and it dint work.
Please help!!!
March 16, 2010 at 2:36 pm
Hi,
Have you tried increasing Page Width and Page Height on Report Properties ?
Hope this helps,
Raj
March 17, 2010 at 12:57 am
Yes, I tried adding page Height, but no luck with that..
I changed from standard 11inch to 101inch still no change in the way the report was rendered!!
March 17, 2010 at 6:45 am
Hi,
In table properties click on "Keep together on one page if possible" something like this.May be it will give u the result in single page.
Thanks
veeren.:-)
Thanks & Regards,
Veeren.
Ignore this if you feel i am Wrong. 😉
March 18, 2010 at 9:52 am
Thank You, I tried that, but no luck, as my page consists of 3 tables and the last table is again split between two pages 🙁
March 18, 2010 at 9:03 pm
Try setting the Reports 'InteractiveSize' Height property to 0
March 22, 2010 at 12:12 am
Thanks a lot.. the interactive size set to 0inc, 0inc and it all fit into one page
works fine...
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply