[web2py] Re: How to Generate the effective report by using web2py

2012-02-15 Thread Alan Etkin
> 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

2012-02-15 Thread Mariano Reingart
On Wed, Feb 15, 2012 at 11:20 AM, Alan Etkin  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

2012-02-15 Thread Sanjeet Kumar
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

2012-02-15 Thread Mariano Reingart
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  wrote:
> 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

2012-02-16 Thread Ross Peoples
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

2012-02-16 Thread Sanjeet Kumar
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 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

2012-02-16 Thread Mariano Reingart
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  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

2012-02-16 Thread Sanjeet Kumar
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 wrote:

> 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 
> 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

2012-02-16 Thread Ramkrishan Bhatt
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


Re: [web2py] Re: How to Generate the effective report by using web2py

2012-02-17 Thread Ross Peoples
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

2012-02-17 Thread Sanjeet Kumar
Thanks Ross

On Fri, Feb 17, 2012 at 6:23 PM, Ross Peoples wrote:

> Sanjeet.
>
> I sent some code to Mariano last night. So we will have to wait and see if
> it works for him.
>