Float and Bigint

In SQL 2005, the Float has storage size 4 or 8 bytes, how does it has
range -2.23E308 to 2.23E308?
For BigInt, it has 8 bytes but has range -2E63 to 2E63-1?> In SQL 2005, the Float has storage size 4 or 8 bytes, how does it has
> range -2.23E308 to 2.23E308?
Float follows the IEEE 754 specification regarding approximate numeric
types. A wide range of values can be stored but not all decimal values
within the range can be exactly represented.
> For BigInt, it has 8 bytes but has range -2E63 to 2E63-1?
No, the bigint range from the Books Online is:
Integer (whole number) data from -2^63 (-9,223,372,036,854,775,808)
through 2^63-1 (9,223,372,036,854,775,807).
Hope this helps.
Dan Guzman
SQL Server MVP
"Alan T" <alanNOSPAMpltse@.yahoo.com.au> wrote in message
news:eK6eafT6HHA.484@.TK2MSFTNGP06.phx.gbl...
> In SQL 2005, the Float has storage size 4 or 8 bytes, how does it has
> range -2.23E308 to 2.23E308?
> For BigInt, it has 8 bytes but has range -2E63 to 2E63-1?
>

Fixed Table Size

I have a report with several tables inside and I would like to fix the
size of the tables regarding the number of detail rows and appear a
scroll bar to show the rest of the table and therefore having acess
to all table in one page. Is it possible? I'm using SRS 2000.
Thanks,
Pedro GeraldesOne suggestion is that you can use subreport to get the required functionality.
Amarnath
"pedro.geraldes@.netvisao.pt" wrote:
> I have a report with several tables inside and I would like to fix the
> size of the tables regarding the number of detail rows and appear a
> scroll bar to show the rest of the table and therefore having acess
> to all table in one page. Is it possible? I'm using SRS 2000.
> Thanks,
> Pedro Geraldes
>|||On Feb 4, 2:09 pm, Amarnath <Amarn...@.discussions.microsoft.com>
wrote:
> One suggestion is that you can use subreport to get the required functionality.
> Amarnath
>
I create the Subreport but it still show all information. How can I
limit the Display Area size of the Subreport?
>
> "pedro.geral...@.netvisao.pt" wrote:
> > I have a report with several tables inside and I would like to fix the
> > size of the tables regarding the number of detail rows and appear a
> > scroll bar to show the rest of the table and therefore having acess
> > to all table in one page. Is it possible? I'm using SRS 2000.
> > Thanks,
> > Pedro Geraldes- Hide quoted text -
> - Show quoted text -|||When you place a subreport from the toolbox, you need to expand the subreport
rectangle to fit into your page and the hori/verti scroll automatically comes
to your page depending up on the length of the report inside a subreport
Amarnath
"pedro.geraldes@.netvisao.pt" wrote:
> On Feb 4, 2:09 pm, Amarnath <Amarn...@.discussions.microsoft.com>
> wrote:
> > One suggestion is that you can use subreport to get the required functionality.
> >
> > Amarnath
> >
> I create the Subreport but it still show all information. How can I
> limit the Display Area size of the Subreport?
> >
> >
> > "pedro.geral...@.netvisao.pt" wrote:
> > > I have a report with several tables inside and I would like to fix the
> > > size of the tables regarding the number of detail rows and appear a
> > > scroll bar to show the rest of the table and therefore having acess
> > > to all table in one page. Is it possible? I'm using SRS 2000.
> >
> > > Thanks,
> >
> > > Pedro Geraldes- Hide quoted text -
> >
> > - Show quoted text -
>
>|||Are you working on SRS 2000? Because when I run the report the
subreport grows to show full information, that is more that the size
that I define for the subreport.|||currently I am on 2005 and I have worked on 2000 as well, very much. See that
you remove most of the spaces from the report which you are refering in your
subreport, ofcourse you cant make it very small subreport area and refer a
big report. Try different sizes..
Amarnath
"pedro.geraldes@.netvisao.pt" wrote:
> Are you working on SRS 2000? Because when I run the report the
> subreport grows to show full information, that is more that the size
> that I define for the subreport.
>

fixed page size

