Skip to main content

How to Rename a SSRS Report Project Solution

How to Rename a SSRS Report Project Solution:

As a developer many times we come across scenarios where we have created a Report Project solution with a specific name e.g. "Reports_Dev".
after some time say when the development is complete, we might think to rename the same Project solution to "Reports_Production"
Let’s see how to do it...

Solution:

1.       Create a copy of the SSRS Project Solution
2.       Now find the following items:
Solution Folder Name: Reports_Development
Files in this Folder:
                Reports_Development.sln (this a .sln file)
                Reports_Development.suo (this is a hidden .suo file)
                Reports_Development (this is a folder)

               

                                Files in this Folder:
Reports_Development.rptproj.user
Reports_Development.rptproj


3.       Rename these files and folder with the new name:

Solution Folder Name: Reports_Production
Files in this Folder:
                Reports_Production.sln (this a .sln file)
                Reports_Production.suo (this is a hidden .suo file)
                Reports_Production (this is a folder)
               

                                Files in this Folder:
Reports_Production.rptproj.user
Reports_Production.rptproj

4.       After Renaming the objects open the “Reports_Production.sln”. it will display the following error message:


5.       Click on “Ok” button and It will display the following things in the Solution Explore”


6.       Select the Reports_Development and go to the Properties. Click on the button in the for the File path, it will open the folder where the Report Project file is  store open the folder and select the file(Reports_Production.rptproj) and click open.



7.       Now again go to the solution explorer and right click and Click Reload Project.


8.       It will reload the Project into the solution which we just renamed

9.       That’s it!
 ---------------------------------------------------------------------------------------------------------------
There are other alternative of Renaming the Project Solution following is one more:

1.       Open the Business development Studio:


2.       Create a New report Project:

3.       It will create an empty Report Solution:


4.       Right Click on the Report Project and select “Add-> Existing Item.”

5.       Locate the all the files in the Reports_Dev Project folder (i.e. all the RDL files and data and connection files etc.)


6.       Select All the Report and Connection and shared dataset files and Click “Add”. It will add all the reports and the share dataset and shared data source files in the new solution

               
7.       That’s it!

Comments

  1. Thanks for this, it's so very helpful and I need to refer to it all the time. :)

    ReplyDelete
  2. Great post, thank you !!

    ReplyDelete
  3. Really saved my day!

    ReplyDelete
  4. Saved my day too, great post! Greetings from Spain!

    ReplyDelete

Post a Comment

Popular posts from this blog

SSRS Reports - Space/Gap issue between the objects in SSRS Reports

In Reports where some objects are set to be shown/hide based on some expression/filter condition etc. There Could be some white space issue between the objects on the report( i.e. when few objects are hidden in the report, the white space between the objects will accumulate and displayed as a big gap between the objects on the report). Following are few ways using which we can handle this kind of issue: 1. Remove the Gap between the objects in the report layout. 2. Or put a text box and make the border the same as the background color and apply the same show/hide action on it. 3. If you are using a table/matrix then instead of putting the space between objects, just add one static row above the column header for the table/matrix and make the border color the same background color. below is one approach: The report before any space handling: -----------------------------------------------------------------------------  Report Preview when all the o...

How to do Error Handling for Transaction using Try Catch Block

Issue : Some time we get requirements where we have to use transaction to do some DML operations to make sure the unit of work should be done completely. But there could be error while doing this. So, how we can cope up with errors to achieving this? Solution: We can use Transaction in the Try Catch block to make sure that the transaction either successful or rollback if there is any error. Below is an example for this: BEGIN TRY --Start the Try Block.. BEGIN TRANSACTION -- Start the transaction.. UPDATE [dbo] . [Table] SET salary = salary * 1.1 WHERE MID = 6 --DML operations to be done in the transaction COMMIT TRAN -- Transaction Success! END TRY --End of the Try Block BEGIN CATCH --Start the Catch Block IF @@TRANCOUNT > 0 --check the error count for the errors ROLLBACK TRAN --RollBack in case of Error --to raise the error message when there is an issue. Declare the variables and se the values for them DECLARE @Er...

SSRS Reports - When few objects are hidden in the report, the white space between the objects will accumulate and displayed as a big gap between the objects on the report

In Reports where some objects are set to be shown/hide based on some expression/filter condition etc. There Could be some white space issue between the objects on the report( i.e. when few objects are hidden in the report, the white space between the objects will accumulate and displayed as a big gap between the objects on the report). Following are few ways using which we can handle this kind of issue: 1. Remove the Gap between the objects in the report layout. 2. Or put a text box and make the border the same as the background color and apply the same show/hide action on it. 3. If you are using a table/matrix then instead of putting the space between objects, just add one static row above the column header for the table/matrix and make the border color the same background color. below is one approach: The report before any space handling: -----------------------------------------------------------------------------  Report Preview when all the obj...