Convert SSRS report use new database SQL Server Report Builder
$30-100 USD
In Progress
Posted about 13 years ago
$30-100 USD
Paid on delivery
We have a few SSRS reports that have to be converted to use a new single database. Prior, we are using 2 or more databases. THis project is for one conversion but there could be a few more on the next project.
You have to convert the stored proc here: <[login to view URL]>
the output fields can stay the same and should run ok in the program so you just have to map the columns in the SQL from the old tables to the new ones. SOme cases there are itemid that is new but it matches to an items mapping table.
You may need to tweak the above SQL to only produce the 5 highest totals. as it has been some time since we have looked at this.
a shot of the SSRS are code is here: <[login to view URL]>
it is not too long code. behind the expression are some code as this:
=FormatNumber(IIF(IsNothing(Sum(Fields![login to view URL])), 0, Sum(Fields![login to view URL])),0)