ColdFusion Report Builder Questions

So I'm new to report builder and full of question. I guess I'll start out easy and work my way up. In my header I need to have a letter head display only on the first page.  In the field Print when condition I added calc.PAGE_NUMBER = 1 Now the template throws an error.  How do I only display content on certain pages?  I need to doe the same thing with page numbers in the footer when calc.PAGE_NUMBER > 1. Additionally, I have a bunch of sub reports.  Sometimes the queries that drive these reports will not have any content, so I need for them to not display, I also need the paragraph number scheme not to get messed up. Each major section that is displayed needs to increment the number, but the number needs to not increment for those reports where recordCount eq 0. Is this possible? TIA

This is ColdFusion remember Change calc.PAGE_NUMBER = 1 to calc.PAGE_NUMBER eq 1 Regards Dale Fraser http://learncf.com http://flexcf.com So I'm new to report builder and full of question. I guess I'll start out easy and work my way up. In my header I need to have a letter head display only on the first page.  In the field Print when condition I added calc.PAGE_NUMBER = 1 Now the template throws an error.  How do I only display content on certain pages?  I need to doe the same thing with page numbers in the footer when calc.PAGE_NUMBER > 1. Additionally, I have a bunch of sub reports.  Sometimes the queries that drive these reports will not have any content, so I need for them to not display, I also need the paragraph number scheme not to get messed up. Each major section that is displayed needs to increment the number, but the number needs to not increment for those reports where recordCount eq 0. Is this possible? TIA

Doh. Dale Fraser wrote: ----- Excess quoted text cut - see Original Post for more -----

Next question. I have a label Subject: and a field query.title They are the same font and size, I dragged the boarders to the right places, but the field is slightly higher than the label.  How do I make this things align correctly? Loathe wrote: ----- Excess quoted text cut - see Original Post for more -----

I'm interested in this one... I actually ran into this again last night. There is a vertical alignment parameter for both of those objects, but as near as I can tell, it does not work. - Make sure your font size is the same. - The left side of the GUI has a whole bunch of alignment buttons that make life much easier then trying to drag everything around. - I manually reduce the height of the field and labels until they are essentially vertically centered. Trial and error here. You will find that Report Builder is really neat once you have a report all laid out, but it is one of the lesser refined applications that I've used. ----- Excess quoted text cut - see Original Post for more -----

The alignment buttons were just what I needed, thanks. Just shift clicked both elements, aligned top and done. Now to figure out  how to dynamically number the sections :) Terry Schmitt wrote: ----- Excess quoted text cut - see Original Post for more -----

Granted you needed to fix the eq, but there is also a Report Header band that you can use to show the letter head only on the first page. ----- Excess quoted text cut - see Original Post for more -----