Hi, I have an application in which every row will be filled with the result of a single query, every row an other query. To start with, about 50 rows -> 50 queries.

What is the recommended way to do this? Should I follow http://theformspider.com/learningcenter/tutorial-28-how-to-export-data-to-excel-from-formspider-datasources-and-grids/ or is there a smarter way using Jasper Reports with output to excel? (if so, how to set that up, all I get is pdf)

Thanks, Ronald.

asked 04 Mar '13, 02:15

ik_zelf's gravatar image

ik_zelf
58312
accept rate: 16%


Hi Ronald,

Currently, it's not possible to use Jasper Reports with output to excel. But if these 50 rows held in a single datasource you can use api_datasource.printToExcel API as explained in the tutorial you mentioned. If these 50 rows held in multiple datasources you can create a new datasource with the same query to be used in Jasper Reports and generate excel output from this datasource.

Hope this helps,
Ibrahim

link

answered 04 Mar '13, 03:15

Ibrahim%20Sandalli's gravatar image

Ibrahim Sand... ♦♦
1.5k5
accept rate: 25%

Hi Ibrahim, I am going to aim for a single datasource with a table function that feeds it. Is there any chance for the export to excel to be integrated any time soon? (from what I understand, it is in JR so I assume it's a FS limitation)

(04 Mar '13, 05:56) ik_zelf

Hi Ronald,

It's currently a FS limitation, I guess we have to add a new servlet (as we did for PDF output) for excel export integration. I created a ticket for this issue for further investigation but it will not be available in the next release. I will keep updated this thread.

(04 Mar '13, 06:59) Ibrahim Sand... ♦♦

thanks for the clarification Ibrahim.

(04 Mar '13, 07:58) ik_zelf

Hi Ronald,

Are you looking for the best way to fill a single datasource with the result of 50 queries (one query for each row?), or is the major question how to export data to Excel?

Best, Michiel

link

answered 04 Mar '13, 04:22

Michiel%20A's gravatar image

Michiel A
5161546
accept rate: 13%

Hi Michiel, both questions I guess :-D I think that what I am going to do now is make a table with queries, make a table function that loops through those queries and tie that to a Formspider datasource to export that to excel. There report is going to be activated using an url with parameters that are to be received in the mail. It's a pity that I can not use Jasper Reports for this, would have been the easiest I think.

(04 Mar '13, 05:50) ik_zelf

Hi Ronald,

Do you use Jasper Server? If you can, this would be easy. You can run a report in Jasper server from a procedure (with a utl_http request) and capture the report output in a blob. Then the procedure can send the email with the blob content as attachment. We currently do it this way with our Apex apps.

Best, Michiel

(04 Mar '13, 06:27) Michiel A

thanks for your response Michiel, I don't want to add the extra reports server installation now so I will try with the single datasource with table function to feed it. Using JR from FS would have been my first choice.

(04 Mar '13, 08:00) ik_zelf
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×9
×5

Asked: 04 Mar '13, 02:15

Seen: 1,560 times

Last updated: 04 Mar '13, 08:00


© Copyright Gerger 2017