Generating Data into PDF using Query Template

[Former Member]

Hi,

This is prasad.I want to generate the data which i have obtained using querytemplate into pdf format.Can any one have idea on generating pdf using query template will be helpful.

Thanks,

Prasad.

[agentry_src]

Ram,

Build a table in your pdf document and place the query contents in it. You will need to develop a Business Logic Services transaction and save your pdf document.

Regards,

Mike

Edited by: Michael Appleby on Jan 9, 2009 2:25 PM

[Former Member]

Hi Mike,

Thanks for Your reply.Here are steps followed to generate the pdf document

Sql Query --> Pdf Document --> Pdf Table --> Image saver

what we are looking for is

From the query we get products and its subproducts with prices. For each Product, it has to be a group table, like Product Name is a title, then display all the sub products and prices, then show the Product group totals.

Thanks,

Prasad.

[former_member192939]

Prasad,

Use the Crosstab action block.

And use the PDF action blocks.

This should generate the output as desired.

Regards,

Ajay.

Edited by: Ajay Malempati on Jan 9, 2009 12:30 PM

Edited by: Ajay Malempati on Jan 9, 2009 12:31 PM

[Former Member]

Thanks Ajay,

can we generate pdf document using the excel sheet data

[former_member192939]

Yes you can,

Use the CSV loader, File Parser, StringList to XML and PDF action blocks.

Regards,

Ajay.

[jcgood25]

Using Excel as a source document is never really a good idea....