Re: Report Builder Question
Denny, I have started to work in JasperReports, can you shoot me an email at your convenience? I have some questions about the set up for CF and JR to work together nicely. Email is first letter first name and full last name at gmail (stupid spam bots). Cheers, Mike Greider JasperReports is built right into coldfusion. You can create a jasperreport JRXML file using iReport, and use createObject to run the report, etc. I don't do it any more because report generation takes such a toll on the server, and it's just waay better to have report stuff running on a separate server, pulling from a replication database. So now I use JasperServer, and it's KICK ASS! For anyone doing a lot of reporting, I'd recommend it. Simply the best! But if you're stuck with pure CF, and need to do those common reporting things that are just impossible with reportbuilder, then createObject and jasperrepoerts might be the way to go, because you can build the reports with iReport, which is a STELLAR report-builder (cross platform y todo). HIH, :Denny -- If an injury has to be done to a man it should be so severe that his vengeance need not be feared. Niccolo Machiavelli ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314693 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Report Builder Question
Thank you for your help. I've played around with it for days now. Basically, I can get the information to only show on the last page without issue. However, when all of the fields have the remove line when blank option selected, the report still has all of the whitespace on each of the previous pages. If I shrink the entire band down to nothing and then add the option to allow to grow, then nothing displays (which is different than than the detail band). It's frustrating. Mike Yes, it sucks that the option is not available for the entire band. For it to suppress the footer, you have to set all of the fields' Remove line when blank property to true in the footer section. Also if there is blank space between your fields/lines try adding dummy labels with just a space for the text value and place it between your blank sections of the footer and be sure the set those field's Remove line when blank to true as well. Hope this helps. -Carlos It does prevent the text from being displayed, but the whitespace is still present. As far as I can see, there is no way to set that option on the entire footer, just all of the contents inside the footer. Thanks for the suggestion. I'm happy to try any option! Hi, Try setting the footer text Remove line when blank property to true. -Carlos ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309722 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Report Builder Question
Yes, it sucks that the option is not available for the entire band. For it to suppress the footer, you have to set all of the fields' Remove line when blank property to true in the footer section. Also if there is blank space between your fields/lines try adding dummy labels with just a space for the text value and place it between your blank sections of the footer and be sure the set those field's Remove line when blank to true as well. Hope this helps. -Carlos It does prevent the text from being displayed, but the whitespace is still present. As far as I can see, there is no way to set that option on the entire footer, just all of the contents inside the footer. Thanks for the suggestion. I'm happy to try any option! Hi, Try setting the footer text Remove line when blank property to true. -Carlos ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309470 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Report Builder Question
Yes, it sucks that the option is not available for the entire band. For it to suppress the footer, you have to set all of the fields' Remove line when blank property to true in the footer section. Also if there is blank space between your fields/lines try adding dummy labels with just a space for the text value and place it between your blank sections of the footer and be sure the set those field's Remove line when blank to true as well. Hope this helps. -Carlos It does prevent the text from being displayed, but the whitespace is still present. As far as I can see, there is no way to set that option on the entire footer, just all of the contents inside the footer. Thanks for the suggestion. I'm happy to try any option! Hi, Try setting the footer text Remove line when blank property to true. -Carlos ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309471 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Report Builder Question
It does prevent the text from being displayed, but the whitespace is still present. As far as I can see, there is no way to set that option on the entire footer, just all of the contents inside the footer. Thanks for the suggestion. I'm happy to try any option! Hi, Try setting the footer text Remove line when blank property to true. -Carlos ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309317 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Report Builder Question
Bummer. I have played around with this, and it is still causing problems. I created an invoice that I know will have two pages. Then, in the page footer, I hardcoded the print when condition to only print when the calc.PAGE_NUMBER is 2. This does hide/show the page footer on the appropriate page. However, it still reserves the space on the first page. So instead of the report printing the footer twice, it just has a blank spot on the first page and the real information on the second page. Any thoughts on this? Does anyone know the point man at Adobe that I could ping for some help? Cheers, Mike Mike, I agree it has to be easier. I have found a function that counts the pages in the report, however, I am still looking for how to access it... I haven't found any help yet, but apparently the function (Called beforeExport) counts the number of pages in your report and basically allows you to re-order the report, or insert a blank page if necessary. You should be able to harness this, as it will give you an on the fly page total count, which you should be able to then use to show/hide the page footer band. Otherwise, It seems that you have to have the Report Footer band set up in the space it is going to occupy, so that when the report is finished there is adequate space for it. It basically makes you waste space on the other pages in the report to ensure space for the report footer. I personally would rather hide a page footer to show the report footer, but there is this as a simpler solution. Hopefully someone knows how to access the functions in Report Builder and that would save a ton of hassle. Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309288 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Report Builder Question
Hi, Try setting the footer text Remove line when blank property to true. -Carlos Bummer. I have played around with this, and it is still causing problems. I created an invoice that I know will have two pages. Then, in the page footer, I hardcoded the print when condition to only print when the calc.PAGE_NUMBER is 2. This does hide/show the page footer on the appropriate page. However, it still reserves the space on the first page. So instead of the report printing the footer twice, it just has a blank spot on the first page and the real information on the second page. Any thoughts on this? Does anyone know the point man at Adobe that I could ping for some help? Cheers, Mike Mike, I agree it has to be easier. I have found a function that counts the pages in the report, however, I am still looking for how to access it... I haven't found any help yet, but apparently the function (Called beforeExport) counts the number of pages in your report and basically allows you to re-order the report, or insert a blank page if necessary. You should be able to harness this, as it will give you an on the fly page total count, which you should be able to then use to show/hide the page footer band. Otherwise, It seems that you have to have the Report Footer band set up in the space it is going to occupy, so that when the report is finished there is adequate space for it. It basically makes you waste space on the other pages in the report to ensure space for the report footer. I personally would rather hide a page footer to show the report footer, but there is this as a simpler solution. Hopefully someone knows how to access the functions in Report Builder and that would save a ton of hassle. Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309289 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Report Builder Question
Sorry for the delay. We just had a baby on the 11th, and I'm still figuring out how to juggle the little guy and all other tasks. Yes, it is being passed in via a query. Each line item has a name, and description field (which is an unlimited textarea). I have been debating trying to do what you mentioned. Loop through each line item and count all of the character returns or lines that exceed X characters (that are automatically wrapped). Which this number, I might be able to figure out how many pages there are. Then, on the page footer, I might be able to have only display on the last page (which would be a variable that I precalculated). Is this what you are thinking? It would be more simplistic if each line item was exactly the same, but that is not the case. Some are just a single line, others can be as many as ten lines a piece. Mike Mike, So how is it passed to the report? Through a Query? Does each product (item per invoice) have a set number of lines, or does each product take a single line. If it does, then you could just write a function in the report that took the number of items passed and divide by the number of items per page and then you can figure out the total number of pages. Again, not sure how the report is being hooked into the database, but I am sure that there will be someway to get consistent footer into it. Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309147 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Report Builder Question
Mike, Congratulations! Children are a joy, but I hope you are prepared for little sleep for some time! Anyways, yes, that was my thought, however I was hoping that you would know a few more details regarding the line items. If the information is stored in the database, is there anyway that you can do some of the line counts etc. on the addition of the new items? Or are the users able to basically change the line descriptions for each line item each time? If there were anyway to do a character count etc. before it was passed to the report, that would be better, because I think that you will find that the report generation will become sluggish if you are making it work to hard. Again, not something that I have ever done, but I think that it makes sense (well to me anyways) and should provide the answer that you are looking for... maybe? Rob On Wed, Jul 16, 2008 at 12:46 PM, Mike Greider [EMAIL PROTECTED] wrote: Sorry for the delay. We just had a baby on the 11th, and I'm still figuring out how to juggle the little guy and all other tasks. Yes, it is being passed in via a query. Each line item has a name, and description field (which is an unlimited textarea). I have been debating trying to do what you mentioned. Loop through each line item and count all of the character returns or lines that exceed X characters (that are automatically wrapped). Which this number, I might be able to figure out how many pages there are. Then, on the page footer, I might be able to have only display on the last page (which would be a variable that I precalculated). Is this what you are thinking? It would be more simplistic if each line item was exactly the same, but that is not the case. Some are just a single line, others can be as many as ten lines a piece. Mike Mike, So how is it passed to the report? Through a Query? Does each product (item per invoice) have a set number of lines, or does each product take a single line. If it does, then you could just write a function in the report that took the number of items passed and divide by the number of items per page and then you can figure out the total number of pages. Again, not sure how the report is being hooked into the database, but I am sure that there will be someway to get consistent footer into it. Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309150 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Report Builder Question
Thanks for your continued help. Yes, each user is able to can the line descriptions for each line item each time. I could count the characters in the description. That is certainly an option. It will have to be smart, because the descriptions can contain newlines as well. It sure is a terrible work around though. I wish you could just specify the report footer to print at the bottom like the page footer. This looks like my only solution, but it's really going to be hit and miss quite a bit. Mike, Congratulations! Children are a joy, but I hope you are prepared for little sleep for some time! Anyways, yes, that was my thought, however I was hoping that you would know a few more details regarding the line items. If the information is stored in the database, is there anyway that you can do some of the line counts etc. on the addition of the new items? Or are the users able to basically change the line descriptions for each line item each time? If there were anyway to do a character count etc. before it was passed to the report, that would be better, because I think that you will find that the report generation will become sluggish if you are making it work to hard. Again, not something that I have ever done, but I think that it makes sense (well to me anyways) and should provide the answer that you are looking for... maybe? Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309168 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Report Builder Question
Mike, I agree it has to be easier. I have found a function that counts the pages in the report, however, I am still looking for how to access it... I haven't found any help yet, but apparently the function (Called beforeExport) counts the number of pages in your report and basically allows you to re-order the report, or insert a blank page if necessary. You should be able to harness this, as it will give you an on the fly page total count, which you should be able to then use to show/hide the page footer band. Otherwise, It seems that you have to have the Report Footer band set up in the space it is going to occupy, so that when the report is finished there is adequate space for it. It basically makes you waste space on the other pages in the report to ensure space for the report footer. I personally would rather hide a page footer to show the report footer, but there is this as a simpler solution. Hopefully someone knows how to access the functions in Report Builder and that would save a ton of hassle. Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309171 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Report Builder Question
That is interesting. I do not have experience with the CFPDF tag, just the report builder. In combining the signature page, is it smart enough to put it at the bottom of the page, and only a new page if there is not enough room? Mike Does anyone know how to either (a) get a page footer to only I'm not aware of any way to do this from within the report builder, but you can take the generated PDF report and use the CFPDF tag to assemble a new PDF from your report and a separate signature page. This is covered in the Adobe Advanced ColdFusion 8 course. I can provide a code sample when I return to my office, if necessary. If you do this, though, the signature page will be the last page; it won't be appended to the last page of your report. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308983 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Report Builder Question
Hi Rob. I have, but I may not be smart enough about this. The number of pages is totally dynamic. It is an invoice with N number of products with N number of lines of description per each. I tried using the page number that is evaluated at the report run time, but that isn't working as a print when condition. I thought something like this would be my best chance, but I couldn't quite figure it out? Mike, Have you looked into the print when conditions for the band properties of the footer? If you were to know the max number of pages that were to be generated for the invoice you could pass that as a var to the report and then just do a print when condition on the calc.pagenumber function so that it equalled whatever the max number of pages were going to be. That is where I would start anyways. Rob On Thu, Jul 10, 2008 at 7:13 PM, Dave Watts [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308984 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Report Builder Question
JasperReports is built right into coldfusion. You can create a jasperreport JRXML file using iReport, and use createObject to run the report, etc. I don't do it any more because report generation takes such a toll on the server, and it's just waay better to have report stuff running on a separate server, pulling from a replication database. So now I use JasperServer, and it's KICK ASS! For anyone doing a lot of reporting, I'd recommend it. Simply the best! But if you're stuck with pure CF, and need to do those common reporting things that are just impossible with reportbuilder, then createObject and jasperrepoerts might be the way to go, because you can build the reports with iReport, which is a STELLAR report-builder (cross platform y todo). HIH, :Denny -- If an injury has to be done to a man it should be so severe that his vengeance need not be feared. Niccolo Machiavelli On Sun, Jul 13, 2008 at 10:04 AM, Mike Greider [EMAIL PROTECTED] wrote: Hi Rob. I have, but I may not be smart enough about this. The number of pages is totally dynamic. It is an invoice with N number of products with N number of lines of description per each. I tried using the page number that is evaluated at the report run time, but that isn't working as a print when condition. I thought something like this would be my best chance, but I couldn't quite figure it out? Mike, Have you looked into the print when conditions for the band properties of the footer? If you were to know the max number of pages that were to be generated for the invoice you could pass that as a var to the report and then just do a print when condition on the calc.pagenumber function so that it equalled whatever the max number of pages were going to be. That is where I would start anyways. Rob On Thu, Jul 10, 2008 at 7:13 PM, Dave Watts [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308985 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Report Builder Question
That is interesting. I do not have experience with the CFPDF tag, just the report builder. In combining the signature page, is it smart enough to put it at the bottom of the page, and only a new page if there is not enough room? No, you can only add a new page. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308986 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Report Builder Question
Mike, So how is it passed to the report? Through a Query? Does each product (item per invoice) have a set number of lines, or does each product take a single line. If it does, then you could just write a function in the report that took the number of items passed and divide by the number of items per page and then you can figure out the total number of pages. Again, not sure how the report is being hooked into the database, but I am sure that there will be someway to get consistent footer into it. Rob On Sun, Jul 13, 2008 at 12:04 PM, Mike Greider [EMAIL PROTECTED] wrote: Hi Rob. I have, but I may not be smart enough about this. The number of pages is totally dynamic. It is an invoice with N number of products with N number of lines of description per each. I tried using the page number that is evaluated at the report run time, but that isn't working as a print when condition. I thought something like this would be my best chance, but I couldn't quite figure it out? Mike, Have you looked into the print when conditions for the band properties of the footer? If you were to know the max number of pages that were to be generated for the invoice you could pass that as a var to the report and then just do a print when condition on the calc.pagenumber function so that it equalled whatever the max number of pages were going to be. That is where I would start anyways. Rob On Thu, Jul 10, 2008 at 7:13 PM, Dave Watts [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308990 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Report Builder Question
Mike, Have you looked into the print when conditions for the band properties of the footer? If you were to know the max number of pages that were to be generated for the invoice you could pass that as a var to the report and then just do a print when condition on the calc.pagenumber function so that it equalled whatever the max number of pages were going to be. That is where I would start anyways. Rob On Thu, Jul 10, 2008 at 7:13 PM, Dave Watts [EMAIL PROTECTED] wrote: Does anyone know how to either (a) get a page footer to only print on the last page, or (b) to make sure that the report footer is always aligned on the bottom of the page? Basically, I have an invoice that can be anywhere from 1 to n pages. On the last page, there is a spot to sign the invoice. The client wants to make sure this is at the bottom of the last page, but for the life of me, I can't figure out how to do this! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308930 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Report Builder Question
Does anyone know how to either (a) get a page footer to only print on the last page, or (b) to make sure that the report footer is always aligned on the bottom of the page? Basically, I have an invoice that can be anywhere from 1 to n pages. On the last page, there is a spot to sign the invoice. The client wants to make sure this is at the bottom of the last page, but for the life of me, I can't figure out how to do this! I'm not aware of any way to do this from within the report builder, but you can take the generated PDF report and use the CFPDF tag to assemble a new PDF from your report and a separate signature page. This is covered in the Adobe Advanced ColdFusion 8 course. I can provide a code sample when I return to my office, if necessary. If you do this, though, the signature page will be the last page; it won't be appended to the last page of your report. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308914 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
