I posted this in the Cert section yesterday but got no response.
I see that the 05 MCDBA is out there, but there are no MSPress books:
http://www.microsoft.com/learning/mcp/mcitp/dbadmin/
Any companies out there that have these books already?
--
TIA,
ChrisR"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:6541B372-2B83-4974-82BB-7F41CF03C589@.microsoft.com...
>I posted this in the Cert section yesterday but got no response.
> I see that the 05 MCDBA is out there, but there are no MSPress books:
> http://www.microsoft.com/learning/mcp/mcitp/dbadmin/
> Any companies out there that have these books already?
> --
> TIA,
> ChrisR
Since the beta exams just released, I doubt anyone has books completed yet.
I know that Sybex is shooting for the end of the first quarter for their
Study Guides. I'm not sure about anyone else.
Having written a number of books for both Sybex and Sams, I would think that
you would begin seeing the first releases in the February - April timeframe,
but I could be wrong.
Rick Sawtell
MCT, MCSD, MCDBA
Showing posts with label section. Show all posts
Showing posts with label section. Show all posts
Sunday, March 25, 2012
Books for 05 MCDBA?
I posted this in the Cert section yesterday but got no response.
I see that the 05 MCDBA is out there, but there are no MSPress books:
http://www.microsoft.com/learning/mcp/mcitp/dbadmin/
Any companies out there that have these books already?
TIA,
ChrisR
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:6541B372-2B83-4974-82BB-7F41CF03C589@.microsoft.com...
>I posted this in the Cert section yesterday but got no response.
> I see that the 05 MCDBA is out there, but there are no MSPress books:
> http://www.microsoft.com/learning/mcp/mcitp/dbadmin/
> Any companies out there that have these books already?
> --
> TIA,
> ChrisR
Since the beta exams just released, I doubt anyone has books completed yet.
I know that Sybex is shooting for the end of the first quarter for their
Study Guides. I'm not sure about anyone else.
Having written a number of books for both Sybex and Sams, I would think that
you would begin seeing the first releases in the February - April timeframe,
but I could be wrong.
Rick Sawtell
MCT, MCSD, MCDBA
I see that the 05 MCDBA is out there, but there are no MSPress books:
http://www.microsoft.com/learning/mcp/mcitp/dbadmin/
Any companies out there that have these books already?
TIA,
ChrisR
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:6541B372-2B83-4974-82BB-7F41CF03C589@.microsoft.com...
>I posted this in the Cert section yesterday but got no response.
> I see that the 05 MCDBA is out there, but there are no MSPress books:
> http://www.microsoft.com/learning/mcp/mcitp/dbadmin/
> Any companies out there that have these books already?
> --
> TIA,
> ChrisR
Since the beta exams just released, I doubt anyone has books completed yet.
I know that Sybex is shooting for the end of the first quarter for their
Study Guides. I'm not sure about anyone else.
Having written a number of books for both Sybex and Sams, I would think that
you would begin seeing the first releases in the February - April timeframe,
but I could be wrong.
Rick Sawtell
MCT, MCSD, MCDBA
Books for 05 MCDBA?
I posted this in the Cert section yesterday but got no response.
I see that the 05 MCDBA is out there, but there are no MSPress books:
http://www.microsoft.com/learning/mcp/mcitp/dbadmin/
Any companies out there that have these books already?
TIA,
ChrisR"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:6541B372-2B83-4974-82BB-7F41CF03C589@.microsoft.com...
>I posted this in the Cert section yesterday but got no response.
> I see that the 05 MCDBA is out there, but there are no MSPress books:
> http://www.microsoft.com/learning/mcp/mcitp/dbadmin/
> Any companies out there that have these books already?
> --
> TIA,
> ChrisR
Since the beta exams just released, I doubt anyone has books completed yet.
I know that Sybex is shooting for the end of the first quarter for their
Study Guides. I'm not sure about anyone else.
Having written a number of books for both Sybex and Sams, I would think that
you would begin seeing the first releases in the February - April timeframe,
but I could be wrong.
Rick Sawtell
MCT, MCSD, MCDBAsql
I see that the 05 MCDBA is out there, but there are no MSPress books:
http://www.microsoft.com/learning/mcp/mcitp/dbadmin/
Any companies out there that have these books already?
TIA,
ChrisR"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:6541B372-2B83-4974-82BB-7F41CF03C589@.microsoft.com...
>I posted this in the Cert section yesterday but got no response.
> I see that the 05 MCDBA is out there, but there are no MSPress books:
> http://www.microsoft.com/learning/mcp/mcitp/dbadmin/
> Any companies out there that have these books already?
> --
> TIA,
> ChrisR
Since the beta exams just released, I doubt anyone has books completed yet.
I know that Sybex is shooting for the end of the first quarter for their
Study Guides. I'm not sure about anyone else.
Having written a number of books for both Sybex and Sams, I would think that
you would begin seeing the first releases in the February - April timeframe,
but I could be wrong.
Rick Sawtell
MCT, MCSD, MCDBAsql
Monday, March 19, 2012
Body values in Header and header values in body
Hi,
I want to display a value from db in the header section. I have read a couple of information that I should place the value in a in-visible text field an reference it in the header with the ReportItems. This works great with the first page but on the second page the header information are empty (I think because the Textfield is on Page 1 not Page 2)... So is there a way to accomplish that for all pages? Not only the first page....
My second one, hope you don't mind that I post it in the same thread, is:
My Report needs to display the total size of pages in the body. I did not realy found anything useful where I can retrieve from the total size of pages of my reports....
thanks for any help
f.
I have run into issues with wanting to display data in the report headers. I have pretty much moved on from wanting to do it since it is such a pain.
Also to show the total pages I put this code in the page footer, ="Page " & Globals!PageNumber & " of " & Globals!TotalPage. This will show the current page out of how many pages at the bottom of each page.
|||I have tried Globals!TotalPage but it cannot be placed in the body... I got an error message|||The Globals!TotalPages can only be used in a page header or footer, not in the body. You will have to add a page header or footer and then put it in a textbox there.
Sunday, February 19, 2012
Blank space between Details section and Page Footer section.
hey folks,
this is probably a newbe question, but please bear with me. so here is the deal i have this report and i have one grouping in it and then i've suppressed the Report Footer and have some stuff in the Page Footer. Here is a picture to illustrate this (i'll continue the question in my next post):So the problem is that when i Preview the report, it gives me blank space between my Details section and the Page Footer. Here is a picture of the problem. Can anyone explain this to me?
Thanks.|||Suppress GroupFooter1 if there's nothing in it.|||it's already suppressed.
Also, none of my sections has the Keep Together, No Page After, or Print At Bottom Of Page options checked.
Both Group Header #1 and Report Footer are hidden and suppressed.
And I still get the blank space.|||Hi,
May be a silly answer. But your report is displaying normal. Your report data is finished within the page (for ex half of the page). Your picture is displaying at the Page Footer. So the remaining space remains as blank.
Actually what do you want to do?|||O, so what you are saying is that the PageFooter always displays at the bottom of the page no matter what?
I knew it was a newbie question.
What i wanted was for the stuff in the Page Footer to display directly below the last record in the Details section, but i guess a Page Footer won't work for that.|||Yes, Hope you got it.
In your case, you can display the object (or anything) in the Report Footer area so that it will display right after the report. But it will display only at the end of the page not in all pages.
To display in all pages, you can use page footer and use some formula to restrict the display it is last page.
Ex.
Right Click your picture : Select Format Graphic option. Check Suppress and then click X-2 button. Select PageNumber and TotalPagecount from the PrintState functions list/enter the following
PageNumber = TotalPageCount
Click Ok.
Note. Place the picture in Page Footer as well as in Report Footer so that you can get the picture in all the pages except the last page and at the end of the report|||harmonycitra,
now you are confusing me. Maybe I am missunderstanding you about the Page Footer; in your first post you said that in case the report data is finished withing the page (for ex half the page) than having blank space between the Details and Page Footer sections is normal. Now, in your last post, you said that if i wanted to print something on each page right after the Details section, i can use the Page Footer. Please understand that by "right after the Details section" I mean no blank space between the Details section and the section that comes right below it, hence I can not use the Page Footer for that purpose since if I do a blank space would show up on the report if the data in Details has finished within the half of the page. Do you see the contradiction here or I am just not understanding what exactly is it that you were saying earlier?|||Sorry for the confusion.
Normally Page Footer will display at the bottom of each and every page. If a report contains 3 pages, the first two pages will be filled fully. The third page i,e the last page may not having the data to fill the entire page. In that case there will be a blank space appear between the Details and the Page Footer.
This is not because of page footer but because of detail section is finished half of the third page.
But the Report Footer will display at the end of the report. (always in the last page)
In your example which you had posted, try to put the totals in the report footer and finish the boxes, lines in Report Footer. It'll work fine.
Hope you understand. Otherwise I'll send some sample|||yes, i understand. i'd actually already put the summary lines, etc. in the Report Footer and it works fine, i just wanted to clear this up for myself. you learn something new every day i guess.
thanks for your help.
this is probably a newbe question, but please bear with me. so here is the deal i have this report and i have one grouping in it and then i've suppressed the Report Footer and have some stuff in the Page Footer. Here is a picture to illustrate this (i'll continue the question in my next post):So the problem is that when i Preview the report, it gives me blank space between my Details section and the Page Footer. Here is a picture of the problem. Can anyone explain this to me?
Thanks.|||Suppress GroupFooter1 if there's nothing in it.|||it's already suppressed.
Also, none of my sections has the Keep Together, No Page After, or Print At Bottom Of Page options checked.
Both Group Header #1 and Report Footer are hidden and suppressed.
And I still get the blank space.|||Hi,
May be a silly answer. But your report is displaying normal. Your report data is finished within the page (for ex half of the page). Your picture is displaying at the Page Footer. So the remaining space remains as blank.
Actually what do you want to do?|||O, so what you are saying is that the PageFooter always displays at the bottom of the page no matter what?
I knew it was a newbie question.
What i wanted was for the stuff in the Page Footer to display directly below the last record in the Details section, but i guess a Page Footer won't work for that.|||Yes, Hope you got it.
In your case, you can display the object (or anything) in the Report Footer area so that it will display right after the report. But it will display only at the end of the page not in all pages.
To display in all pages, you can use page footer and use some formula to restrict the display it is last page.
Ex.
Right Click your picture : Select Format Graphic option. Check Suppress and then click X-2 button. Select PageNumber and TotalPagecount from the PrintState functions list/enter the following
PageNumber = TotalPageCount
Click Ok.
Note. Place the picture in Page Footer as well as in Report Footer so that you can get the picture in all the pages except the last page and at the end of the report|||harmonycitra,
now you are confusing me. Maybe I am missunderstanding you about the Page Footer; in your first post you said that in case the report data is finished withing the page (for ex half the page) than having blank space between the Details and Page Footer sections is normal. Now, in your last post, you said that if i wanted to print something on each page right after the Details section, i can use the Page Footer. Please understand that by "right after the Details section" I mean no blank space between the Details section and the section that comes right below it, hence I can not use the Page Footer for that purpose since if I do a blank space would show up on the report if the data in Details has finished within the half of the page. Do you see the contradiction here or I am just not understanding what exactly is it that you were saying earlier?|||Sorry for the confusion.
Normally Page Footer will display at the bottom of each and every page. If a report contains 3 pages, the first two pages will be filled fully. The third page i,e the last page may not having the data to fill the entire page. In that case there will be a blank space appear between the Details and the Page Footer.
This is not because of page footer but because of detail section is finished half of the third page.
But the Report Footer will display at the end of the report. (always in the last page)
In your example which you had posted, try to put the totals in the report footer and finish the boxes, lines in Report Footer. It'll work fine.
Hope you understand. Otherwise I'll send some sample|||yes, i understand. i'd actually already put the summary lines, etc. in the Report Footer and it works fine, i just wanted to clear this up for myself. you learn something new every day i guess.
thanks for your help.
Subscribe to:
Posts (Atom)