Friday, March 30, 2012

Page Break at End throws unwanted additional blank page in PDF

Hi,
Originally posted as "Extra Page Break thrown in Export to PDF" - however I
thought this might be misinterpreted as a page size issue.
We have a report which has a group. The "Page Break at End" option is
checked for the group. The report renders correctly in the report manager
with totals immediately under the last group.
Unfortunately, when exporting to PDF, an additional blank page is added.
Can this be avoided?
Note, the report has three tables which are directly on top of each other -
the tables are all sitting within a rectangle.
many thanks
MattJust a thought - Could I edit the RDL file directly and put a condition in
the PageBreak at End element - is this an possibility?
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:ex8fbmIGFHA.3732@.tk2msftngp13.phx.gbl...
> Hi,
> Originally posted as "Extra Page Break thrown in Export to PDF" - however
I
> thought this might be misinterpreted as a page size issue.
> We have a report which has a group. The "Page Break at End" option is
> checked for the group. The report renders correctly in the report manager
> with totals immediately under the last group.
> Unfortunately, when exporting to PDF, an additional blank page is added.
> Can this be avoided?
> Note, the report has three tables which are directly on top of each
other -
> the tables are all sitting within a rectangle.
> many thanks
> Matt
>|||In answer to editing the RDL - unfortunately, no.
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:eWdstsIGFHA.2824@.tk2msftngp13.phx.gbl...
> Just a thought - Could I edit the RDL file directly and put a condition in
> the PageBreak at End element - is this an possibility?
>
> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> news:ex8fbmIGFHA.3732@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > Originally posted as "Extra Page Break thrown in Export to PDF" -
however
> I
> > thought this might be misinterpreted as a page size issue.
> >
> > We have a report which has a group. The "Page Break at End" option is
> > checked for the group. The report renders correctly in the report
manager
> > with totals immediately under the last group.
> >
> > Unfortunately, when exporting to PDF, an additional blank page is added.
> > Can this be avoided?
> >
> > Note, the report has three tables which are directly on top of each
> other -
> > the tables are all sitting within a rectangle.
> >
> > many thanks
> >
> > Matt
> >
> >
>|||Actually, the additional page only seems to occur when the table has rows
after the last group - in my case, it's a grand total field
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:eWdstsIGFHA.2824@.tk2msftngp13.phx.gbl...
> Just a thought - Could I edit the RDL file directly and put a condition in
> the PageBreak at End element - is this an possibility?
>
> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> news:ex8fbmIGFHA.3732@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > Originally posted as "Extra Page Break thrown in Export to PDF" -
however
> I
> > thought this might be misinterpreted as a page size issue.
> >
> > We have a report which has a group. The "Page Break at End" option is
> > checked for the group. The report renders correctly in the report
manager
> > with totals immediately under the last group.
> >
> > Unfortunately, when exporting to PDF, an additional blank page is added.
> > Can this be avoided?
> >
> > Note, the report has three tables which are directly on top of each
> other -
> > the tables are all sitting within a rectangle.
> >
> > many thanks
> >
> > Matt
> >
> >
>|||I believe there are some issues with page breaks while exporting to PDFs..
Hopefully some of these kinds of things will be fixed as time goes forward,
I have yet to be able to eliminate all of the extra pages as well...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:ex8fbmIGFHA.3732@.tk2msftngp13.phx.gbl...
> Hi,
> Originally posted as "Extra Page Break thrown in Export to PDF" - however
> I
> thought this might be misinterpreted as a page size issue.
> We have a report which has a group. The "Page Break at End" option is
> checked for the group. The report renders correctly in the report manager
> with totals immediately under the last group.
> Unfortunately, when exporting to PDF, an additional blank page is added.
> Can this be avoided?
> Note, the report has three tables which are directly on top of each
> other -
> the tables are all sitting within a rectangle.
> many thanks
> Matt
>|||I have found a work around - although it's a bit clunky.
The issue seems to be where you have something appearing after the last
group. If there is nothing after the last group, the report exports to PDF
correctly. But because I want grand totals I have not been able to simply
put a summation in the table footer.
Firstly, I am using a stored procedure as my report data source.
I added two additional fields to my stored procedure result set a) a grand
total field and b) a last group flag.
I then put the grand total field into a footer row of the outermost group
and set the hidden property to an expression including the Last Group flag
which evaluates to false when at the last group.
This is not a particularly complex thing to work around - but was quite
painful as I resist having to use unintuitive solutions such as this because
they make maintenance more difficult :)
Note: I would have used pagenumbering to determine the last page but
unfortunately, the Global values for Pagenumber and TotalPages are not
accessible within the body of the report.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:OLxJc%23NGFHA.2932@.TK2MSFTNGP15.phx.gbl...
> I believe there are some issues with page breaks while exporting to PDFs..
> Hopefully some of these kinds of things will be fixed as time goes
forward,
> I have yet to be able to eliminate all of the extra pages as well...
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> news:ex8fbmIGFHA.3732@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > Originally posted as "Extra Page Break thrown in Export to PDF" -
however
> > I
> > thought this might be misinterpreted as a page size issue.
> >
> > We have a report which has a group. The "Page Break at End" option is
> > checked for the group. The report renders correctly in the report
manager
> > with totals immediately under the last group.
> >
> > Unfortunately, when exporting to PDF, an additional blank page is added.
> > Can this be avoided?
> >
> > Note, the report has three tables which are directly on top of each
> > other -
> > the tables are all sitting within a rectangle.
> >
> > many thanks
> >
> > Matt
> >
> >
>sql

Page break and subreports

I have a main report that calls subreports. When a subreport has enough data such that it will not fit into the remaining area of the current page the renderer inserts a page break leaving alot of ugly white space. Is there any way to sop this behaviour? This seems like a very basic thing.

not sure is this is the exact reason, but are u using 8.5 * 11 layout for subreport also, if yes u need to decrease it as per your req. because a ful page cannot be accomodated in a page and so ssrs inserts a page break

Priyank

|||

Priyank,

All of the subreports and the main report for that matter are 8.5 x 11 but what would I change them to? Let me give you an example of my problem. Lets say the first sub report takes up three inches of the first page when rendered. If the second sub report takes up less than the remaining space (5.5 inches) it prints on the same page otherwise it page breaks and starts on a new page. Since the subreports can vary in rendered length depending on data I have no idea what their size will be.

Another thread stated that subreports operate under and assumed KeepTogether. While this may explain what is happening it does not resolve the issue.

Page break and subreport

Hello,
Using SSRS 2005, SP1.
I've got a report which contains a subreport.
This subreport is based on a list and can display one or more records.
When i put the subreport in its parent report, i give it an height
which is equal to the height necessary for displaying one record.
When i run my report, if the subreport display one record, there's no
problem.
But if my subreport display more than one record, and then needs to
extend its height, the report works properly but i've got a blank page
after.
As i can't know how much records my subreport has to display, i don't
see how to resolve this problem of blank page.
Is there anyone who've got idea?
Thanks in advance.
Jerome
I hope my english is enough efficient to explain my problem!Jerome,
You're not alone! I am also having this problem, but I'm getting 2
blank pages after my subreport. I ran the subreport by itself and get
no blank pages. I also ran the parent report by itself and get no
blank pages. I only get the blank pages after the subreport when I put
the subreport inside the parent report.
I hope you get feedback because I need it too!!
jennifer
Jerome FAURE wrote:
> Hello,
> Using SSRS 2005, SP1.
> I've got a report which contains a subreport.
> This subreport is based on a list and can display one or more records.
> When i put the subreport in its parent report, i give it an height
> which is equal to the height necessary for displaying one record.
> When i run my report, if the subreport display one record, there's no
> problem.
> But if my subreport display more than one record, and then needs to
> extend its height, the report works properly but i've got a blank page
> after.
> As i can't know how much records my subreport has to display, i don't
> see how to resolve this problem of blank page.
> Is there anyone who've got idea?
> Thanks in advance.
> Jerome
> I hope my english is enough efficient to explain my problem!

Page break and on last record problem

Hello,

In crystal these are available-

1- Conditional Page break 'OnLastRecord'- I have few groups and if I put page break it breaks on each group even if that group has 2 rows but I want a break at the end of the page. So is there conditional page break in SSRS 2005.

2- I am also having problem with controlling Number of lines in a page, few pages are very long as compared to others, though when export to pdf it gives according to the page size set, but not while viewing, is there any work around to this in SSRS 2005.

I will appreciate any suggestion or comment.

regards

1 - this might help you get started http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1682115&SiteID=1 -- if not, what have you tried so far?

2 - when you say "few pages are very long as compared to others" you have to specify: what output format are you talking about? PDF uses printable page size, HTML uses interactive page size, Excel is different because it's allowed to have as many rows as are within an explicit page break set by your code.

I have tried to define "explicit" and "implicit" page breaks separately; see the grey shaded note close to the beginning of this post: http://spacefold.com/lisa/post/Reset-On-Group-(Page-X-of-XX-in-a-group%2c-within-a-total-Y-of-YY-for-the-report)%2c-SQL-Reporting-Services-Style-.aspx. You will also find something similar referenced in the thread to which I linked above.

The difference between behavior of "implicit" page breaks for different formats isn't a bug requiring a "workaround"; it's a feature <s>. Different formats do have different requirements and that's a fact of output life.

