New answers tagged ssrs
This is a simple backup and restore process, with the additional step of making sure you backup the Reporting Services key, so you can restore that as well. A number of links on the internet, but this one is a step by step guide with screenshots, much easier than trying to follow MSDN ...
Report Server Database can be backedup and migrated over to the new server in the new network which shouldn't be a trouble. Only problem I see is the Report Server URL, which is not mostly same as before. But, you should still have the same data as before after migration, but, with a different URL after migration.
Can you do the calculations in the dataset the report uses? May have an easier time doing that then building the expression needed to calculate the column for SSRS
Try casting it to type double, like this: =SUM(CDbl(Fields!YourField_f.Value))
I'm going to guess that you are running SSRS in Native mode rather than SharePoint integrated, and that you are using the pre-defined roles to grant access to users. If you want to post more information about the version of SQL Server you are using and the security role these users are in, I can update my answer. For now, try this. There are pre-defined ...
Top 50 recent answers are included