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: <[url removed, login to view]>
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: <[url removed, login to view]>
it is not too long code. behind the expression are some code as this:
=FormatNumber(IIF(IsNothing(Sum(Fields![url removed, login to view])), 0, Sum(Fields![url removed, login to view])),0)