So if you want page breaks based on some condition which is external to formatting requirements for a given output format, IOW consistent across output formats, you need to define what that condition is explicitly.

>L<

|||

Thanks for the reply.

I think I am still having problem.

Here is what I am doing-

I have three groups - 1-Customer, 2-Department,3-Priority and the details.

1- need to break if customer = Inactive

2- need to break if Department = Closed

3- need to break Priority = normal

So I made first group - Group1(Customer) then inside that I made another groupd Group1A(for customer) without any header and footer and changed the Group expresseion with a boolean parameter 'PageBreak' as is mentioned in the article and similarly did the for other groups but still no luck and it is breaking with the Group. Please let me know if I am following this correctly.

I am hiding the boolean parameter as I don't want to prompt it.

thanks

|||

I think you are mixing up a couple of things. The idea of using a parameter had nothing to do with data-based conditional page breaks <s>.

That example I pointed you to had a condition that came in from the outside, so it was a parameter. Your condition has to do with your data, and I didn't mean you to emulate the parameter part . I'm sorry about this...

I wanted you to see the idea of the nested groups in which one group handles your real group break and the other one is responsible for the conditional page break, by grouping on what may be a completely unrelated expression. OK?

I don't have your exact data set but I have created an example with a completely arbitrary page break that is caused by a data condition, instead of the external (parameterized) condition in the other example I pointed to. I will tell you what I did and maybe this will be a better example for you. It isn't going to be *exactly* what you need. But it should show you what you have to do, depending on the effect you're after.

1. I have a table of orders for customers with locale data. I did a query out of this data that looks like this:

Code Snippet


SELECT Customer, Locale FROM OrderHeader ORDER BY Customer

2. In this dataset, let's say I wanted to group by the customer's last name. I only want page breaks if the Locale starts with "N". (I told you it was totally arbitrary! )

3. I set a group on a "normal" group break expression -- in this case

Code Snippet


=Fields!Customer.Value

I set this group to repeat headers since that happened to be where the headers were.

4. I create an outer group on the following, non-normal expression:

Code Snippet


=IIF(LEFT(Fields!Locale.Value,1) ="N",
Fields!Customer.Value,
False)

... and this is the group that has the page break.

Does this help you understand better? The point is, the outer group is going to force a page break when you provide the group break expression with the value that is actually changing, which I've done in the first argument to IIF() here. In the second argument, the value False isn't changing, and the outer group doesn't break.

>L<

|||

Thanks a lot, I thing I got it.

Is there anything like 'OnLastRecord' in SSRS.

and is there a way to get a certain number of rows in a page.

thanks

Page break and grouping question

Hi,
I have to make a report that shows 2 tables one above the other.
The both tables have grouping values, and I want in each page to
display the both tables so I'm making a page break in each group/
table.
The problem is that the both tables goes to separate pages...what I
want is a full page break after the second table is filled up
It looks simple, but I don't know how!
Something like this
---
table 1
record 1, record 2
table 2
record 1, record 2
---
->Break in the end
->Next page
---
table 1
record 1, record 2
table 2
record 1, record 2
---
Thanks for your help,Sorry, I forgot to say that the two tables have different datasets.
Thanks for your help.

Page break after X items

Is it possible to force a page break after a specified number of items in a table?
For instance, I have a name badge report but I'm running into a problem where some badges are sliced down the middle at page breaks when exporting to pdf or tiff. If I could force a page break after every 2nd or 3rd badge it would alleviate that problem.

Thanks in advance.Figured it out. I added a group on Code.GetCount(RowNumber(Nothing)) with a page break at the end and added this function:


public shared function GetCount(CurrentCount As Integer) As Integer
If CurrentCount Mod 2 = 0 Then
GetCount = CurrentCount-1
Else
GetCount = CurrentCount
End If
end function

|||

Hello Nblankton

that was a very good idea, I did try to use it but for some reason it only works with 2 records.

I tried to change it with Mod 4 (I thought that would break after 4 records but that is not the case, I page break after the 1,2 and 4th record).

I'm not sure if I'm missing something or it is a bug.

Any Idea?

Thank you

MQ

|||

You'd also need to also alter the CurrentCode-1 line to subtract the appropriate number so that for all four that returned number is the same.

Something like CurrentCode-(CurrentCode Mod 4)+1.

I worked out a different method later that I think is a little clearer, though. This groups by 3's:

public shared function GetCount(CurrentCount As Integer) As Integer
GetCount = (CurrentCount+1)/3
end function

|||

Hi Nblankton

thank you for the response, after I wrote the note I searched the forum and found this

"=Ceiling(RowNumber(Nothing)/4)" you can put any number (2,5,20) it works, without having to add any code.

Thank you for your help. adding a group to control the amount of record per page is a great idea.

MQ

|||hi, I hope someone can help me!
I don't understand where I must place "=Ceiling(RowNumber(Nothing)/4)"

I added a new group (I selected table, right-click Proprieties, groups and add)
and I've write "=Ceiling(RowNumber(Nothing)/4)" as expression, but when I tried to execute , an error rose!
A scope problem

did I wrong the place to write the expression?

Thanks in advance
sql

Page break after X items

Is it possible to force a page break after a specified number of items in a table?
For instance, I have a name badge report but I'm running into a problem where some badges are sliced down the middle at page breaks when exporting to pdf or tiff. If I could force a page break after every 2nd or 3rd badge it would alleviate that problem.

Thanks in advance.Figured it out. I added a group on Code.GetCount(RowNumber(Nothing)) with a page break at the end and added this function:


public shared function GetCount(CurrentCount As Integer) As Integer
If CurrentCount Mod 2 = 0 Then
GetCount = CurrentCount-1
Else
GetCount = CurrentCount
End If
end function

|||

Hello Nblankton

that was a very good idea, I did try to use it but for some reason it only works with 2 records.

I tried to change it with Mod 4 (I thought that would break after 4 records but that is not the case, I page break after the 1,2 and 4th record).

I'm not sure if I'm missing something or it is a bug.

Any Idea?

Thank you

MQ

|||

You'd also need to also alter the CurrentCode-1 line to subtract the appropriate number so that for all four that returned number is the same.

Something like CurrentCode-(CurrentCode Mod 4)+1.

I worked out a different method later that I think is a little clearer, though. This groups by 3's:

public shared function GetCount(CurrentCount As Integer) As Integer
GetCount = (CurrentCount+1)/3
end function

|||

Hi Nblankton

thank you for the response, after I wrote the note I searched the forum and found this

"=Ceiling(RowNumber(Nothing)/4)" you can put any number (2,5,20) it works, without having to add any code.

Thank you for your help. adding a group to control the amount of record per page is a great idea.

MQ

|||hi, I hope someone can help me!
I don't understand where I must place "=Ceiling(RowNumber(Nothing)/4)"

I added a new group (I selected table, right-click Proprieties, groups and add)
and I've write "=Ceiling(RowNumber(Nothing)/4)" as expression, but when I tried to execute , an error rose!
A scope problem

did I wrong the place to write the expression?

Thanks in advance

Page break after X items

Is it possible to force a page break after a specified number of items in a table?
For instance, I have a name badge report but I'm running into a problem where some badges are sliced down the middle at page breaks when exporting to pdf or tiff. If I could force a page break after every 2nd or 3rd badge it would alleviate that problem.

Thanks in advance.Figured it out. I added a group on Code.GetCount(RowNumber(Nothing)) with a page break at the end and added this function:


public shared function GetCount(CurrentCount As Integer) As Integer
If CurrentCount Mod 2 = 0 Then
GetCount = CurrentCount-1
Else
GetCount = CurrentCount
End If
end function

|||

Hello Nblankton

that was a very good idea, I did try to use it but for some reason it only works with 2 records.

I tried to change it with Mod 4 (I thought that would break after 4 records but that is not the case, I page break after the 1,2 and 4th record).

I'm not sure if I'm missing something or it is a bug.

Any Idea?

Thank you

MQ

|||

You'd also need to also alter the CurrentCode-1 line to subtract the appropriate number so that for all four that returned number is the same.

Something like CurrentCode-(CurrentCode Mod 4)+1.

I worked out a different method later that I think is a little clearer, though. This groups by 3's:

public shared function GetCount(CurrentCount As Integer) As Integer
GetCount = (CurrentCount+1)/3
end function

|||

Hi Nblankton

thank you for the response, after I wrote the note I searched the forum and found this

"=Ceiling(RowNumber(Nothing)/4)" you can put any number (2,5,20) it works, without having to add any code.

Thank you for your help. adding a group to control the amount of record per page is a great idea.

MQ

|||hi, I hope someone can help me!
I don't understand where I must place "=Ceiling(RowNumber(Nothing)/4)"

I added a new group (I selected table, right-click Proprieties, groups and add)
and I've write "=Ceiling(RowNumber(Nothing)/4)" as expression, but when I tried to execute , an error rose!
A scope problem

did I wrong the place to write the expression?

Thanks in advance

Page Break after sub report - Not by design

All,

I have a report for a Quote print that has 1 table with 1 group in it by Quote #. The detail level is showing the line items on the quote and a second detail line for a sub report to show any notes. If the quote has 1 line on it, I am always getting a page break after the sub report even if it doesn't display anything.

The report shows the following:

