Microsoft Dynamics 365 | Integration, Dataverse...

Move SSRS report categories from environment to another

(0) Share

Report

Posted on by EBMRay

905

Hello,

I have SSRS reports that have different categories and I was able to find a way to add new categories options as per the below blog post:

Dynamics 365: Organize Reports with Custom Report Categories and Views - The Marks Group | Small Business Consulting | CRM Consultancy

I was trying to create a view for each category, however, my main concern is if I want to move the reports to a different environment how can i migrate the same categories that was added on the development environment?'

Additionally, I found a way to create a view filtered by report related entity as follows:

But couldn't find the related entity I am integrating with to filter it up and also it is not possible to add a relationship with the entity.

What is the easiest way to accomplish the above requirements?

Any help is greatly appreciated.

Best regards,
EBMRay

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Amit Katariya007 10,409 Moderator on at

Like (1)

Report
Copy link

Link copied!

Can u check once if have report category table on dev environment? And let me now what are the records in it.

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,983 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

Report category table records need to be exported from dev and imported to your target instance

learn.microsoft.com/.../reportcategory

You can export excel and convert that into CSV to import to target instance

Configuration migration tool can also be used to migrate these records

Was this reply helpful? Yes No
EBMRay 905 on at

Like (0)

Report
Copy link

Link copied!

Hello Amit Katariya007

The table exists on the dev environment as I found it on FetchXML builder and not from the tables in powerapps.

Thank you.

Was this reply helpful? Yes No
EBMRay 905 on at

Like (0)

Report
Copy link

Link copied!

Hello Bipin Kumar ,

I found the table in the fetch XML builder as follows:

Basically, I need to migrate the category options.

In the configuration migration tool, I was not able to find this table to include in the Master data.

What would be an alternative to including it in the configuration migration tool?

Your help is greatly appreciated.

Best regards,
EBMRay

Was this reply helpful? Yes No
EBMRay 905 on at

Like (0)

Report
Copy link

Link copied!

Hello Bipin Kumar ,

Have you had the change to check my last reply?

Best regards,
EBMRay

Was this reply helpful? Yes No
Suggested answer

Amit Katariya007 10,409 Moderator on at

Like (0)

Report
Copy link

Link copied!

As Bipin suggested, Export the table and upload it on the destination environment.

Was this reply helpful? Yes No
EBMRay 905 on at

Like (0)

Report
Copy link

Link copied!

Hello Amit Katariya007 ,

The category is a picklist, not a table, so I used Option Set editor on xrmtoolbox and I was able to add the options I want.

Best regards,
EBMRay

Was this reply helpful? Yes No
Suggested answer

Amit Katariya007 10,409 Moderator on at

Like (1)

Report
Copy link

Link copied!

does it worked for the respective option?

Was this reply helpful? Yes No
EBMRay 905 on at

Like (0)

Report
Copy link

Link copied!

Yes it worked by amending changes to the picklist option and not by exporting table to do the import.

Was this reply helpful? Yes No