q: this strange problem

Hello,
I have different sub-reports in my main report. I have rectangles around my
sub-reporta to be able to put page breaks te the start of rectangle. I need
to make some sub-report visible and invisible based on a parameter. However I
am using =iif(Parameters!MyPar.Value = "true",false, true) in the visibility
property and this creates problem in the page break of the visible reports.
Any idea?If the sub-report becomes not visible then the page break is ignored.
To fix this, use a seperate rectangle control (make it tiny and place
it below the subreport on the master report) and set the page break
property on this new rectangle control.
HTH-
Matt A

Q: Reset page number

Hello,
In the footer of my report I use â'Page of Pagesâ', now I need to reset this
number each time I need to go to next page through page navigation button in
the ReportViewer. Right now it shows total number of pages in the report.
Thanks,These are 2 different properties, does this not work?
=Globals.PageNumber & " of " & Globals.TotalPages
See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_expressions_v1_7ilv.asp?frame=true.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:7B5E05A8-28D8-405A-A096-880D7811312D@.microsoft.com...
> Hello,
> In the footer of my report I use "Page of Pages", now I need to reset this
> number each time I need to go to next page through page navigation button
> in
> the ReportViewer. Right now it shows total number of pages in the report.
> Thanks,
>|||Hi Brian,
Thanks for the reply. Here is my problem related to page number in reporting
services. Let say I am printing a report that goes different companies, what
you would do is that you can run report per company and your page numbers
would be fine. However if you run your report for all companies and send
different pages to different companies, in this case your current and total
page number is actually not correct, unless you reset it each time you are on
a new company. How can I do this?
"Brian Welcker [MSFT]" wrote:
> These are 2 different properties, does this not work?
> =Globals.PageNumber & " of " & Globals.TotalPages
> See
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_expressions_v1_7ilv.asp?frame=true.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
> news:7B5E05A8-28D8-405A-A096-880D7811312D@.microsoft.com...
> > Hello,
> > In the footer of my report I use "Page of Pages", now I need to reset this
> > number each time I need to go to next page through page navigation button
> > in
> > the ReportViewer. Right now it shows total number of pages in the report.
> > Thanks,
> >
>
>|||On Mon, 10 Oct 2005 07:05:33 -0500,
shiming927@.gmail-dot-com.no-spam.invalid (shiming927) wrote:
>thx
Hi,
At least as it appears in my newsreader, you have started a new
thread, with no link to the assumed earlier question.
I suggest you either repost your question (assuming you haven't had a
reply) or add meaningful information here. Reposting the question with
a clear title is probably the best option.
Andrew Watt
MVP - InfoPath

Q: report blank page

Hello,
Report.PageWidth - Report.LeftMargin - Report.Right Margin) >= Body.Width
8.5 â' 1 -1 >= 6.37
I still see one blank page with page header only when I go to print preview
in the Preview tab. What is problem?There are many issues with paging.. Mostly you just have to mess with things
trying to get what you want... One thing I have seen suggested is to set
your page size to 8.48 X 10.98
We tried it but it didn't help anything we were doing...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:F47EBC34-F211-4EDC-9B56-5F7D932D821F@.microsoft.com...
> Hello,
> Report.PageWidth - Report.LeftMargin - Report.Right Margin) >= Body.Width
> 8.5 - 1 -1 >= 6.37
> I still see one blank page with page header only when I go to print
> preview
> in the Preview tab. What is problem?
>|||I've also had this problem and here is what I do to fix/test it.
On the Layout tab the actual size of your canvas affects paging. I have all
of my canvas' set to 7.3 for the width and then I set the left and right
margins to .4 and that seems to fix the 'extra blank page' printing deal.
Give it a shot and good luck.
Peace,
Dan
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:F47EBC34-F211-4EDC-9B56-5F7D932D821F@.microsoft.com...
> Hello,
> Report.PageWidth - Report.LeftMargin - Report.Right Margin) >= Body.Width
> 8.5 - 1 -1 >= 6.37
> I still see one blank page with page header only when I go to print
> preview
> in the Preview tab. What is problem?
>