Note each of these will contain a rectangle that the text boxes are displayed in unless it is a sub-report then no rectange.

    Group header 1 - Address information

    Group header 1 - contains a sub report for some notes

    Group header 1 - Opening paragraph

    Group header 1 - Blank line

    Group header 1 - contains the line headings

    Detail - contains the line details

    Detail - contains the sub report for line notes

    Detail - blank line for spacing

    Group footer 1 - hidden based on expression

    Group footer 1 - hidden based on expression ** One of these 2 lines will print based on the expression

    Group footer 1 - sub report for more notes

    Group footer 1 - Closing paragraph

    Group footer 1 - Signature area

    Group footer 1 - sub report for last page of terms / scope notes. NOTE: This sub report also contains a table and the table has a page break before so that I can get these on another page.

So, after # 8 above there is a page break. The remaining footers before # 14 easily fit on the rest of the page. The group 1 also has a page break at the end so it breaks between quotes. I have tried to insert a page break on the rectangle for # 13 and remove the page break on the sub report in # 14 but although everything fits it doesn't page break before the sub report.

It looks like it always page breaks after the last page in the sub report.

Any ideas on how to get around this?

Thanks in advance,

Sherry

Try this:
1.- In the sub report (on every List or Rectangle you have):
1.1.- Right click, Properties.
1.2.- uncheck "Insert a page break after this list".
1.3.- Click on "Edit details group"
1.4.- uncheck "Page break at end".|||

Thanks for the feedback. I had tried that and then it wouldn't page break.

I did resolve it although I feel the original way should have worked.

I created another Group 1 for the same grouping clause (Quote #). This pushed my original grouping to Group 2. I then put a page break after Group #2. I only had a group footer for Group # 1 with the sub report in it. I had to take the sub report page break before off.

Thanks again,

Sherry

page break after list not working

Has anyone experienced a problem with page breaks after list's?
I have a list and i have selected for a page break after list but it does
not appear to be working?
How can I force a page break for each row process from the dataset?Dave,
Not sure if this will help but I think when viewing as html, the page break
is not shown, but should work in pdf format or print preview.
cheers,
Batty.
"dave" wrote:
> Has anyone experienced a problem with page breaks after list's?
> I have a list and i have selected for a page break after list but it does
> not appear to be working?
> How can I force a page break for each row process from the dataset?|||I resolved my problem by ensuring that the width of my lists and subreports
were clearly smaller than the page i was trying to print on. When you have a
subreport for example that has a width wider than the page, very strange
things will happen.
Hope this helps.

Page Break after a value in one of the report groups

There are 3 groups in my reportâ' grp1, grp2 and grp3, with grp1 at the top,
grp2 in the middle and grp3 at the bottom. I need to insert a page break when
the value of grp1 record becomes â'abcâ'. Is this possible? If so, I will
really appreciate if someone can let me know how.
Thanks in advance,
SauravDid you ever find out how to do this? I need a page break in a report just
like you are descibing.
Thanks
"sajmera" wrote:
> There are 3 groups in my reportâ' grp1, grp2 and grp3, with grp1 at the top,
> grp2 in the middle and grp3 at the bottom. I need to insert a page break when
> the value of grp1 record becomes â'abcâ'. Is this possible? If so, I will
> really appreciate if someone can let me know how.
> Thanks in advance,
> Saurav
>sql

Page break after a group ??

Hi all
In my report, a page break is getting addred for each group of records. Thus
if a group has only 3 lines of data , RS adds a page break and the next
grouping starts on a new page. Thereby making the report span in more pages
thatn expected.
I've checked the settings in the "edit group" window as well as on the table
properties but can not find anything that should cause these page breaks.
Any pointers are appreciated.
Thanks
KWould you verify that your RDL does not contain any PageBreakAtEnd tags.
What is the settings for the report and body heights?
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"k" <test@.msn.com> wrote in message
news:uluuhnghEHA.3964@.TK2MSFTNGP12.phx.gbl...
> Hi all
> In my report, a page break is getting addred for each group of records.
Thus
> if a group has only 3 lines of data , RS adds a page break and the next
> grouping starts on a new page. Thereby making the report span in more
pages
> thatn expected.
> I've checked the settings in the "edit group" window as well as on the
table
> properties but can not find anything that should cause these page breaks.
> Any pointers are appreciated.
> Thanks
> K
>|||here are my settings:
Report Height = 11"
Body height = 3.125"
The rdl conatined the "PageBreakAtend" tag in the first grouping tag. But
if I remove the tag completely, then at the end of the group, the page break
is not displayed but the Table header is displayed as if its a new page.
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
news:#2hN$wghEHA.384@.TK2MSFTNGP10.phx.gbl...
> Would you verify that your RDL does not contain any PageBreakAtEnd tags.
> What is the settings for the report and body heights?
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "k" <test@.msn.com> wrote in message
> news:uluuhnghEHA.3964@.TK2MSFTNGP12.phx.gbl...
> > Hi all
> >
> > In my report, a page break is getting addred for each group of records.
> Thus
> > if a group has only 3 lines of data , RS adds a page break and the next
> > grouping starts on a new page. Thereby making the report span in more
> pages
> > thatn expected.
> >
> > I've checked the settings in the "edit group" window as well as on the
> table
> > properties but can not find anything that should cause these page
breaks.
> >
> > Any pointers are appreciated.
> >
> > Thanks
> > K
> >
> >
>|||I am not quite sure what you in your RDL.
From the sounds of description, you did not understand why you were getting
a page break at the end of your group. You seemed to have resolved that by
the discovery of the PageBreakAtEnd tag in the first (outermost) group.
Do you have RepeatOnNewPage set for the table header or group header rows?
If you do then you will get a them repeated when a new page occurs.
If you want you can post your RDL I will take a look at it.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"k" <test@.msn.com> wrote in message
news:uyQYjQhhEHA.3476@.tk2msftngp13.phx.gbl...
> here are my settings:
> Report Height = 11"
> Body height = 3.125"
> The rdl conatined the "PageBreakAtend" tag in the first grouping tag. But
> if I remove the tag completely, then at the end of the group, the page
break
> is not displayed but the Table header is displayed as if its a new page.
>
> "Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
> news:#2hN$wghEHA.384@.TK2MSFTNGP10.phx.gbl...
> > Would you verify that your RDL does not contain any PageBreakAtEnd tags.
> > What is the settings for the report and body heights?
> > --
> > Bruce Johnson [MSFT]
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "k" <test@.msn.com> wrote in message
> > news:uluuhnghEHA.3964@.TK2MSFTNGP12.phx.gbl...
> > > Hi all
> > >
> > > In my report, a page break is getting addred for each group of
records.
> > Thus
> > > if a group has only 3 lines of data , RS adds a page break and the
next
> > > grouping starts on a new page. Thereby making the report span in more
> > pages
> > > thatn expected.
> > >
> > > I've checked the settings in the "edit group" window as well as on the
> > table
> > > properties but can not find anything that should cause these page
> breaks.
> > >
> > > Any pointers are appreciated.
> > >
> > > Thanks
> > > K
> > >
> > >
> >
> >
>

page break after 10 rows

I have a report with 1 grouping level, and I want to display only 10 records
per page. How can I force this grouping in RS, can I use functions like
Rownumber, and how precisely does it work ?Yes, search this forum, it's been mentioned loads of times in here.
Effectively use the RowNumber function divided by 10 with the Ceiling
function.
--
Regards
Chris
joia wrote:
> I have a report with 1 grouping level, and I want to display only 10
> records per page. How can I force this grouping in RS, can I use
> functions like Rownumber, and how precisely does it work ?|||Hi, the easiest way to do it, as i found out, is using this function:
System.Math.Ceiling (RowNumber (Nothing)/10)
where 10 can be replaced by a report parameter.
Cheers, Johan
"Chris McGuigan" wrote:
> Yes, search this forum, it's been mentioned loads of times in here.
> Effectively use the RowNumber function divided by 10 with the Ceiling
> function.
> --
> Regards
> Chris
> joia wrote:
> > I have a report with 1 grouping level, and I want to display only 10
> > records per page. How can I force this grouping in RS, can I use
> > functions like Rownumber, and how precisely does it work ?
>|||I am new to reporting services. Can you show me how to use this function?
Thanks,
Anna
"joia" wrote:
> Hi, the easiest way to do it, as i found out, is using this function:
> System.Math.Ceiling (RowNumber (Nothing)/10)
> where 10 can be replaced by a report parameter.
> Cheers, Johan
> "Chris McGuigan" wrote:
> > Yes, search this forum, it's been mentioned loads of times in here.
> > Effectively use the RowNumber function divided by 10 with the Ceiling
> > function.
> > --
> > Regards
> > Chris
> >
> > joia wrote:
> >
> > > I have a report with 1 grouping level, and I want to display only 10
> > > records per page. How can I force this grouping in RS, can I use
> > > functions like Rownumber, and how precisely does it work ?
> >|||I figure out how to use this function now.
Thank you for sharing this function.
Anna :)
"Anna" wrote:
> I am new to reporting services. Can you show me how to use this function?
> Thanks,
> Anna
> "joia" wrote:
> > Hi, the easiest way to do it, as i found out, is using this function:
> > System.Math.Ceiling (RowNumber (Nothing)/10)
> >
> > where 10 can be replaced by a report parameter.
> >
> > Cheers, Johan
> >
> > "Chris McGuigan" wrote:
> >
> > > Yes, search this forum, it's been mentioned loads of times in here.
> > > Effectively use the RowNumber function divided by 10 with the Ceiling
> > > function.
> > > --
> > > Regards
> > > Chris
> > >
> > > joia wrote:
> > >
> > > > I have a report with 1 grouping level, and I want to display only 10
> > > > records per page. How can I force this grouping in RS, can I use
> > > > functions like Rownumber, and how precisely does it work ?
> > >