I have a page body and a page footer in my report. The page body has a table in its data region. It seems, based on the number of rows displayed, the footer section is adjusting itself tobe shown next to thelast row of the table. That is, if I want to show 15 records in a 2 page report, then in the first page there are 10 records and the footer appears after the 10 the record. But in the 2nd page, the footer is appearing immediately after the 5 record, the footer is appearing. the footer moves itself up to do so.
Question: Do do i make sure that the footer appears at the same place in all the reports irrespective of the data shown in the page body.
Thankx in advance.
Rajesh Jagadeesan.
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.For print-oriented output formats (such as image and PDF), you'll get the
footer in the same place on each page.
For online-oriented output formats (such as HTML), the footer appears
immediately after the last item on the logical page, so as not to leave a
useless blank space (which would force the user to scroll unnecessarily).
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:ukkjfTvcEHA.2520@.TK2MSFTNGP12.phx.gbl...
> I have a page body and a page footer in my report. The page body has a
table in its data region. It seems, based on the number of rows displayed,
the footer section is adjusting itself tobe shown next to thelast row of the
table. That is, if I want to show 15 records in a 2 page report, then in
the first page there are 10 records and the footer appears after the 10 the
record. But in the 2nd page, the footer is appearing immediately after the
5 record, the footer is appearing. the footer moves itself up to do so.
> Question: Do do i make sure that the footer appears at the same place in
all the reports irrespective of the data shown in the page body.
> Thankx in advance.
> Rajesh Jagadeesan.
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.

Fixed memory size on MSDE

I would like to limit memory (RAM) usage for MSDE.
Since there is no Enterprise manager - is there another way how to do it?
(-> SQL command?!)
Thank You
PetrHi Petr
Please read about sp_configure in the Books Online.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Petr Stejskal" <petr.stejskal@.txn.cz> wrote in message
news:uoi1VuKnDHA.1884@.TK2MSFTNGP09.phx.gbl...
> I would like to limit memory (RAM) usage for MSDE.
> Since there is no Enterprise manager - is there another way how to do it?
> (-> SQL command?!)
> Thank You
> Petr
>

Fixed datafile suddenly change to max "automaticgrow"

Hi to all,
If I give in a fixed datafile size ( say 80000 Mb ) for a couple of
datafiles SQL server is capturing the size on the filesystem and after
finishing I asume this size is dedicated to this particular file(s) and
checking this it seems to be OK....
however. . .
Checking this same fixed filesize the next moring the original size ( before
yesterdays action ) has returned and the 80000 Mb has been MOVED to the
"automatic grow file" part as max extented restriction. ( this part was
grayed out and is still grayed out ).
it seems that I have a problem when SQL server needs to expand . . . . .
( the application running this database has a mechanism to stop when 80pct
has been reached of just one datafile ( of many ) - no alternative on the
application part !! )
Is this a known issue or is this a SQL server BUG and how to fixe this '
Please help me out.
GKramer
The NetherlandsHi
I think you are using SQL Server 2005 , right? I have seen this behaviour
when you detach/attach the database and it should be fixed in SP1 , however
someone else can provide more info.
"Guus Kramer" <GuusKramer@.discussions.microsoft.com> wrote in message
news:1B126CF6-8A66-429A-8D2E-82D730C9502F@.microsoft.com...
> Hi to all,
> If I give in a fixed datafile size ( say 80000 Mb ) for a couple of
> datafiles SQL server is capturing the size on the filesystem and after
> finishing I asume this size is dedicated to this particular file(s) and
> checking this it seems to be OK....
> however. . .
> Checking this same fixed filesize the next moring the original size (
> before
> yesterdays action ) has returned and the 80000 Mb has been MOVED to the
> "automatic grow file" part as max extented restriction. ( this part was
> grayed out and is still grayed out ).
> it seems that I have a problem when SQL server needs to expand . . . . .
> ( the application running this database has a mechanism to stop when 80pct
> has been reached of just one datafile ( of many ) - no alternative on the
> application part !! )
> Is this a known issue or is this a SQL server BUG and how to fixe this '
> Please help me out.
> GKramer
> The Netherlands
>|||Uri,
Thanks for the quick reply.
Unfortionately we still use SQL serve 2000 ( 2005 is still being tested ).
No attach or detach has been made. . . .it just happened overnight !!!!!
Guus
"Uri Dimant" wrote:

