Re: [web2py] Re: How to Generate the effective report by using web2py
Sanjeet. I sent some code to Mariano last night. So we will have to wait and see if it works for him.
Re: [web2py] Re: How to Generate the effective report by using web2py
Thanks Ross On Fri, Feb 17, 2012 at 6:23 PM, Ross Peoples ross.peop...@gmail.comwrote: Sanjeet. I sent some code to Mariano last night. So we will have to wait and see if it works for him.
Re: [web2py] Re: How to Generate the effective report by using web2py
I had to write a lot of code to get FPDF to do proper headers, footers, and page numbers. Then about another 100 lines of code to get it to wrap long lines of text inside of a table. I'm also not using HTML to PDF conversion. I am using FPDF's methods to create PDFs. If I recall correctly, I tried to use paragraphs and even new line characters to force the line to break, but ended up having to use absolute positioning for the lines. It sounds terrible, I know, but I have been using this successfully for a little while. I basically wrote a module that takes a query (just like SQLFORM.grid) and generates a PDF with headers, footers, a logo, and can even group data into multiple tables, all while wrapping long text and repeating column headers on each new page. It was a lot of work, but the reports look pretty good. Mariano, what about FPDF are you planning on updating? And are you planning to break backwards-compatibility?
Re: [web2py] Re: How to Generate the effective report by using web2py
Ross Can you send me the CODE for that thanks in advance because i want to generate the report properly through FPDF. On Thu, Feb 16, 2012 at 6:31 PM, Ross Peoples ross.peop...@gmail.comwrote: I had to write a lot of code to get FPDF to do proper headers, footers, and page numbers. Then about another 100 lines of code to get it to wrap long lines of text inside of a table. I'm also not using HTML to PDF conversion. I am using FPDF's methods to create PDFs. If I recall correctly, I tried to use paragraphs and even new line characters to force the line to break, but ended up having to use absolute positioning for the lines. It sounds terrible, I know, but I have been using this successfully for a little while. I basically wrote a module that takes a query (just like SQLFORM.grid) and generates a PDF with headers, footers, a logo, and can even group data into multiple tables, all while wrapping long text and repeating column headers on each new page. It was a lot of work, but the reports look pretty good. Mariano, what about FPDF are you planning on updating? And are you planning to break backwards-compatibility?
Re: [web2py] Re: How to Generate the effective report by using web2py
Ross: I'm planning a unicode patch and a better support to html rendering using web2py helpers They will not break compatibility. If you want, you can sent me your changes, I could add it somewhere or using as a base of a new reporting functions. It would be great if you can fill an issue: http://code.google.com/p/pyfpdf/ BTW, if you want, I can give you commit access. Best regards Mariano Reingart http://www.sistemasagiles.com.ar http://reingart.blogspot.com On Thu, Feb 16, 2012 at 10:01 AM, Ross Peoples ross.peop...@gmail.com wrote: I had to write a lot of code to get FPDF to do proper headers, footers, and page numbers. Then about another 100 lines of code to get it to wrap long lines of text inside of a table. I'm also not using HTML to PDF conversion. I am using FPDF's methods to create PDFs. If I recall correctly, I tried to use paragraphs and even new line characters to force the line to break, but ended up having to use absolute positioning for the lines. It sounds terrible, I know, but I have been using this successfully for a little while. I basically wrote a module that takes a query (just like SQLFORM.grid) and generates a PDF with headers, footers, a logo, and can even group data into multiple tables, all while wrapping long text and repeating column headers on each new page. It was a lot of work, but the reports look pretty good. Mariano, what about FPDF are you planning on updating? And are you planning to break backwards-compatibility?
Re: [web2py] Re: How to Generate the effective report by using web2py
Ross i am new in web2py and python so please what are you planning put in the repository because i want to generate the report by using FPDF and i also generated the report but now in the rows i have the large text so Problems are arising on the view On Fri, Feb 17, 2012 at 12:02 AM, Mariano Reingart reing...@gmail.comwrote: Ross: I'm planning a unicode patch and a better support to html rendering using web2py helpers They will not break compatibility. If you want, you can sent me your changes, I could add it somewhere or using as a base of a new reporting functions. It would be great if you can fill an issue: http://code.google.com/p/pyfpdf/ BTW, if you want, I can give you commit access. Best regards Mariano Reingart http://www.sistemasagiles.com.ar http://reingart.blogspot.com On Thu, Feb 16, 2012 at 10:01 AM, Ross Peoples ross.peop...@gmail.com wrote: I had to write a lot of code to get FPDF to do proper headers, footers, and page numbers. Then about another 100 lines of code to get it to wrap long lines of text inside of a table. I'm also not using HTML to PDF conversion. I am using FPDF's methods to create PDFs. If I recall correctly, I tried to use paragraphs and even new line characters to force the line to break, but ended up having to use absolute positioning for the lines. It sounds terrible, I know, but I have been using this successfully for a little while. I basically wrote a module that takes a query (just like SQLFORM.grid) and generates a PDF with headers, footers, a logo, and can even group data into multiple tables, all while wrapping long text and repeating column headers on each new page. It was a lot of work, but the reports look pretty good. Mariano, what about FPDF are you planning on updating? And are you planning to break backwards-compatibility?
Re: [web2py] Re: How to Generate the effective report by using web2py
Hello Sanjeet, In your code the header and footer column is unmatched . Just care full about the Grid Structure as per Column name and data value. A part from that in refer http://www.web2py.com/book/default/chapter/10#Low-level-API-and-other-recipes http://www.geraldoreports.org/docs/tutorial-web2py.html http://code.google.com/p/pyfpdf/ I
[web2py] Re: How to Generate the effective report by using web2py
than the column is collapse with each other so please kindly help me How do they collapse? Do you see more than one column? The TFOOT element has different number of fields than the rest of the TABLE element. Perhaps that field number difference is not supported by FPDF?
Re: [web2py] Re: How to Generate the effective report by using web2py
On Wed, Feb 15, 2012 at 11:20 AM, Alan Etkin spame...@gmail.com wrote: than the column is collapse with each other so please kindly help me How do they collapse? Do you see more than one column? The TFOOT element has different number of fields than the rest of the TABLE element. Perhaps that field number difference is not supported by FPDF? Attached is an example based in your code, I don't see major issues beside that some fields just don't fit BTW, I'm planing to update FPDF to generate better reports. Best regards Mariano Reingart http://www.sistemasagiles.com.ar http://reingart.blogspot.com listing.pdf Description: Adobe PDF document
Re: [web2py] Re: How to Generate the effective report by using web2py
no Actually we have problem in the fields if we take the lage data from database than it is creating the problem
Re: [web2py] Re: How to Generate the effective report by using web2py
If I understand you correctly, you'll have to trim large field to fit in the columns. Having multi-line fields is very tricky right now, this is a feature I'll work on. Best regards, Mariano Reingart http://www.sistemasagiles.com.ar http://reingart.blogspot.com On Thu, Feb 16, 2012 at 12:24 AM, Sanjeet Kumar sanjeet@gmail.com wrote: no Actually we have problem in the fields if we take the lage data from database than it is creating the problem