Page break & Service Pack !

Can anyone let me know how I check which Service Pack I do have in SQL
Server Reporting Services.
The second problem is in the reporting services I can see all the pages but
when I export in to PDF I can see proper page break, any idea what's the
problem.
ThanksOn Oct 12, 10:01 am, "Rogers" <naiss...@.hotmail.com> wrote:
> Can anyone let me know how I check which Service Pack I do have in SQL
> Server Reporting Services.
> The second problem is in the reporting services I can see all the pages but
> when I export in to PDF I can see proper page break, any idea what's the
> problem.
> Thanks
The first answer is as follows:
SELECT SERVERPROPERTY('productversion') AS SQLServerVersion,
SERVERPROPERTY ('productlevel') AS ServicePackLevel, SERVERPROPERTY
('edition') AS SQLServerEdition
To get version specs check this link.
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185
For the second question, if I'm understanding you correctly, the
interface has no page breaks by default. it all appears as a single
page. The PDF renderer breaks it up into pages.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Is that version gave me SQL Server Reporting Services.
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1192244268.917148.26670@.e9g2000prf.googlegroups.com...
> On Oct 12, 10:01 am, "Rogers" <naiss...@.hotmail.com> wrote:
>> Can anyone let me know how I check which Service Pack I do have in SQL
>> Server Reporting Services.
>> The second problem is in the reporting services I can see all the pages
>> but
>> when I export in to PDF I can see proper page break, any idea what's the
>> problem.
>> Thanks
>
> The first answer is as follows:
> SELECT SERVERPROPERTY('productversion') AS SQLServerVersion,
> SERVERPROPERTY ('productlevel') AS ServicePackLevel, SERVERPROPERTY
> ('edition') AS SQLServerEdition
> To get version specs check this link.
> http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185
> For the second question, if I'm understanding you correctly, the
> interface has no page breaks by default. it all appears as a single
> page. The PDF renderer breaks it up into pages.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Oct 15, 8:46 am, "Rogers" <naiss...@.hotmail.com> wrote:
> Is that version gave me SQL Server Reporting Services.
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1192244268.917148.26670@.e9g2000prf.googlegroups.com...
> > On Oct 12, 10:01 am, "Rogers" <naiss...@.hotmail.com> wrote:
> >> Can anyone let me know how I check which Service Pack I do have in SQL
> >> Server Reporting Services.
> >> The second problem is in the reporting services I can see all the pages
> >> but
> >> when I export in to PDF I can see proper page break, any idea what's the
> >> problem.
> >> Thanks
> > The first answer is as follows:
> > SELECT SERVERPROPERTY('productversion') AS SQLServerVersion,
> > SERVERPROPERTY ('productlevel') AS ServicePackLevel, SERVERPROPERTY
> > ('edition') AS SQLServerEdition
> > To get version specs check this link.
> >http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185
> > For the second question, if I'm understanding you correctly, the
> > interface has no page breaks by default. it all appears as a single
> > page. The PDF renderer breaks it up into pages.
> > Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
If I understand you correctly, generally speaking, the service pack
level of SQL Server is the same as for SSRS/Reporting Services that
you are running. Hope this clarifies it further.
Regards,
Enrique Martinez
Sr. Software Consultant

Page break

Hello,

I'm using SQL 2005 reporting services.

I habe table with two group.

Group A and Group B.

I set Page break at start and at end for each group in order each group will be in the new page.

it is not working and I'm getting group A and B in the same page

Do you have visibility properties set on the groups? If so, pagebreaks will be ignored.|||

I know this problem but no, I have no visibility set.

I currently change from table to list and it seemse to work fine but still..

I have group A header and footer and also for group B

My problem is that the first header from group A is in the same page with first header from Group B

Also last record in the Group B in the same page with the footer from group A.

Aslo I have a problem with document map. I create a document map from group A and group B and if the content is not in a differed pages the document map build successfuly but the link is not correct

Page break

Hi All,

I have created one report. When I click on view report information about different countries will be displayed.

By default, reporting services breaks pages of report on some criteria.

I want to break the pages of report on country basis.

For example: Australia: page should include only rows belonging to Australia.

Please teach me how to do this.

Regards

Abdul

Hi Abdul,

Have a read on my article below

http://www.koffeekoder.com/ArticleDetails.aspx?id=339

|||

Hi,

I hope you already have a group created in your report based on Country field. If yes you just need to select the table, right click properties, select groups tab, from the group list select the desired group in your case it will be country and click edit.

you are now on Grouping & Sorting properties dialog box. Just check Page break at end check box and that should resolve your issue.

Cheers,

...

Dont forget to click "mark as answered" on the post that helped you.

...

sql

page break

Hi,
I have a report with multiple pages.
I added a page break but then went to the table properties and unchecked the
page break checkbox.
However, when i run the report from my vb.net application I can see a page
break at the end of each page. How can I delete the page breaks?
Thanks.You can get page breaks from groups, lists, etc... Either search through
the RDL or check each one of the items to ensure your not asking for page
breaks somewhere else...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"collie" <collie@.discussions.microsoft.com> wrote in message
news:ABEEBB6A-A408-48C0-A528-F881D5815A65@.microsoft.com...
> Hi,
> I have a report with multiple pages.
> I added a page break but then went to the table properties and unchecked
the
> page break checkbox.
> However, when i run the report from my vb.net application I can see a page
> break at the end of each page. How can I delete the page breaks?
> Thanks.

page break

I have a matrix and I want to insert a page break on a column group. I dont
see the option under grouping and sorting properties for my column groups
only on the rows?On Nov 2, 10:39 am, RYF <R...@.discussions.microsoft.com> wrote:
> I have a matrix and I want to insert a page break on a column group. I dont
> see the option under grouping and sorting properties for my column groups
> only on the rows?
Unfortunately, this functionality does not exist currently. A
workaround would be to create 2 matrices/matrix controls in the report
and have the columns you want on the odd pages in the first matrix
control (and do a page break after it) and the columns you want on the
even pages in the second matrix control (and do a page break after it
as well). Sorry that I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Page brakes after top group item

I just started with reporting services.
I created report that has two groujping items in the table. Everything works
fine just I always get second row for the top level group on the second
page. This doesn't make any sense to me
1) I am using HTML rending and I don't need all this pages
2) the top group item has only one detailed item and second has about 8
items they all can fit on one page even if viewed in collapsed state
3) There are no any forced page breaks for any table items and for table
itself.
Any ideas how to solve the problem?
ShimonSorry
I just figure out that it looks like that only in preview but on the site it
looks fine.
Thanks,
Shimon.
"Shimon Sim" <estshim@.att.net> wrote in message
news:eeQ3XrQeEHA.2376@.tk2msftngp13.phx.gbl...
> I just started with reporting services.
> I created report that has two groujping items in the table. Everything
works
> fine just I always get second row for the top level group on the second
> page. This doesn't make any sense to me
> 1) I am using HTML rending and I don't need all this pages
> 2) the top group item has only one detailed item and second has about 8
> items they all can fit on one page even if viewed in collapsed state
> 3) There are no any forced page breaks for any table items and for table
> itself.
> Any ideas how to solve the problem?
> Shimon
>

Page Borders

