- November 19, 2012 at 11:47 am #1503
Is there a way that source data for Reporting can be taken from two different forms i.e. like a Join. At the moment you can only select one form as the source of your reporting data but we have two forms which have similar data and we’d like to consilidate them into one report. I cant see how this can be done but thought I’d ask.
thanksNovember 19, 2012 at 4:13 pm #6325
Each reporting object can only have one source. A page in a report can have more than one data source but the problem with doing that is that the objects reporting on the second (or third, etc…) source cannot respect the dynamic filter input from the first. The report would only be partially dynamic and therefore very confusing for the user.August 20, 2013 at 11:02 am #6686
I have a question regarding data source for report.
How should I design a report which will allow me to display some dynamic information from another system (such as PeopleSoft) along with Perfectforms data? I am sorry if the question is not clear. Thanks.August 20, 2013 at 11:05 am #6688
The PerfectForms reporting tool will only report on form instance data. If you want to report on data from an outside data source you need to create a connection and create instances with that data. Then report on those new instances.August 20, 2013 at 1:21 pm #6689
Thanks. What we need to do is to see if is possible to report on Peoplesoft (student registration) data, which has already been incorporated into the form instances. However when the form instance is submitted, the PS data on the form becomes static – it is a snapshot of the registration data at that moment, and if the student drops certain classes or adds some other classes, we don’t have a way to capture and display those changes from Perfectforms reoprt. Would you suggest something like helper form, or any other mechanism for this (ex. use Web Services instead of database connection…?). I am hoping there is a way to handle this, which would be very good for system integration. Thanks.August 20, 2013 at 1:27 pm #6691
The PerfectForms reporting tool will only report on form instance data. To do what you are describing you would have to either create a new set of instances or open every existing instance, refresh the data with a connection and submit before each time you use the report. I do not have a practical solution for you.
You must be logged in to reply to this topic.