Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Display Modes
  #1 (permalink)  
Old August 10th, 2005, 05:13 PM
Registered User
 
Join Date: Aug 2005
Location: , , .
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?


  #2 (permalink)  
Old August 3rd, 2007, 06:05 AM
Registered User
 
Join Date: Aug 2007
Location: , , .
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.

  #3 (permalink)  
Old August 14th, 2007, 03:07 PM
Registered User
 
Join Date: Aug 2007
Location: Louisville, KY, USA.
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
  #4 (permalink)  
Old August 14th, 2007, 03:56 PM
Registered User
 
Join Date: Aug 2007
Location: Louisville, KY, USA.
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
  #5 (permalink)  
Old November 28th, 2007, 08:50 AM
Registered User
 
Join Date: Nov 2007
Location: Bangalore, Karnataka, India.
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.

  #6 (permalink)  
Old December 14th, 2007, 08:23 AM
Registered User
 
Join Date: Dec 2007
Location: krishnagiri, tamilnadu, India.
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,
  #7 (permalink)  
Old August 7th, 2009, 04: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.
  #8 (permalink)  
Old April 22nd, 2010, 11:02 AM
Registered User
 
Join Date: May 2005
Location: BRISTOL, , United Kingdom.
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?
  #9 (permalink)  
Old February 6th, 2012, 05:31 AM
Registered User
Points: 3, Level: 1
Points: 3, Level: 1 Points: 3, Level: 1 Points: 3, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
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
 


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
conditional formatting jeremy1048 Access 4 July 3rd, 2008 12:20 PM
Conditional formatting vemaju Excel VBA 2 June 6th, 2007 05: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 04:52 PM



All times are GMT -4. The time now is 07:59 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.