Fit Table on one page if possible

has anyone had any luck with the table property option 'Fit Table on one page if possible'. Reporting services seems to ignore this. Anyone familiar with issues surrounding this property? RS seems to break the table at will. I am MOST concerned with this issue as it relates to exporting to .pdf. Any ideas or workarounds would be helpful (we are running sp2).

Thanks!

I usually use table with defined width and page size for A4 paper format.
|||Are you talking about the table's width and height properties? For me, this issue is height as that is what is causing the breaking to the next page. My table width is 7.5, and the height varies, but is usually set for 1.275. This of course doesn't truly reflect the height of the table once it's populated with a bunch of rows!|||I think I'm having the same problem as you. The report is fine except when exported to pdf/tiff where the page breaks occur across the middle of the table details. I enabled this property as suggested elsewhere but it didn't seem to have any effect.|||Have you tried putting the table inside a list an then play with the list properties? I use the keep together property and all my tables are on the same page.
|||I had the same problem before. When I exported the report to PDF, the last several columns were separeted onto next page. After lots of testing, I set the width of the report to 8, and keep the width of the table to 7.5, every field can be kept on the same page.|||

Hi ellenf ,

Habe you solved your "Fit Table" Problem?..I am also having this problem.

Is this a microsoft bug? if it is, is this fixed in RS2005?

Thanks in Advance

|||

No, I never did get this to work. I didn't attempt to put my tables into lists, because this report with about 100 tables is already difficult enough to maintain. I haven't played with 2005 yet, so i do not know if it is resolved.

sorry it's taken so long to answer, I haven't checked my threads in a while!

Fit Table on one page if possible

has anyone had any luck with the table property option 'Fit Table on one page if possible'. Reporting services seems to ignore this. Anyone familiar with issues surrounding this property? RS seems to break the table at will. I am MOST concerned with this issue as it relates to exporting to .pdf. Any ideas or workarounds would be helpful (we are running sp2).

Thanks!

I usually use table with defined width and page size for A4 paper format.|||Are you talking about the table's width and height properties? For me, this issue is height as that is what is causing the breaking to the next page. My table width is 7.5, and the height varies, but is usually set for 1.275. This of course doesn't truly reflect the height of the table once it's populated with a bunch of rows!|||I think I'm having the same problem as you. The report is fine except when exported to pdf/tiff where the page breaks occur across the middle of the table details. I enabled this property as suggested elsewhere but it didn't seem to have any effect.|||Have you tried putting the table inside a list an then play with the

list properties? I use the keep together property and all my tables are

on the same page.|||I had the same problem before. When I exported the report to PDF, the last several columns were separeted onto next page. After lots of testing, I set the width of the report to 8, and keep the width of the table to 7.5, every field can be kept on the same page.|||

Hi ellenf ,

Habe you solved your "Fit Table" Problem?..I am also having this problem.

Is this a microsoft bug? if it is, is this fixed in RS2005?

Thanks in Advance

|||

No, I never did get this to work. I didn't attempt to put my tables into lists, because this report with about 100 tables is already difficult enough to maintain. I haven't played with 2005 yet, so i do not know if it is resolved.

sorry it's taken so long to answer, I haven't checked my threads in a while!

Fit Table on one page if possible

has anyone had any luck with the table property option 'Fit Table on one page if possible'. Reporting services seems to ignore this. Anyone familiar with issues surrounding this property? RS seems to break the table at will. I am MOST concerned with this issue as it relates to exporting to .pdf. Any ideas or workarounds would be helpful (we are running sp2).

Thanks!

I usually use table with defined width and page size for A4 paper format.
|||Are you talking about the table's width and height properties? For me, this issue is height as that is what is causing the breaking to the next page. My table width is 7.5, and the height varies, but is usually set for 1.275. This of course doesn't truly reflect the height of the table once it's populated with a bunch of rows!|||I think I'm having the same problem as you. The report is fine except when exported to pdf/tiff where the page breaks occur across the middle of the table details. I enabled this property as suggested elsewhere but it didn't seem to have any effect.|||Have you tried putting the table inside a list an then play with the list properties? I use the keep together property and all my tables are on the same page.
|||I had the same problem before. When I exported the report to PDF, the last several columns were separeted onto next page. After lots of testing, I set the width of the report to 8, and keep the width of the table to 7.5, every field can be kept on the same page.|||

Hi ellenf ,

Habe you solved your "Fit Table" Problem?..I am also having this problem.

Is this a microsoft bug? if it is, is this fixed in RS2005?

Thanks in Advance

|||

No, I never did get this to work. I didn't attempt to put my tables into lists, because this report with about 100 tables is already difficult enough to maintain. I haven't played with 2005 yet, so i do not know if it is resolved.

sorry it's taken so long to answer, I haven't checked my threads in a while!

first setup

