Question

Reporting on Forms

Forms

Updated September 27, 2018

asked on September 26, 2018

We are busy with a business critical process for our customer.
The main requirement is to do reporting on the Forms process, using a 3d party tool called click sense.
This data needs to be live data. On forms reporting, we configure the reports and it does show the information that we need, but it is in Forms.
We can export the report in import it into a SQL table. This is time consuming and is not always live data.
Question is, where can I find the SQL view (script) that Forms uses to create these reports?
We want to finalize this process and this is the hold up. Is there any other ideas that you can suggest?

0 0

Replies

replied on September 26, 2018

Hi August,

Thanks for using Forms' reporting tool. Actually all the reporting logic is done in Forms back-end, we don't have SQL scripts.

Best,

Fangzhou

0 0

replied on September 27, 2018

Hi Fangzhou

Thank you for the reply. Is there any suggestions that you can think of to get that data?

0 0

replied on September 27, 2018

You say it needs to be "live", but since Forms data only changes when a form is submitted, you could add a workflow after each user task to maintain the data in your table.

Granted, this becomes unwieldy with a large process, but it may be a more attractive option for a business critical process given the unsupported nature of scraping the data directly from the Forms database.

0 0

replied on September 27, 2018 • Show version history

Hi August,

It is a little bit tricky to get all the data that we are using for reporting. If you only need variable data, one thing we can suggest is you can grab all the variable data(formatted variables table) and do a SQL-SQL table transfer. We hope this can help :)

Best,

Fangzhou

0 0

You are not allowed to follow up in this post.

Question

Question

Reporting on Forms

Replies

Sign in to reply to this post.