Re: CF Report Builder Questions
Doh. Dale Fraser wrote: This is ColdFusion remember Change calc.PAGE_NUMBER = 1 to calc.PAGE_NUMBER eq 1 Regards Dale Fraser http://learncf.com http://flexcf.com -Original Message- From: Loathe [mailto:[EMAIL PROTECTED] Sent: Monday, 12 May 2008 10:15 AM To: CF-Talk Subject: CF 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 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305079 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF Report Builder Questions
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: Doh. Dale Fraser wrote: This is ColdFusion remember Change calc.PAGE_NUMBER = 1 to calc.PAGE_NUMBER eq 1 Regards Dale Fraser http://learncf.com http://flexcf.com -Original Message- From: Loathe [mailto:[EMAIL PROTECTED] Sent: Monday, 12 May 2008 10:15 AM To: CF-Talk Subject: CF 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 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305081 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Report Builder Questions
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. 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 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305082 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF Report Builder Questions
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. 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: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305083 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Report Builder Questions
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: 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. 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: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305085 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Report Builder Questions
This is ColdFusion remember Change calc.PAGE_NUMBER = 1 to calc.PAGE_NUMBER eq 1 Regards Dale Fraser http://learncf.com http://flexcf.com -Original Message- From: Loathe [mailto:[EMAIL PROTECTED] Sent: Monday, 12 May 2008 10:15 AM To: CF-Talk Subject: CF 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 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305075 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