> Hi
> I think you are using SQL Server 2005 , right? I have seen this behaviour
> when you detach/attach the database and it should be fixed in SP1 , howeve
r
> someone else can provide more info.
>
>
> "Guus Kramer" <GuusKramer@.discussions.microsoft.com> wrote in message
> news:1B126CF6-8A66-429A-8D2E-82D730C9502F@.microsoft.com...
>
>|||Hi
Well, so perhaps someone has changed this feature and you did not know , did
you?
"Guus Kramer" <GuusKramer@.discussions.microsoft.com> wrote in message
news:83ECCAAA-3E98-4F88-AC2E-99AD3F9E93DB@.microsoft.com...[vbcol=seagreen]
> Uri,
> Thanks for the quick reply.
> Unfortionately we still use SQL serve 2000 ( 2005 is still being tested ).
> No attach or detach has been made. . . .it just happened overnight !!!!!
> Guus
> "Uri Dimant" wrote:
>|||Uri,
I was the only DBA for Europe last week and no-one other than me ( and our
DBA team ) has access !!!! ( or even has the knowledge on this )
Guus
"Uri Dimant" wrote:

> Hi
> Well, so perhaps someone has changed this feature and you did not know , d
id
> you?
>
>
> "Guus Kramer" <GuusKramer@.discussions.microsoft.com> wrote in message
> news:83ECCAAA-3E98-4F88-AC2E-99AD3F9E93DB@.microsoft.com...
>
>|||Hi
Then I have no idea. It could be that a script will be ran to change the
settings , you know, there is no magic here :-))))
"Guus Kramer" <GuusKramer@.discussions.microsoft.com> wrote in message
news:70F7163C-82F1-4625-955E-C15FEBDB1D51@.microsoft.com...[vbcol=seagreen]
> Uri,
> I was the only DBA for Europe last week and no-one other than me ( and our
> DBA team ) has access !!!! ( or even has the knowledge on this )
> Guus
> "Uri Dimant" wrote:
>

Fixed datafile suddenly change to max "automaticgrow"

Hi to all,
If I give in a fixed datafile size ( say 80000 Mb ) for a couple of
datafiles SQL server is capturing the size on the filesystem and after
finishing I asume this size is dedicated to this particular file(s) and
checking this it seems to be OK....
however. . .
Checking this same fixed filesize the next moring the original size ( before
yesterdays action ) has returned and the 80000 Mb has been MOVED to the
"automatic grow file" part as max extented restriction. ( this part was
grayed out and is still grayed out ).
it seems that I have a problem when SQL server needs to expand . . . . .
( the application running this database has a mechanism to stop when 80pct
has been reached of just one datafile ( of many ) - no alternative on the
application part !! )
Is this a known issue or is this a SQL server BUG and how to fixe this '
Please help me out.
GKramer
The NetherlandsHi
I think you are using SQL Server 2005 , right? I have seen this behaviour
when you detach/attach the database and it should be fixed in SP1 , however
someone else can provide more info.
"Guus Kramer" <GuusKramer@.discussions.microsoft.com> wrote in message
news:1B126CF6-8A66-429A-8D2E-82D730C9502F@.microsoft.com...
> Hi to all,
> If I give in a fixed datafile size ( say 80000 Mb ) for a couple of
> datafiles SQL server is capturing the size on the filesystem and after
> finishing I asume this size is dedicated to this particular file(s) and
> checking this it seems to be OK....
> however. . .
> Checking this same fixed filesize the next moring the original size (
> before
> yesterdays action ) has returned and the 80000 Mb has been MOVED to the
> "automatic grow file" part as max extented restriction. ( this part was
> grayed out and is still grayed out ).
> it seems that I have a problem when SQL server needs to expand . . . . .
> ( the application running this database has a mechanism to stop when 80pct
> has been reached of just one datafile ( of many ) - no alternative on the
> application part !! )
> Is this a known issue or is this a SQL server BUG and how to fixe this '
> Please help me out.
> GKramer
> The Netherlands
>|||Uri,
Thanks for the quick reply.
Unfortionately we still use SQL serve 2000 ( 2005 is still being tested ).
No attach or detach has been made. . . .it just happened overnight !!!!!
Guus
"Uri Dimant" wrote:
> Hi
> I think you are using SQL Server 2005 , right? I have seen this behaviour
> when you detach/attach the database and it should be fixed in SP1 , however
> someone else can provide more info.
>
>
> "Guus Kramer" <GuusKramer@.discussions.microsoft.com> wrote in message
> news:1B126CF6-8A66-429A-8D2E-82D730C9502F@.microsoft.com...
> > Hi to all,
> >
> > If I give in a fixed datafile size ( say 80000 Mb ) for a couple of
> > datafiles SQL server is capturing the size on the filesystem and after
> > finishing I asume this size is dedicated to this particular file(s) and
> > checking this it seems to be OK....
> > however. . .
> >
> > Checking this same fixed filesize the next moring the original size (
> > before
> > yesterdays action ) has returned and the 80000 Mb has been MOVED to the
> > "automatic grow file" part as max extented restriction. ( this part was
> > grayed out and is still grayed out ).
> >
> > it seems that I have a problem when SQL server needs to expand . . . . .
> > ( the application running this database has a mechanism to stop when 80pct
> > has been reached of just one datafile ( of many ) - no alternative on the
> > application part !! )
> >
> > Is this a known issue or is this a SQL server BUG and how to fixe this '
> >
> > Please help me out.
> >
> > GKramer
> > The Netherlands
> >
>
>|||Hi
Well, so perhaps someone has changed this feature and you did not know , did
you?
"Guus Kramer" <GuusKramer@.discussions.microsoft.com> wrote in message
news:83ECCAAA-3E98-4F88-AC2E-99AD3F9E93DB@.microsoft.com...
> Uri,
> Thanks for the quick reply.
> Unfortionately we still use SQL serve 2000 ( 2005 is still being tested ).
> No attach or detach has been made. . . .it just happened overnight !!!!!
> Guus
> "Uri Dimant" wrote:
>> Hi
>> I think you are using SQL Server 2005 , right? I have seen this
>> behaviour
>> when you detach/attach the database and it should be fixed in SP1 ,
>> however
>> someone else can provide more info.
>>
>>
>> "Guus Kramer" <GuusKramer@.discussions.microsoft.com> wrote in message
>> news:1B126CF6-8A66-429A-8D2E-82D730C9502F@.microsoft.com...
>> > Hi to all,
>> >
>> > If I give in a fixed datafile size ( say 80000 Mb ) for a couple of
>> > datafiles SQL server is capturing the size on the filesystem and after
>> > finishing I asume this size is dedicated to this particular file(s) and
>> > checking this it seems to be OK....
>> > however. . .
>> >
>> > Checking this same fixed filesize the next moring the original size (
>> > before
>> > yesterdays action ) has returned and the 80000 Mb has been MOVED to the
>> > "automatic grow file" part as max extented restriction. ( this part was
>> > grayed out and is still grayed out ).
>> >
>> > it seems that I have a problem when SQL server needs to expand . . . .
>> > .
>> > ( the application running this database has a mechanism to stop when
>> > 80pct
>> > has been reached of just one datafile ( of many ) - no alternative on
>> > the
>> > application part !! )
>> >
>> > Is this a known issue or is this a SQL server BUG and how to fixe this
>> > '
>> >
>> > Please help me out.
>> >
>> > GKramer
>> > The Netherlands
>> >
>>|||Uri,
I was the only DBA for Europe last week and no-one other than me ( and our
DBA team ) has access !!!! ( or even has the knowledge on this )
Guus
"Uri Dimant" wrote:
> Hi
> Well, so perhaps someone has changed this feature and you did not know , did
> you?
>
>
> "Guus Kramer" <GuusKramer@.discussions.microsoft.com> wrote in message
> news:83ECCAAA-3E98-4F88-AC2E-99AD3F9E93DB@.microsoft.com...
> > Uri,
> >
> > Thanks for the quick reply.
> >
> > Unfortionately we still use SQL serve 2000 ( 2005 is still being tested ).
> > No attach or detach has been made. . . .it just happened overnight !!!!!
> >
> > Guus
> >
> > "Uri Dimant" wrote:
> >
> >> Hi
> >> I think you are using SQL Server 2005 , right? I have seen this
> >> behaviour
> >> when you detach/attach the database and it should be fixed in SP1 ,
> >> however
> >> someone else can provide more info.
> >>
> >>
> >>
> >>
> >>
> >> "Guus Kramer" <GuusKramer@.discussions.microsoft.com> wrote in message
> >> news:1B126CF6-8A66-429A-8D2E-82D730C9502F@.microsoft.com...
> >> > Hi to all,
> >> >
> >> > If I give in a fixed datafile size ( say 80000 Mb ) for a couple of
> >> > datafiles SQL server is capturing the size on the filesystem and after
> >> > finishing I asume this size is dedicated to this particular file(s) and
> >> > checking this it seems to be OK....
> >> > however. . .
> >> >
> >> > Checking this same fixed filesize the next moring the original size (
> >> > before
> >> > yesterdays action ) has returned and the 80000 Mb has been MOVED to the
> >> > "automatic grow file" part as max extented restriction. ( this part was
> >> > grayed out and is still grayed out ).
> >> >
> >> > it seems that I have a problem when SQL server needs to expand . . . .
> >> > .
> >> > ( the application running this database has a mechanism to stop when
> >> > 80pct
> >> > has been reached of just one datafile ( of many ) - no alternative on
> >> > the
> >> > application part !! )
> >> >
> >> > Is this a known issue or is this a SQL server BUG and how to fixe this
> >> > '
> >> >
> >> > Please help me out.
> >> >
> >> > GKramer
> >> > The Netherlands
> >> >
> >>
> >>
> >>
>
>|||Hi
Then I have no idea. It could be that a script will be ran to change the
settings , you know, there is no magic here :-))))
"Guus Kramer" <GuusKramer@.discussions.microsoft.com> wrote in message
news:70F7163C-82F1-4625-955E-C15FEBDB1D51@.microsoft.com...
> Uri,
> I was the only DBA for Europe last week and no-one other than me ( and our
> DBA team ) has access !!!! ( or even has the knowledge on this )
> Guus
> "Uri Dimant" wrote:
>> Hi
>> Well, so perhaps someone has changed this feature and you did not know ,
>> did
>> you?
>>
>>
>> "Guus Kramer" <GuusKramer@.discussions.microsoft.com> wrote in message
>> news:83ECCAAA-3E98-4F88-AC2E-99AD3F9E93DB@.microsoft.com...
>> > Uri,
>> >
>> > Thanks for the quick reply.
>> >
>> > Unfortionately we still use SQL serve 2000 ( 2005 is still being
>> > tested ).
>> > No attach or detach has been made. . . .it just happened overnight
>> > !!!!!
>> >
>> > Guus
>> >
>> > "Uri Dimant" wrote:
>> >
>> >> Hi
>> >> I think you are using SQL Server 2005 , right? I have seen this
>> >> behaviour
>> >> when you detach/attach the database and it should be fixed in SP1 ,
>> >> however
>> >> someone else can provide more info.
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> "Guus Kramer" <GuusKramer@.discussions.microsoft.com> wrote in message
>> >> news:1B126CF6-8A66-429A-8D2E-82D730C9502F@.microsoft.com...
>> >> > Hi to all,
>> >> >
>> >> > If I give in a fixed datafile size ( say 80000 Mb ) for a couple of
>> >> > datafiles SQL server is capturing the size on the filesystem and
>> >> > after
>> >> > finishing I asume this size is dedicated to this particular file(s)
>> >> > and
>> >> > checking this it seems to be OK....
>> >> > however. . .
>> >> >
>> >> > Checking this same fixed filesize the next moring the original size
>> >> > (
>> >> > before
>> >> > yesterdays action ) has returned and the 80000 Mb has been MOVED to
>> >> > the
>> >> > "automatic grow file" part as max extented restriction. ( this part
>> >> > was
>> >> > grayed out and is still grayed out ).
>> >> >
>> >> > it seems that I have a problem when SQL server needs to expand . . .
>> >> > .
>> >> > .
>> >> > ( the application running this database has a mechanism to stop when
>> >> > 80pct
>> >> > has been reached of just one datafile ( of many ) - no alternative
>> >> > on
>> >> > the
>> >> > application part !! )
>> >> >
>> >> > Is this a known issue or is this a SQL server BUG and how to fixe
>> >> > this
>> >> > '
>> >> >
>> >> > Please help me out.
>> >> >
>> >> > GKramer
>> >> > The Netherlands
>> >> >
>> >>
>> >>
>> >>
>>

