How to import an ssrs report using .axpp file ~ Step by Step Guide

Recently I got a scenerio, in which I was given an .axpp file which contained ssrs report that needed to be imported in to the project which I was working on.

So, here is how I did that.

You already know how to create a new model. If not, please refer to the new model creation article. I have already created a new model with name AbbasCustomModel

Go the imported model. And you must copy all the objects in this model to your model one by one.?

First I copied the classes from BBJ Model to AbbasCustomModel.

Then I copied the Report from BBJ Model to AbbasCustomModel.

Lastly I copied the Table from BBJ Model to AbbasCustomModel

After copying all the objects from BBJ model to my model, I can delete that model BBJ now as it is no longer required.

Now go to visual studio > Open Application Explorer > Type BBJ in the search bar as it will all the objects with that name > Add all those objects to your project by simply drag and drop.?

Now it’s time to create a menu extension to which we will add a menu item.

I have already created an extension of Menu Item which I added to the project.

Create a new menu item of Output type.

Set the properties of this action item. i.e. Object type, Object?and Label.

Open Menu item extension and Add menu item to the it by simply drag and drop.

Open Report Server Configuration Manager and connect to the report server.

All Sql related services specially SSRS service should be in running condition.

Last step to deploy your report to SSRS. Right Click on project > Click on Deploy Report to deploy your report on SSRS.

Set your menu item as startup object.?

Rebuild the project and run the project.

You will see below parameter screen.

Enter the parameters and click ok.??

Here is the report.?

You can also open the report by clicking the menu item.

Imp Note: ?You may need to change the Company to USRT from DAT.

If you found this article helpful, give it a thumbs up.