We're creating a text report (i.e. not tabular, etc.) that will run several
pages. We would like to have a border around each page, including the page
header and page footer. We've set a body border, but that doesn't draw
horizontal lines at the top an bottom of each page.
We've tried putting our controls in a rectange and expanding the rectange to
be encompass a page both vertically and horizontally, but the page header is
excluded from this border (plus we suspect we'll have additional problems if
our individual controls causes a page break). Also, though we have the
rectange control's height set to 9 inches, it shrinks such that it ends
after the last control in the region.
Any suggestions for defining a border on each page, the first page excluded
(it's a cover page)?
We're using MS Reporting Services 2005.
Thanks,
ChrisNot sure if this does exactly what you're looking for, but in addition
to the body border, have you tried putting horizontal lines in the page
header & page footer?
Eva Pierce Monsen|||Thanks for Eva's informative inputs,
Hi Chris.
As Eva has mentioned, you can explicitly customize the SSRS report's header
and footer sections in the VS 2005's report designer. Just right click on
the report designer's empty area and you'll find the "Page Header" and
"Page Footer" option in the context menu, select either one to edit the
template.
#Adding a Page Header and Footer to a Report
http://msdn2.microsoft.com/en-us/library/ms159677.aspx
BTW, as for the body's border setting, based on my local test, it also
works (display both horizental and vertical lines). I simply set the border
width and border style (solid) and the runtime report displays both
horizental and vertical border lines for the report body. I think the
problem you met is possibly specific to report body's size.
Hope this helps.
Regards,
Steven Cheng
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Steven,
The horizonal body borders appear when we first render the report. However,
when we export the report to PDF, the horizontal lines at the top & bottom
of the body do not appear. Also, the border does not encompass the header
and footer, so even if the horizontal lines did appear, it isn't quite what
we're looking for. The prototype I'm working off of is a MS Word document
that has a page border that does encompass the header & footer.
Any other suggestions?
Thanks,
Chris
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:NasHAxdjGHA.4528@.TK2MSFTNGXA01.phx.gbl...
> Thanks for Eva's informative inputs,
> Hi Chris.
> As Eva has mentioned, you can explicitly customize the SSRS report's
> header
> and footer sections in the VS 2005's report designer. Just right click on
> the report designer's empty area and you'll find the "Page Header" and
> "Page Footer" option in the context menu, select either one to edit the
> template.
> #Adding a Page Header and Footer to a Report
> http://msdn2.microsoft.com/en-us/library/ms159677.aspx
> BTW, as for the body's border setting, based on my local test, it also
> works (display both horizental and vertical lines). I simply set the
> border
> width and border style (solid) and the runtime report displays both
> horizental and vertical border lines for the report body. I think the
> problem you met is possibly specific to report body's size.
> Hope this helps.
> Regards,
> Steven Cheng
> Microsoft Online Community Support
>
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hi Chris,
Thanks for your response.
Yes, the body border solution has its natural limitation since it does not
include the Header and Footer sections. Have you tried Eva's suggestion on
customizing the UI through the Header and Footer template in the report
designer? As I've also mentioned in the previous message, you can right
click on the report designer's empty area and you'll find the "Page Header"
and "Page Footer" option in the context menu, select either one to edit the
template. Thus, you can put some report item(such as Line ) into the header
or footer section to simulate a border line. How do you think of this?
Regards,
Steven Cheng
Microsoft MSDN Online Support Lead
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hey Chris,
How are you doing on this issue, does the further suggestion help you some?
If there is still anything we can help, please feel free to post here.
Regards,
Steven Cheng
Microsoft MSDN Online Support Lead
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Page Blank

I have chart and table in my report.Depending upon groups i decide whether to show chart or not. when there is condition that chart should be invisible then my first page comes blank and data is shown from 2nd page.Thanks in advance
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.Try out generating the reports after removing all page
breaks if any.
>--Original Message--
>I have chart and table in my report.Depending upon groups
i decide whether to show chart or not. when there is
condition that chart should be invisible then my first
page comes blank and data is shown from 2nd page.Thanks in
advance
>--
>Posted using Wimdows.net NntpNews Component -
>Post Made from http://www.SqlJunkies.com/newsgroups Our
newsgroup engine supports Post Alerts, Ratings, and
Searching.
>.
>sql

Page allocationError

Hi all,
There a quite strange error i am getting :
"Could not allocate new page for database 'rough'. There are no more pages available in filegroup PRIMARY. Space can be created by dropping objects, adding additional files, or allowing file growth."

This database has unrestricted filegrowth, the current size of the datafile is 4.6GB and there is 9 GB space free on the hard disk.

The recovery model is full logged.
sql server 2k with sp3a.

any thoughts?

harshal.Run SP_SPACEUSED & SP_HELPDB for information on this database.|||Run SP_SPACEUSED & SP_HELPDB for information on this database.

what exactly should i be looking for?
It shows 4081.94 MB space used. And unallocated space is shown negative i.e. -9.74 MB.|||CHeck what is the space left on PRIMARY FILEGROUP.
Run SP_HELPFILE and use DBCC UPDATEUSAGE before running.|||Hi satya,
thanks for the reply.
after running dbcc updateusage, it updated the usage.
after running sp_helpfile it shows for primary filegroup size=4116480 KB
Max=5121024 KB
Growth=10%
when i try to increase the size of the primary datafile it again gives the same error.

thanks
harshal.|||Have you disabled auto grow on the primary filegroup?
Ensure there are no disk space issues where Primary filegroup is hosted.|||Have you disabled auto grow on the primary filegroup?
Ensure there are no disk space issues where Primary filegroup is hosted.
That is the whole problem auto grow is enabled and there is ample space on the drive where primary filegroup is hosted, still it is not allocating the space.|||See what happens when you manually expand the file by say 100 MB. You may be running into a timing conflict of some kind, with the growth set to 10%. At this point, the file will try to grow by almost half a gig. This will take some time. I would consider setting the filegrowth to a flat value. Probably 10 - 50 MB, depending on the growth rate of the database.|||See what happens when you manually expand the file by say 100 MB. You may be running into a timing conflict of some kind, with the growth set to 10%. At this point, the file will try to grow by almost half a gig. This will take some time. I would consider setting the filegrowth to a flat value. Probably 10 - 50 MB, depending on the growth rate of the database.

Ok I tried increasing the size of the database in units of 50 MB, it worked fine the first time when the size was 4095MB but after that if i try to increase it more even by 1 MB it gives me the same error.
What can possibly be the reason? can there be some kind of quota or some thing which may be configured?|||How much available disk space do you have on that drive?|||How much available disk space do you have on that drive?

free space on the drive is 9.04 GB.|||Hmm. Maybe there is an O/S limit on files? Never heard of such a thing, though. But, just to test out if it is the O/S playing with your head, try backing up the database a couple times to the same file. You should be able to create a file greater than 4GB in size. What O/S is this? 2K or 2K3?|||ok i'll try that.
its 2k server|||ok i'll try that.

But only on MONDAY :D

Time to call it a week !!! :rolleyes:|||Hmm. Maybe there is an O/S limit on files? Never heard of such a thing, though. But, just to test out if it is the O/S playing with your head, try backing up the database a couple times to the same file. You should be able to create a file greater than 4GB in size. What O/S is this? 2K or 2K3?Don't even go there! The SQL Server limits (http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_8dbn.asp) aren't an issue here!

-PatP|||Don't even go there! The SQL Server limits (http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_8dbn.asp) aren't an issue here!

-PatP

yeah thats right but then what is causing this?|||ok here is the error again:
"Error 5149: MODIFY FILE encountered operating system error 112(There is not enough space on the disk.) while attempting to expand the physical file."
it says that it is operating system error.
As if the os is not able to "SEE" the existing empty space.|||Harshal ... Yes ... Now that Mcrowley mentions it .. i remember reading about it somewhere...

I will bet a bottle of whiskey on your file system being FAT32. FAT32 file systems have a 4 GB file size limit ... you will need to convert your file system to NTFS in case you want a db file bigger than 4 GB.

Do tell if I am right ...|||http://support.microsoft.com/default.aspx?scid=kb;en-us;314463
Enigma: Looks like you are on to something there.|||http://www.microsoft.com/resources/documentation/Windows/XP/all/reskit/en-us/Default.asp?url=/resources/documentation/windows/xp/all/reskit/en-us/prkc_fil_tdrn.asp

take a look at this too|||http://sqljunkies.com/WebLog/enigma/archive/2004/05/14/2483.aspx|||Harshal ... Yes ... Now that Mcrowley mentions it .. i remember reading about it somewhere...

I will bet a bottle of whiskey on your file system being FAT32. FAT32 file systems have a 4 GB file size limit ... you will need to convert your file system to NTFS in case you want a db file bigger than 4 GB.

Do tell if I am right ...

Hey Enigma I owe you a Grand Single Malt on this.
Just now converted the file system to NTFS it was indeed fat32 and Bingooo !!|||Was this your prod system ?|||Was this your prod system ?
No Way!!
It is my personal workstation.|||Great zot man!

I'm certainly glad that you found your solution. I'm also deathly curious as to why on earth you'd run FAT32 on an NT workstation ?!?! We used to run FAT32 and/or unformatted volumes in the days of Win-NT 3.51, but the thought that you might be running FAT today never entered my mind!

-PatP|||Great zot man!

I'm certainly glad that you found your solution. I'm also deathly curious as to why on earth you'd run FAT32 on an NT workstation ?!?! We used to run FAT32 and/or unformatted volumes in the days of Win-NT 3.51, but the thought that you might be running FAT today never entered my mind!

-PatP
:D :D ;)
Actually a couple of weeks back my secondary hard disk had crashed and so the network admin gave me a spare disk, said that this is a temperory arrangement he would be giving me a new disk soon, but i never got that disk and i continued with what i had and never checked what the file system was.
:(

Page allocation error

Hi all,
There a quite strange error i am getting :
"Could not allocate new page for database 'rough'. There are no more pages
available in filegroup PRIMARY. Space can be created by dropping objects,
adding additional files, or allowing file growth."
This database has unrestricted filegrowth, the current size of the datafile
is 4.6GB and there is 9 GB space free on the hard disk.
The recovery model is full logged.
sql server 2k with sp3a.
any thoughts?
harshal.
Sometimes autogrow doesn't catch up with the space requirements, resulting in this error message. I suggest
you pre-allocate storage.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"harshal mistry" <harshal_in@.hotmail.com> wrote in message news:u3yRBFLOEHA.2716@.tk2msftngp13.phx.gbl...
> Hi all,
> There a quite strange error i am getting :
> "Could not allocate new page for database 'rough'. There are no more pages
> available in filegroup PRIMARY. Space can be created by dropping objects,
> adding additional files, or allowing file growth."
> This database has unrestricted filegrowth, the current size of the datafile
> is 4.6GB and there is 9 GB space free on the hard disk.
> The recovery model is full logged.
> sql server 2k with sp3a.
> any thoughts?
> harshal.
>
|||yeah for the same reason i tried to increase the size of the file from the
enterprise manager it still gave me the same error.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uGe3zrNOEHA.904@.TK2MSFTNGP12.phx.gbl...
> Sometimes autogrow doesn't catch up with the space requirements, resulting
in this error message. I suggest
> you pre-allocate storage.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "harshal mistry" <harshal_in@.hotmail.com> wrote in message
news:u3yRBFLOEHA.2716@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
pages[vbcol=seagreen]
objects,[vbcol=seagreen]
datafile
>
|||Seems to be a problem at the OS level, if SQL Server cannot allocate space even though space exists on the
hard drive. A couple of things to check is if you have disk quotas or compression.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"harshal mistry" <harshal_in@.hotmail.com> wrote in message news:eXi1eLOOEHA.3016@.tk2msftngp13.phx.gbl...
> yeah for the same reason i tried to increase the size of the file from the
> enterprise manager it still gave me the same error.
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:uGe3zrNOEHA.904@.TK2MSFTNGP12.phx.gbl...
> in this error message. I suggest
> news:u3yRBFLOEHA.2716@.tk2msftngp13.phx.gbl...
> pages
> objects,
> datafile
>
|||no there is no compression done on the disk and the funny thing is that if i
delete some thing on the disk then it allows me to allocate the space for
that database, but even if i dont delete anything and try to increase the
space on other database there is no problem.
what else do i be looking for?
Thanks and Regards,
Harshal.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ujLfGjOOEHA.3752@.TK2MSFTNGP12.phx.gbl...
> Seems to be a problem at the OS level, if SQL Server cannot allocate space
even though space exists on the
> hard drive. A couple of things to check is if you have disk quotas or
compression.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "harshal mistry" <harshal_in@.hotmail.com> wrote in message
news:eXi1eLOOEHA.3016@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
the[vbcol=seagreen]
in[vbcol=seagreen]
resulting
>

Page allocation error

Hi all,
There a quite strange error i am getting :
"Could not allocate new page for database 'rough'. There are no more pages
available in filegroup PRIMARY. Space can be created by dropping objects,
adding additional files, or allowing file growth."
This database has unrestricted filegrowth, the current size of the datafile
is 4.6GB and there is 9 GB space free on the hard disk.
The recovery model is full logged.
sql server 2k with sp3a.
any thoughts?
harshal.Sometimes autogrow doesn't catch up with the space requirements, resulting i
n this error message. I suggest
you pre-allocate storage.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"harshal mistry" <harshal_in@.hotmail.com> wrote in message news:u3yRBFLOEHA.2716@.tk2msftngp1
3.phx.gbl...
> Hi all,
> There a quite strange error i am getting :
> "Could not allocate new page for database 'rough'. There are no more pages
> available in filegroup PRIMARY. Space can be created by dropping objects,
> adding additional files, or allowing file growth."
> This database has unrestricted filegrowth, the current size of the datafil
e
> is 4.6GB and there is 9 GB space free on the hard disk.
> The recovery model is full logged.
> sql server 2k with sp3a.
> any thoughts?
> harshal.
>|||yeah for the same reason i tried to increase the size of the file from the
enterprise manager it still gave me the same error.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uGe3zrNOEHA.904@.TK2MSFTNGP12.phx.gbl...
> Sometimes autogrow doesn't catch up with the space requirements, resulting
in this error message. I suggest
> you pre-allocate storage.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "harshal mistry" <harshal_in@.hotmail.com> wrote in message
news:u3yRBFLOEHA.2716@.tk2msftngp13.phx.gbl...
pages[vbcol=seagreen]
objects,[vbcol=seagreen]
datafile[vbcol=seagreen]
>|||Seems to be a problem at the OS level, if SQL Server cannot allocate space e
ven though space exists on the
hard drive. A couple of things to check is if you have disk quotas or compre
ssion.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"harshal mistry" <harshal_in@.hotmail.com> wrote in message news:eXi1eLOOEHA.3016@.tk2msftngp1
3.phx.gbl...
> yeah for the same reason i tried to increase the size of the file from the
> enterprise manager it still gave me the same error.
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:uGe3zrNOEHA.904@.TK2MSFTNGP12.phx.gbl...
> in this error message. I suggest
> news:u3yRBFLOEHA.2716@.tk2msftngp13.phx.gbl...
> pages
> objects,
> datafile
>|||no there is no compression done on the disk and the funny thing is that if i
delete some thing on the disk then it allows me to allocate the space for
that database, but even if i dont delete anything and try to increase the
space on other database there is no problem.
what else do i be looking for?
Thanks and Regards,
Harshal.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ujLfGjOOEHA.3752@.TK2MSFTNGP12.phx.gbl...
> Seems to be a problem at the OS level, if SQL Server cannot allocate space
even though space exists on the
> hard drive. A couple of things to check is if you have disk quotas or
compression.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "harshal mistry" <harshal_in@.hotmail.com> wrote in message
news:eXi1eLOOEHA.3016@.tk2msftngp13.phx.gbl...
the[vbcol=seagreen]
in[vbcol=seagreen]
resulting[vbcol=seagreen]
>

Page allocation error

Hi all,
There a quite strange error i am getting :
"Could not allocate new page for database 'rough'. There are no more pages
available in filegroup PRIMARY. Space can be created by dropping objects,
adding additional files, or allowing file growth."
This database has unrestricted filegrowth, the current size of the datafile
is 4.6GB and there is 9 GB space free on the hard disk.
The recovery model is full logged.
sql server 2k with sp3a.
any thoughts?
harshal.Sometimes autogrow doesn't catch up with the space requirements, resulting in this error message. I suggest
you pre-allocate storage.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"harshal mistry" <harshal_in@.hotmail.com> wrote in message news:u3yRBFLOEHA.2716@.tk2msftngp13.phx.gbl...
> Hi all,
> There a quite strange error i am getting :
> "Could not allocate new page for database 'rough'. There are no more pages
> available in filegroup PRIMARY. Space can be created by dropping objects,
> adding additional files, or allowing file growth."
> This database has unrestricted filegrowth, the current size of the datafile
> is 4.6GB and there is 9 GB space free on the hard disk.
> The recovery model is full logged.
> sql server 2k with sp3a.
> any thoughts?
> harshal.
>|||yeah for the same reason i tried to increase the size of the file from the
enterprise manager it still gave me the same error.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uGe3zrNOEHA.904@.TK2MSFTNGP12.phx.gbl...
> Sometimes autogrow doesn't catch up with the space requirements, resulting
in this error message. I suggest
> you pre-allocate storage.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "harshal mistry" <harshal_in@.hotmail.com> wrote in message
news:u3yRBFLOEHA.2716@.tk2msftngp13.phx.gbl...
> > Hi all,
> > There a quite strange error i am getting :
> > "Could not allocate new page for database 'rough'. There are no more
pages
> > available in filegroup PRIMARY. Space can be created by dropping
objects,
> > adding additional files, or allowing file growth."
> >
> > This database has unrestricted filegrowth, the current size of the
datafile
> > is 4.6GB and there is 9 GB space free on the hard disk.
> >
> > The recovery model is full logged.
> > sql server 2k with sp3a.
> >
> > any thoughts?
> >
> > harshal.
> >
> >
>|||Seems to be a problem at the OS level, if SQL Server cannot allocate space even though space exists on the
hard drive. A couple of things to check is if you have disk quotas or compression.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"harshal mistry" <harshal_in@.hotmail.com> wrote in message news:eXi1eLOOEHA.3016@.tk2msftngp13.phx.gbl...
> yeah for the same reason i tried to increase the size of the file from the
> enterprise manager it still gave me the same error.
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:uGe3zrNOEHA.904@.TK2MSFTNGP12.phx.gbl...
> > Sometimes autogrow doesn't catch up with the space requirements, resulting
> in this error message. I suggest
> > you pre-allocate storage.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> >
> >
> > "harshal mistry" <harshal_in@.hotmail.com> wrote in message
> news:u3yRBFLOEHA.2716@.tk2msftngp13.phx.gbl...
> > > Hi all,
> > > There a quite strange error i am getting :
> > > "Could not allocate new page for database 'rough'. There are no more
> pages
> > > available in filegroup PRIMARY. Space can be created by dropping
> objects,
> > > adding additional files, or allowing file growth."
> > >
> > > This database has unrestricted filegrowth, the current size of the
> datafile
> > > is 4.6GB and there is 9 GB space free on the hard disk.
> > >
> > > The recovery model is full logged.
> > > sql server 2k with sp3a.
> > >
> > > any thoughts?
> > >
> > > harshal.
> > >
> > >
> >
> >
>|||no there is no compression done on the disk and the funny thing is that if i
delete some thing on the disk then it allows me to allocate the space for
that database, but even if i dont delete anything and try to increase the
space on other database there is no problem.
what else do i be looking for?
Thanks and Regards,
Harshal.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ujLfGjOOEHA.3752@.TK2MSFTNGP12.phx.gbl...
> Seems to be a problem at the OS level, if SQL Server cannot allocate space
even though space exists on the
> hard drive. A couple of things to check is if you have disk quotas or
compression.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "harshal mistry" <harshal_in@.hotmail.com> wrote in message
news:eXi1eLOOEHA.3016@.tk2msftngp13.phx.gbl...
> > yeah for the same reason i tried to increase the size of the file from
the
> > enterprise manager it still gave me the same error.
> >
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> > message news:uGe3zrNOEHA.904@.TK2MSFTNGP12.phx.gbl...
> > > Sometimes autogrow doesn't catch up with the space requirements,
resulting
> > in this error message. I suggest
> > > you pre-allocate storage.
> > >
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > http://www.karaszi.com/sqlserver/default.asp
> > >
> > >
> > > "harshal mistry" <harshal_in@.hotmail.com> wrote in message
> > news:u3yRBFLOEHA.2716@.tk2msftngp13.phx.gbl...
> > > > Hi all,
> > > > There a quite strange error i am getting :
> > > > "Could not allocate new page for database 'rough'. There are no more
> > pages
> > > > available in filegroup PRIMARY. Space can be created by dropping
> > objects,
> > > > adding additional files, or allowing file growth."
> > > >
> > > > This database has unrestricted filegrowth, the current size of the
> > datafile
> > > > is 4.6GB and there is 9 GB space free on the hard disk.
> > > >
> > > > The recovery model is full logged.
> > > > sql server 2k with sp3a.
> > > >
> > > > any thoughts?
> > > >
> > > > harshal.
> > > >
> > > >
> > >
> > >
> >
> >
>

Page Alignment+SubReport - Urgent

I have got 2 reports
(1) Main Report
(2) SubReport

From the main report, I have linked SubReport and the reports works well.

Here lies the problem,

Main Report is getting displayed in Page 1.

If the subreport has less number of rows from database, then the subreport starts displaying from the first page(following the main report details).

On the other hand, if the subreport has more rows from database, then the subreport starts displaying from the second page leaving the first page blank

Why is this?Help required

I need my subreport to get displayed from the first page following the details of the main report irrespective of the number of records fetched.this should be rather simple.

Uncheck the "Keep Together" option for the sub report.sql

Page (1:368132)

Hi,
Can i know the DBID with this reference Page (1:368132)'
I'm getting this error
EventID: 0x4000429C (17052) - Error: 7105, Severity: 22,
State: 6
Page (1:370082), slot 5 for text, ntext, or image node
does not exist.
Can anyone help '
Thanks in advance
Celso CorreiaUnfortunately, no. Please look at the errorlog and see if there are any
other related error messages that may tell you which database has this
problem.
This error could be caused by a database page corruption. So please run dbcc
checktable after you have determined which database/table has the issue.
Based on the page id, the database file could be quite large: about 2.9GB.
This might help.
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
This posting is provided "AS IS" with no warranties, and confers no rights.
"Miguel" <anonymous@.discussions.microsoft.com> wrote in message
news:070a01c494ca$d8f165a0$a401280a@.phx.gbl...
> Hi,
> Can i know the DBID with this reference Page (1:368132)'
> I'm getting this error
> EventID: 0x4000429C (17052) - Error: 7105, Severity: 22,
> State: 6
> Page (1:370082), slot 5 for text, ntext, or image node
> does not exist.
> Can anyone help '
> Thanks in advance
> Celso Correia
>

Page (1:368132)

Hi,
Can i know the DBID with this reference Page (1:368132)?
I'm getting this error
EventID: 0x4000429C (17052) - Error: 7105, Severity: 22,
State: 6
Page (1:370082), slot 5 for text, ntext, or image node
does not exist.
Can anyone help ?
Thanks in advance
Celso Correia
Unfortunately, no. Please look at the errorlog and see if there are any
other related error messages that may tell you which database has this
problem.
This error could be caused by a database page corruption. So please run dbcc
checktable after you have determined which database/table has the issue.
Based on the page id, the database file could be quite large: about 2.9GB.
This might help.
Wei Xiao [MSFT]
SQL Server Storage Engine Development
This posting is provided "AS IS" with no warranties, and confers no rights.
"Miguel" <anonymous@.discussions.microsoft.com> wrote in message
news:070a01c494ca$d8f165a0$a401280a@.phx.gbl...
> Hi,
> Can i know the DBID with this reference Page (1:368132)?
> I'm getting this error
> EventID: 0x4000429C (17052) - Error: 7105, Severity: 22,
> State: 6
> Page (1:370082), slot 5 for text, ntext, or image node
> does not exist.
> Can anyone help ?
> Thanks in advance
> Celso Correia
>

Page (1:14440325), slot 6 for text, ntext,or image node does not e

Hello,
This is the second time in less than 2 weeks this has happened to my db
server.
Page (1:14440325), slot 6 for text, ntext, or image node does not exist..
I have performed a dbcc checktable and UPDATE STATISTICS ��TBLNAME�� WITH
FULLSCAN after obtaining the table info. from the following
dbcc traceon(3604)
dbcc page(dbname,1, 14440325)
dbcc traceoFF(3604)
Do not know why it is happening��
TIA,
Manoj Kumar
DBCC is of limited use when dealing with BLOB data types. Generally when
you have repeated allocation mismatches, there is an underlying hardware
problem. I would check the system and application event logs for a disk
subsystem fault.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Manoj Kumar" <ManojKumar@.discussions.microsoft.com> wrote in message
news:C1AE4DDE-F52A-4151-A634-01BB3F3E3063@.microsoft.com...
> Hello,
> This is the second time in less than 2 weeks this has happened to my db
> server.
>
> Page (1:14440325), slot 6 for text, ntext, or image node does not exist..
> I have performed a dbcc checktable and UPDATE STATISTICS ��TBLNAME�� WITH
> FULLSCAN after obtaining the table info. from the following
> dbcc traceon(3604)
> dbcc page(dbname,1, 14440325)
> dbcc traceoFF(3604)
> Do not know why it is happening��
>
> TIA,
> --
> Manoj Kumar
|||Thanks Geoff.
I do not see any issues in the evt log which are related with physical disk
subsystem or RAM although the dbcc page(DBName,1, 19440325,2) does indicate a
data corruption!!
Manoj Kumar
"Geoff N. Hiten" wrote:

> DBCC is of limited use when dealing with BLOB data types. Generally when
> you have repeated allocation mismatches, there is an underlying hardware
> problem. I would check the system and application event logs for a disk
> subsystem fault.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Manoj Kumar" <ManojKumar@.discussions.microsoft.com> wrote in message
> news:C1AE4DDE-F52A-4151-A634-01BB3F3E3063@.microsoft.com...
>

PAE VS SQL Server AWE

Hi,
I have set the boot.ini /PAE and 3GB Parameters in my windows 2003 server
enterprise.
And SQL Server 2000 also open AWE's "Max Server Memory" as 6G (I have 8G
physical memory).
So, these 2 options -- boot.ini 3GB parameter and the "Max Server Memroy" of
SQL Server 2000 as 6G can use at the same time?
If can't, what's problem will happen?
Thanks!
AngiThis should be fine.
Problems can occur if you use /3GB when you have over 12GB of Memory,
although some people say you can go up to 16GB. You'd have to test it on
your system. But 6GB should be fine.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"angi" <enchiw@.msn.com> wrote in message
news:ezI0joVFFHA.3728@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have set the boot.ini /PAE and 3GB Parameters in my windows 2003 server
> enterprise.
> And SQL Server 2000 also open AWE's "Max Server Memory" as 6G (I have 8G
> physical memory).
> So, these 2 options -- boot.ini 3GB parameter and the "Max Server Memroy"
> of
> SQL Server 2000 as 6G can use at the same time?
> If can't, what's problem will happen?
> Thanks!
> Angi
>
>|||This is a multi-part message in MIME format.
--080509010402010100010709
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Ken Henderson from Microsoft (is he still there?) says in _The Guru's
Guide to SQL Server Architecture and Internals_ (awesome book - right up
there with _Inside SQL Server 2000, Second Edition_ by someone named
Kalen Delaney :-P ) that when you shrink the kernel mode address space
from 2GB to 1GB (with /3GB) one of the main things that suffers is "the
table Windows uses to manage the physical memory...such that it can
manage a maximum of only 16GB of physical memory." Is that right or is
12GB the magic figure?
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Kalen Delaney wrote:
>This should be fine.
>Problems can occur if you use /3GB when you have over 12GB of Memory,
>although some people say you can go up to 16GB. You'd have to test it on
>your system. But 6GB should be fine.
>
>
--080509010402010100010709
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Ken Henderson from Microsoft (is he still there?) says in <u>The
Guru's Guide to SQL Server Architecture and Internals</u> (awesome book
- right up there with <u>Inside SQL Server 2000, Second Edition</u> by
someone named Kalen Delaney <span class="moz-smiley-s4"><span> :-P </span></span>
) that when you shrink the kernel mode address space from 2GB to 1GB
(with /3GB) one of the main things that suffers is "the table Windows
uses to manage the physical memory...such that it can manage a maximum
of only 16GB of physical memory." Is that right or is 12GB the magic
figure?</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2"> database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2"> jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font face="Tahoma"
size="2"> +61 (2) 9296 3668 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2"> F</font></b><font face="Tahoma" size="2"> +61
(2) 9296 3885 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2">M</font></b><font face="Tahoma" size="2"> +61
(408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma" size="2">
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a></font></span> </p>
</div>
<br>
<br>
Kalen Delaney wrote:
<blockquote cite="mid%2336sKXXFFHA.3728@.TK2MSFTNGP14.phx.gbl"
type="cite">
<pre wrap="">This should be fine.
Problems can occur if you use /3GB when you have over 12GB of Memory,
although some people say you can go up to 16GB. You'd have to test it on
your system. But 6GB should be fine.
</pre>
</blockquote>
</body>
</html>
--080509010402010100010709--|||Hi
Officially, from MS, 16GB is the number, but some hardware vendors (they
might produce ES 7000's) have recommended to customers to use a maximum of
12GB.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message
news:unS1eUYFFHA.1264@.TK2MSFTNGP12.phx.gbl...
> Ken Henderson from Microsoft (is he still there?) says in _The Guru's
> Guide to SQL Server Architecture and Internals_ (awesome book - right up
> there with _Inside SQL Server 2000, Second Edition_ by someone named
> Kalen Delaney :-P ) that when you shrink the kernel mode address space
> from 2GB to 1GB (with /3GB) one of the main things that suffers is "the
> table Windows uses to manage the physical memory...such that it can
> manage a maximum of only 16GB of physical memory." Is that right or is
> 12GB the magic figure?
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
http://www.mallesons.com
>
> Kalen Delaney wrote:
> >This should be fine.
> >Problems can occur if you use /3GB when you have over 12GB of Memory,
> >although some people say you can go up to 16GB. You'd have to test it on
> >your system. But 6GB should be fine.
> >
> >
> >
>|||Yes, this is exactly what I wasa referring to.
That fact that YMMV.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:OxsVjraFFHA.3928@.TK2MSFTNGP15.phx.gbl...
> Hi
> Officially, from MS, 16GB is the number, but some hardware vendors (they
> might produce ES 7000's) have recommended to customers to use a maximum of
> 12GB.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message
> news:unS1eUYFFHA.1264@.TK2MSFTNGP12.phx.gbl...
>> Ken Henderson from Microsoft (is he still there?) says in _The Guru's
>> Guide to SQL Server Architecture and Internals_ (awesome book - right up
>> there with _Inside SQL Server 2000, Second Edition_ by someone named
>> Kalen Delaney :-P ) that when you shrink the kernel mode address space
>> from 2GB to 1GB (with /3GB) one of the main things that suffers is "the
>> table Windows uses to manage the physical memory...such that it can
>> manage a maximum of only 16GB of physical memory." Is that right or is
>> 12GB the magic figure?
>> --
>> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
>> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
>> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
> http://www.mallesons.com
>>
>> Kalen Delaney wrote:
>> >This should be fine.
>> >Problems can occur if you use /3GB when you have over 12GB of Memory,
>> >although some people say you can go up to 16GB. You'd have to test it on
>> >your system. But 6GB should be fine.
>> >
>> >
>> >
>

PAE VS SQL Server AWE

Hi,
I have set the boot.ini /PAE and 3GB Parameters in my windows 2003 server
enterprise.
And SQL Server 2000 also open AWE's "Max Server Memory" as 6G (I have 8G
physical memory).
So, these 2 options -- boot.ini 3GB parameter and the "Max Server Memroy" of
SQL Server 2000 as 6G can use at the same time?
If can't, what's problem will happen?
Thanks!
AngiThis should be fine.
Problems can occur if you use /3GB when you have over 12GB of Memory,
although some people say you can go up to 16GB. You'd have to test it on
your system. But 6GB should be fine.
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"angi" <enchiw@.msn.com> wrote in message
news:ezI0joVFFHA.3728@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have set the boot.ini /PAE and 3GB Parameters in my windows 2003 server
> enterprise.
> And SQL Server 2000 also open AWE's "Max Server Memory" as 6G (I have 8G
> physical memory).
> So, these 2 options -- boot.ini 3GB parameter and the "Max Server Memroy"
> of
> SQL Server 2000 as 6G can use at the same time?
> If can't, what's problem will happen?
> Thanks!
> Angi
>
>|||Ken Henderson from Microsoft (is he still there?) says in _The Guru's
Guide to SQL Server Architecture and Internals_ (awesome book - right up
there with _Inside SQL Server 2000, Second Edition_ by someone named
Kalen Delaney :-P ) that when you shrink the kernel mode address space
from 2GB to 1GB (with /3GB) one of the main things that suffers is "the
table Windows uses to manage the physical memory...such that it can
manage a maximum of only 16GB of physical memory." Is that right or is
12GB the magic figure?
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Kalen Delaney wrote:

>This should be fine.
>Problems can occur if you use /3GB when you have over 12GB of Memory,
>although some people say you can go up to 16GB. You'd have to test it on
>your system. But 6GB should be fine.
>
>|||Hi
Officially, from MS, 16GB is the number, but some hardware vendors (they
might produce ES 7000's) have recommended to customers to use a maximum of
12GB.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message
news:unS1eUYFFHA.1264@.TK2MSFTNGP12.phx.gbl...
> Ken Henderson from Microsoft (is he still there?) says in _The Guru's
> Guide to SQL Server Architecture and Internals_ (awesome book - right up
> there with _Inside SQL Server 2000, Second Edition_ by someone named
> Kalen Delaney :-P ) that when you shrink the kernel mode address space
> from 2GB to 1GB (with /3GB) one of the main things that suffers is "the
> table Windows uses to manage the physical memory...such that it can
> manage a maximum of only 16GB of physical memory." Is that right or is
> 12GB the magic figure?
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
http://www.mallesons.com
>
> Kalen Delaney wrote:
>
>|||Yes, this is exactly what I wasa referring to.
That fact that YMMV.
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:OxsVjraFFHA.3928@.TK2MSFTNGP15.phx.gbl...
> Hi
> Officially, from MS, 16GB is the number, but some hardware vendors (they
> might produce ES 7000's) have recommended to customers to use a maximum of
> 12GB.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message
> news:unS1eUYFFHA.1264@.TK2MSFTNGP12.phx.gbl...
> http://www.mallesons.com
>

PAE VS SQL Server AWE

Hi,
I have set the boot.ini /PAE and 3GB Parameters in my windows 2003 server
enterprise.
And SQL Server 2000 also open AWE's "Max Server Memory" as 6G (I have 8G
physical memory).
So, these 2 options -- boot.ini 3GB parameter and the "Max Server Memroy" of
SQL Server 2000 as 6G can use at the same time?
If can't, what's problem will happen?
Thanks!
Angi
This should be fine.
Problems can occur if you use /3GB when you have over 12GB of Memory,
although some people say you can go up to 16GB. You'd have to test it on
your system. But 6GB should be fine.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"angi" <enchiw@.msn.com> wrote in message
news:ezI0joVFFHA.3728@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have set the boot.ini /PAE and 3GB Parameters in my windows 2003 server
> enterprise.
> And SQL Server 2000 also open AWE's "Max Server Memory" as 6G (I have 8G
> physical memory).
> So, these 2 options -- boot.ini 3GB parameter and the "Max Server Memroy"
> of
> SQL Server 2000 as 6G can use at the same time?
> If can't, what's problem will happen?
> Thanks!
> Angi
>
>
|||Ken Henderson from Microsoft (is he still there?) says in _The Guru's
Guide to SQL Server Architecture and Internals_ (awesome book - right up
there with _Inside SQL Server 2000, Second Edition_ by someone named
Kalen Delaney :-P ) that when you shrink the kernel mode address space
from 2GB to 1GB (with /3GB) one of the main things that suffers is "the
table Windows uses to manage the physical memory...such that it can
manage a maximum of only 16GB of physical memory." Is that right or is
12GB the magic figure?
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Kalen Delaney wrote:

>This should be fine.
>Problems can occur if you use /3GB when you have over 12GB of Memory,
>although some people say you can go up to 16GB. You'd have to test it on
>your system. But 6GB should be fine.
>
>
|||Hi
Officially, from MS, 16GB is the number, but some hardware vendors (they
might produce ES 7000's) have recommended to customers to use a maximum of
12GB.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message
news:unS1eUYFFHA.1264@.TK2MSFTNGP12.phx.gbl...
> Ken Henderson from Microsoft (is he still there?) says in _The Guru's
> Guide to SQL Server Architecture and Internals_ (awesome book - right up
> there with _Inside SQL Server 2000, Second Edition_ by someone named
> Kalen Delaney :-P ) that when you shrink the kernel mode address space
> from 2GB to 1GB (with /3GB) one of the main things that suffers is "the
> table Windows uses to manage the physical memory...such that it can
> manage a maximum of only 16GB of physical memory." Is that right or is
> 12GB the magic figure?
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
http://www.mallesons.com
>
> Kalen Delaney wrote:
>
|||Yes, this is exactly what I wasa referring to.
That fact that YMMV.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:OxsVjraFFHA.3928@.TK2MSFTNGP15.phx.gbl...
> Hi
> Officially, from MS, 16GB is the number, but some hardware vendors (they
> might produce ES 7000's) have recommended to customers to use a maximum of
> 12GB.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message
> news:unS1eUYFFHA.1264@.TK2MSFTNGP12.phx.gbl...
> http://www.mallesons.com
>
sql