I setup yesterday sql server 2008 on VPC for studio Orcas. Everything was smooth, however when I finished setup I did not see familiar enterprise management studio which allows to manage database files. what I can do?

Did you install management studio? During install there's a question about components you wish to install, you have to mark "Workstation components, Books Online and development tools". If you click the "Advanced" button you'll see that Management Studio is located in Client Components -> Management Tools branch.

Actually, I had a similar problem. After full install (including workstation components) Management Studio wasn't in my program list, no idea why. I started the setup program again, chose to install workstation components again and now it works perfectly.

|||i did exactly as you wrote. I nade setup twice. And third time it did not allow me to pass by because everything is installed. However the only thing that I have installed is configuration tools.|||

I'm running into a similar problem. I had SQL Server 2005 w/ SQL Server Manager loaded on XP SP2. I uninstalled SQL Server 2005, and loaded SQL Server 2008. However the SQL Server Mgr application didn't load. I attempted to reinstall SQL Server 2008, but it says they're no components that have changed...which indicates that the SQL Server 2008 Manager must be loaded already (but I don't see it)?

first setup

I setup yesterday sql server 2008 on VPC for studio Orcas. Everything was smooth, however when I finished setup I did not see familiar enterprise management studio which allows to manage database files. what I can do?

Did you install management studio? During install there's a question about components you wish to install, you have to mark "Workstation components, Books Online and development tools". If you click the "Advanced" button you'll see that Management Studio is located in Client Components -> Management Tools branch.

Actually, I had a similar problem. After full install (including workstation components) Management Studio wasn't in my program list, no idea why. I started the setup program again, chose to install workstation components again and now it works perfectly.

|||i did exactly as you wrote. I nade setup twice. And third time it did not allow me to pass by because everything is installed. However the only thing that I have installed is configuration tools.|||

I'm running into a similar problem. I had SQL Server 2005 w/ SQL Server Manager loaded on XP SP2. I uninstalled SQL Server 2005, and loaded SQL Server 2008. However the SQL Server Mgr application didn't load. I attempted to reinstall SQL Server 2008, but it says they're no components that have changed...which indicates that the SQL Server 2008 Manager must be loaded already (but I don't see it)?

Firefox

I'm currently developing a ASP.NET v2 application in VS 2005. Historically,
I've used Crystal Reports and I'm very familiar with that system. However,
this application needs to be hosted by an ISP on the internet so I'm now
constrained by the services offered by the hosting service.
When I've investigated Crystal hosting, the price jumps up significantly and
I was told by one hosting company that if I did find a Crystal hosting
service, they are probably using a dodgy licensing model. This project is
also cost constrained...
However, companies like www.discountasp.net offer SQL Server 2005 with
reporting services for just $15 a month which is great. I'm just watching
the webcasts from Microsoft and reporting services looks ideal and pretty
neat.
But I'm little concerned about cross-browser compatibility... does anyone
have any comments on this? Firefox is probably the only other browser that I
must support.
Thanks, Rob.
PS.On Jan 16, 5:51 pm, "Rob" <rob_nicholson@.nospam_unforgettable.com>
wrote:
> I'm currently developing a ASP.NET v2 application in VS 2005. Historically,
> I've used Crystal Reports and I'm very familiar with that system. However,
> this application needs to be hosted by an ISP on the internet so I'm now
> constrained by the services offered by the hosting service.
> When I've investigated Crystal hosting, the price jumps up significantly and
> I was told by one hosting company that if I did find a Crystal hosting
> service, they are probably using a dodgy licensing model. This project is
> also cost constrained...
> However, companies likewww.discountasp.netoffer SQL Server 2005 with
> reporting services for just $15 a month which is great. I'm just watching
> the webcasts from Microsoft and reporting services looks ideal and pretty
> neat.
> But I'm little concerned about cross-browser compatibility... does anyone
> have any comments on this? Firefox is probably the only other browser that I
> must support.
> Thanks, Rob.
> PS
Generally speaking, the compatibility is pretty good with Firefox in
comparison with IE6 and IE7. There are a few drawbacks however. One is
that when viewing reports directly in the Report Manager, IE shows the
entire report page in the initial view; whereas, Firefox has a
scrunched down version about one-third the normal height of the report
page, which requires vertical scrolling to view the entire report. The
search control that is naturally a part of the toolbar in the Report
Manager for IE, does not exist in Firefox (though the user can select
Ctrl+F to do a search on the current page in Firefox; but, not quite
the same thing). Also, drill through report functionality does not
work as well in Firefox as it does in IE. Otherwise, the main
differences between Crystal Reports and SSRS are that: there are
slightly different export options, they have a different production
licensing scheme and that Crystal Reports expression syntax is
different than that of SSRS, which uses VB.NET syntax. Also, CR has
been around longer and has a few minor functionality options that SSRS
does not. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant