Can I create reports in a table similar to the reports in another table?
Yes, you can if the columns in these tables are identical. i.e., Table 1 and Table 2 share same column design and structure. And a set of Reports were created over Table1. Now you can duplicate these reports over Table 2.
The following steps to create reports in Table2 similar to that of reports over Table1:
- Make sure the column names and types in the Table1 and Table2 are identical.
- Open the 'Table2' and click New > Similar to Another Table.
- In the Select Table for Report Generation dialog, choose your reference table in Select reference table option.
- Select the folder to save the new reports.
- You can also choose to copy Custom Formula and Aggregate Formula from Table 1.
- Click OK. This will generate similar reports and query tables over the 'Table2' as they are in 'Table1'.
Read the below link to know more about 'Similar to another table'.