Wrox Programmer Forums
|
BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7
This is the forum to discuss the Wrox book Professional SQL ServerReporting Services by Paul Turley, Todd Bryant, James Counihan, George McKee, Dave DuVarney; ISBN: 9780764568787
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 10th, 2005, 04:13 PM
Registered User
 
Join Date: Aug 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Conditional Formatting on Page Breaks



Reporting Services Issue:



Our team is having a problems with the functionality in Reporting Services that generates page breaks. The page breaks don't seem to function when you add conditional logic to the visibility property of a control.



Project Goal:



Some sections of our reports are not to be displayed based on certain user entered parameters. When these sections are hidden, the page breaks were still displaying and creating multiple blank pages.



Attempted Solutions:



In an effort to resolve this issue, conditional logic was added to the page break rectangles in order to display or not display along with the other controls. This is where the issue was first noticed. The page breaks quit displaying regardless of the conditional logic.



After that attempt, there was a subreport created with the only object being a page break rectangle in order to abstract the page break from the conditional logic. On the report the conditional logic was then added to the subreport item containing the page break. The same results were observed.



In addition to the above mentioned solution attempts, embedding all page objects in a rectangle, multiple rectangles containing a page break, and every toolbox object was tested. All attempted solutions had the same results. Also, although this seems to be an issue others must have encountered, there is little information about page break logic online.



Questions:



Has anyone observed this problem, and if so, is there a solution?


 
Old August 3rd, 2007, 05:05 AM
Registered User
 
Join Date: Aug 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

Did you get any answer to this? I am facing this problem myself.

 
Old August 14th, 2007, 02:07 PM
Registered User
 
Join Date: Aug 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I am having the same exact problem that you are having. I am using a rectangle to set a conditional page break. Trying everyting I set a border color for my rectangle. When I run the report I see the rectangle. So my conditional statement is definately working. However it doesn't do the page break part.

If I take the conditional logic out, the rectangle does produce a page break.

What is really driving me crazy is that I have another report with conditional page breaks that appear to be working. I'm not sure if I got lucky or there is some setting that I have different.

Good luck with this one.

Dennis Branson
 
Old August 14th, 2007, 02:56 PM
Registered User
 
Join Date: Aug 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I searched all over the web and finally found the answer. I just applied it to my report and it worked perfectly.

You need to next two rectangles inside one another. Apply the conditional formatting to the outside rectangle. Then apply the page break to the inside rectangle.

You have now separated the conditional formatting from the page break.

Since the inside rectangle is only visible when the conditional statement is true, it only applies the page break when it is visible.

Pretty neat. Wish I could take credit for figuring this one out.

Dennis Branson
 
Old November 28th, 2007, 08:50 AM
Registered User
 
Join Date: Nov 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

This is a great post. I was struggling with the same problem that's reported.

Thank you very much.

 
Old December 14th, 2007, 08:23 AM
Registered User
 
Join Date: Dec 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I was also having the same problem. Now, I got it solved with the help of ur post. thank u.



with regards,
 
Old August 7th, 2009, 03:23 PM
Registered User
 
Join Date: Aug 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by DLBranson View Post
You need to next two rectangles inside one another. Apply the conditional formatting to the outside rectangle. Then apply the page break to the inside rectangle.
So that's exactly what I tried before I hit the forums and it hasn't been working for me.

Any ideas? This is really frustrating.
 
Old April 22nd, 2010, 10:02 AM
Registered User
 
Join Date: May 2005
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default I need to suppress PageBreak on 1st Page

Using a List Control my report outputs each record to a new page, as is required. I achieve the pagebreak with a Rectangle control.
The only thing is it throws a blank page at the beginning. Although this can be lived with it would be nice not to waste a page!
I can see how nested rectangles (visible expression etc) can be deployed to effect a conditional page break, but cannot find a way to detect the first page (or 1st dataset record), because Global variables are only available in the Header (or Footer).

Any ideas?
 
Old February 6th, 2012, 05:31 AM
Registered User
 
Join Date: Feb 2012
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default page break for a specific control!!

Hi,
I have a report on which countries names and their delegations will appear. However, on some pages, and at the end of the page, a country can stay alone when the members of the delegation are on the other page.
I tried Keep Together but didn’t work, this because I want all countries to be continued but if one country’s name stays at the end of the page it will be forced to join its delegation members on the next page.
I tried also the conditional break based on a control specific value, but this one will break the page every time at the same place even if the country fits in the page.
Is there any thing that helps to count access report lines or controls per page so I can apply a code on it to break at a specific place of the page ?

thanks





Similar Threads
Thread Thread Starter Forum Replies Last Post
conditional formatting jeremy1048 Access 4 July 3rd, 2008 11:20 AM
Conditional formatting vemaju Excel VBA 2 June 6th, 2007 04:41 AM
Conditional Formatting on Subform echovue Access 4 March 3rd, 2006 03:25 AM
Conditional Formatting Corey Access 1 November 8th, 2005 12:18 AM
Conditional Formatting... In Access??? lguzman Access VBA 2 September 23rd, 2004 03:52 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.