We’d like to use the results form different GIs for one report, is this possible? How?
Solved
Can the results of multiple different GIs be joined for a datasource of a report?
Best answer by ChandraM
Note: This solution proposed here could be useful for a developer.
In such cases, the developers can also use SQL Views to combine the tables, Create a DAC for the SQL view (with proper CompanyID as a field in the SQL View, and by using IsKey =True defined on the key fields), and then create the Generic Inquiry. The newly created DAC will be available to create GI.
1 person likes this
+11Hi
Could you tell us more about the tables/content of the two GIs you want to join and the business requirement?
Thanks
Note: This solution proposed here could be useful for a developer.
In such cases, the developers can also use SQL Views to combine the tables, Create a DAC for the SQL view (with proper CompanyID as a field in the SQL View, and by using IsKey =True defined on the key fields), and then create the Generic Inquiry. The newly created DAC will be available to create GI.
+8Hi
Depending on the business requirements for the report, another option may be to use subreports.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.