This topic contains 7 replies, has 0 voices, and was last updated by Anonymous 9 years, 6 months ago.
- AuthorPosts
- November 29, 2010 at 6:21 pm #635
AnonymousIs 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 #5524A reporting object can only report on one data source.
November 30, 2010 at 4:30 pm #5525
AnonymousThanks for the response.
Is this something that could be considered for a future enhancement?
November 30, 2010 at 5:07 pm #5528The 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
AnonymousI 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 #5840Finding 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 #5843As 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.
September 2, 2011 at 5:30 pm #5844Without 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.
- AuthorPosts
You must be logged in to reply to this topic.