Home> Reporting > Reporting – Multiple Forms into One Table

Reporting – Multiple Forms into One Table

Add a topic

Tagged: Multiple, report, Table

This topic contains 7 replies, has 0 voices, and was last updated by Anonymous 8 years, 1 month ago.

Viewing 8 posts - 1 through 8 (of 8 total)

Author
Posts
November 29, 2010 at 6:21 pm #635

Anonymous
Is there a way to combine multiple data sources (with consistent data elements) into one table within a report?
November 29, 2010 at 11:04 pm #5524

Dennis @ PerfectForms
Blocked
A reporting object can only report on one data source.
November 30, 2010 at 4:30 pm #5525

Anonymous
Thanks for the response.
Is this something that could be considered for a future enhancement?
November 30, 2010 at 5:07 pm #5528

Dennis @ PerfectForms
Blocked
The reason reporting objects only report on one data source is that the reports are designed to be dynamic and respect input from other objects on the page. This would not be possible with a table reporting on two data sources. Do you have a suggestion for a solution?
November 30, 2010 at 6:36 pm #5529

Anonymous
I do not have a suggestion for a solution as I’m not sure I understand the reason why the request is impossible. If there is a grid that summarizes two data sources, why can’t a filter input object be applied to the two-source grid?
September 1, 2011 at 7:02 pm #5840

srogers
Participant
Finding a solution to allow multiple datasources apply to a single table/data grid would be a big value multiplier for us. Hopefully a method to do this can be determined!!
September 1, 2011 at 8:59 pm #5843

Dennis @ PerfectForms
Blocked
As I suggested in a recent post, you can filter multiple data sources in a report by using a form object. For example you can use a drop-down or a table and populate it using a form connection. When you choose an item from the drop-down use a set filter behavior object for each datasource on the page. Filter by the value in the form object.
Workflow software, Process software, Procedure software
September 2, 2011 at 5:30 pm #5844

srogers
Participant
Without being able to include more than one datasource in a single data grid (or form connections in a table), this will become unworkable as the number of forms to include increases.
Author
Posts