Re: Report Builder Question

2008-10-31 Thread Mike Greider
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

Re: Report Builder Question

2008-07-25 Thread Mike Greider
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 previou

Re: Report Builder Question

2008-07-22 Thread Carlos Juarez
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

Re: Report Builder Question

2008-07-22 Thread Carlos Juarez
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

Re: Report Builder Question

2008-07-20 Thread Mike Greider
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 te

Re: Report Builder Question

2008-07-18 Thread Carlos Juarez
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

Re: Report Builder Question

2008-07-18 Thread Mike Greider
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

Re: Report Builder Question

2008-07-16 Thread Rob Parkhill
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: Report Builder Question

2008-07-16 Thread Mike Greider
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 w

Re: Report Builder Question

2008-07-16 Thread Rob Parkhill
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

Re: Report Builder Question

2008-07-16 Thread Mike Greider
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

Re: Report Builder Question

2008-07-13 Thread Rob Parkhill
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 ite

RE: Report Builder Question

2008-07-13 Thread Dave Watts
> 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 Lea

Re: Report Builder Question

2008-07-13 Thread denstar
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 sepa

Re: Report Builder Question

2008-07-13 Thread Mike Greider
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 w

Re: Report Builder Question

2008-07-13 Thread Mike Greider
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 on

Re: Report Builder Question

2008-07-11 Thread Rob Parkhill
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 t

RE: Report Builder Question

2008-07-10 Thread Dave Watts
> 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