Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Large space between table

Author  Topic 

collie
Constraint Violating Yak Guru

400 Posts

Posted - 2009-06-02 : 09:36:09
Hi,

I have a report with a chart and a table.
The report is more than one page in length.
The chart and part of the table is displayed on the first page.
The rest of the table are shown on the next pages. However, when going to the next page there is a huge empty space before the table begins.
How can I eliminate the space?


Whisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-02 : 10:05:19
Edit the design and make the areas smaller?



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

collie
Constraint Violating Yak Guru

400 Posts

Posted - 2009-06-02 : 10:20:01
How do i do that?

Whisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-06-02 : 13:14:11
open report in visual studio and in report designer adjust space between table and other containers
Go to Top of Page

collie
Constraint Violating Yak Guru

400 Posts

Posted - 2009-06-03 : 09:46:49
HI,

The thing is that there are no spaces.




Whisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-03 : 10:12:36
You can drag the lower right corner of circle diagram to make it smaller...


E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-06-03 : 13:34:26
i think its because of chart and table overlapping in designer. can you move chart up or table down so that they dont overlap
Go to Top of Page

collie
Constraint Violating Yak Guru

400 Posts

Posted - 2009-06-04 : 08:03:24
visakh16 the overlapping was the problem.
Thanks Peso and visakh16 for the help.

Whisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-06-04 : 13:26:24
welcome
Go to Top of Page
   

- Advertisement -