Fix Table Size in Report

I have a report that uses a master-detail. The detail is a table. I have content that must be at the bottom of the page in the same place (so that when it prints, it is always on the bottom edge.

The problem I am having is that the whole report size changes depending on how many rows are in the table. For every row that is in the table, it pushes all the content below it down. So, if one record has 2 rows in the detail table, the content below will start at a different point than a record that has 8 rows in teh detail table.

How can I fix the height of the detail table, so that wheather there is 1 or 10 rows, the content below will be in the same spot:

Example:

---TopEdge---- -----TopEdge----
Some Data Some Data Some Data Some Data
SomeMoreData SomeMoreData
Table Header Table Header
Table Row1 Table Row1
Table Row2
Table Row3
Table Row4
Content at Bottom Content at Bottom
Content at Bottom Content at Bottom
---BottomEdge--- ---BottomEdge---

Thanks

I see now that it does.

BTW: Is anyone else having problems with the website: www.gotreportviewer.com?

|||Have you fixed the height of the detail table? If so, please help me.

Thank you.

Ana

Fix a Table size on the Report?

Hi,
i have a report for a printing purpose (on A4 size).
Its a bill witch have on the top the adress etc.
On the bottom are some other informations.
My problem is now, i have in the middle of this report a table witch hold a
few products for this bill.
=> if the product amount is greater then 3 pieces (rows) the bottom part its
going on a second page :-(
How can i fix the maximum size of this table?
Thanks in advance for any Help
Volkanif your records are fixed to say 3/4 records you can think of options like
subreport and list, which will limit the boundary for your A4.
Amarnath
"msnews.microsoft.com" wrote:
> Hi,
> i have a report for a printing purpose (on A4 size).
> Its a bill witch have on the top the adress etc.
> On the bottom are some other informations.
> My problem is now, i have in the middle of this report a table witch hold a
> few products for this bill.
> => if the product amount is greater then 3 pieces (rows) the bottom part its
> going on a second page :-(
> How can i fix the maximum size of this table?
> Thanks in advance for any Help
> Volkan
>
>|||Ok, i will it try
"Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
news:D9E1C5EB-3A88-421F-BE91-1BCADD64BBD8@.microsoft.com...
> if your records are fixed to say 3/4 records you can think of options like
> subreport and list, which will limit the boundary for your A4.
> Amarnath
> "msnews.microsoft.com" wrote:
>> Hi,
>> i have a report for a printing purpose (on A4 size).
>> Its a bill witch have on the top the adress etc.
>> On the bottom are some other informations.
>> My problem is now, i have in the middle of this report a table witch hold
>> a
>> few products for this bill.
>> => if the product amount is greater then 3 pieces (rows) the bottom part
>> its
>> going on a second page :-(
>> How can i fix the maximum size of this table?
>> Thanks in advance for any Help
>> Volkan
>>

fitting a report into a single page

hello guys,

i am making a report which views atleast 20 columns..and on the default font size it is being rendered which is in 11 it is impossible to print it in a single page..

i am just wondering if it is possible if during the exporting to pdf, is it possible to fit it in a single page by shrinking its contents into a size that will fit the page..

any help will be highly appreciated..

thanks in advance!

Yes. Simply define your page large enough to contain all of the columns. Then export to PDF and print using 'fit to page' option. Warning, the print may be VERY small, but it will scale and be readable on a high quality printer. Remember to increase the length of your page in ratio with the width.|||

ok ill try that one..so that means there is no way you can do it in the reporting services..it is manually done in the acrobat during printing phase isn't it?

anyway thanks for the reply..it really helps!

fitting a report into a single page

hello guys,

i am making a report which views atleast 20 columns..and on the default font size it is being rendered which is in 11 it is impossible to print it in a single page..

i am just wondering if it is possible if during the exporting to pdf, is it possible to fit it in a single page by shrinking its contents into a size that will fit the page..

any help will be highly appreciated..

thanks in advance!

Yes. Simply define your page large enough to contain all of the columns. Then export to PDF and print using 'fit to page' option. Warning, the print may be VERY small, but it will scale and be readable on a high quality printer. Remember to increase the length of your page in ratio with the width.|||

ok ill try that one..so that means there is no way you can do it in the reporting services..it is manually done in the acrobat during printing phase isn't it?

anyway thanks for the reply..it really helps!