Report need to show sum of all individual reports, which are created on different applications.

[Sandeep Kumar13]

Hi Community,

I have created 5 reports on different different tables for different applications.

Eg: Report ABC created on ABC table for ABC application.
      Report DEF created on DEF table for DEF application.

      Report GHI created on GHI table for GHI application.

Now i need to Create 1 master report, based upon these reports.it need to show sum of all these reports.

How to achieve this?

Thanks in advance.

[AndersBGS]

Hi @Sandeep Kumar13 ,

Your query is not possible. It's not possible to create a report based on report. The report designer only take a a table / database view into consideration. So to obtain something useable based on which table you refer to when mention ABC, DEF, GHI, you may can create a database view to consolidate the three tables.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Raghu Ram Y · Accepted solution]

Hello @Sandeep Kumar13 

I would suggest to gohead with the Performance analytics, in which you can use the concept of automated indicators and formula indicators,

Using automated indicator you can get the count of individual reports and by using formula indicator you can concatnate the count and user's list on the report..

Ex: 5 individual widgets and 6th one is total one..

Please mark my answer as both HELPFUL and CORRECT, if it helps