Stonefield Query
 
Stonefield Site Map
Stonefield Support

  Overview
  Submit Support Ticket
  Forums
  Online Help Files
  Services
  Pre-Sales Support
Online Webinars
Video Demonstrations
Feature Requests
  Software Maintenance
  Support Testimonials
  FAQ's
Quick Links
Buy Now!
Download Free Trial
Watch a Video
Contact Us

 
 You are here: Support * Support Forums   Search

 Stonefield Query Support Forum

Welcome to the Stonefield Query Support Forum. Please note that in order to participate in the support forums, registration at our site is required. If you are already a member of our site, please sign-in.

 

Subject: spacing

You are not authorized to post a reply.   

Author Messages
bbrink
Posts:26

12/05/2007 10:02 AM Alert 

Hello,

I am using advanced layout to produce a summary report. All items in the detail band are suppressed via "Print only when expression is TRUE". Only the Group footer (where my summed fields are) prints. All of the fields are in one row, marked as "fix relative to top of band" and to NOT stretch with overflow. All data is visible in the report preview, none appears to be getting trimmed.

Then I run the report the rows of data are not evenly spaced.

I have searched for hidden elements in the group footer band to no avail.

I turned on "constant band height" but that did not do the trick.

Any tips on other things to check?

-Bob

 

tmansuy
Posts:166

12/05/2007 12:09 PM Alert 

Hi Bob,

If you are hiding all of the fields in the detail band with the "printwhen" condition, then I suggest removing them all completely and giving the detail band a height of 0.

Also, I have noticed that sometimes the report engine will do funny things with row spacing if a field isn't big enough to accomodate the data (even though you turned off the stretch with overflow). Most of the time, problems like this can be resolved by turning on the "use old report engine" checkbox in step 5 of the wizard.

If neither of these things are helpful, please send in an exported copy of the report, and some example output (perhaps to pdf) to support@stonefieldquery.com. If that isn't sufficient to determine what is going on, we may need to get your project and some sample data to test with here.

Trevor

bbrink
Posts:26

12/05/2007 1:20 PM Alert 
Trevor,

Removing all elements in the detail band did the trick. I was under the impression that they had to be there to process even though they were not being printed. Now I have a better understanding of how that works.

Thanks again YOU GUYS ARE GREAT!

Bob
You are not authorized to post a reply.



ActiveForums 3.6

 
 
   Privacy Statement  |  Terms Of Use
© 1996-2009 Stonefield Software Inc. All rights reserved.