Reports Dataset are not visible

[sayan-ghosh]

Hello Team,

Recently I have moved the Reports from one Instance to Another through XML

All the Reports are visible but the Datasets are not visible, Dataset of the Reports are Not Capturing.
I have Tried to Move the Through Update Sets as well, But still not visible in the Target Instance.

Screenshots below:
Source:
=====

Target
=====

Best Regards

[Robert H · Accepted solution]

Hello @sayan-ghosh ,

Please go to the "sys_report_layer" table and filter by "Report = {your reports}".

Then export those records to XML and import them into the target instance.

Regards,

Robert

[sayan-ghosh]

Hello Robert,

Thanks Mate it works.
The Best Approach to Move the Report will be through XML?
1. sys_report table
2. sys_report_layer

Best Regards,

[Robert H · Accepted solution]

Hello @sayan-ghosh ,

By default both the Report and its Report Layer configuration is getting captured in Update Sets.

So that would be the recommended approach and using XML would only be the workaround.

If your Report Layers are not captured in Update Sets then the "update_synch" attribute for that table might not be enabled.

Regards,

Robert

[sayan-ghosh]

I can see It is Enabled

[Robert H]

Hello @sayan-ghosh ,

In that case I would recommend that you open a case on Now Support for ServiceNow technical support to check why the system ignores that attribute.

Regards,

Robert