Tuesday, February 14, 2012

Calculating on Reporting Services

I don't know if it is possible to do a calculation for reporting services in the application instead of on the stored procedure.

Because I feel that it is would be easier to calculate inside the application by passing some fields instead of do multiple join and check inside the stored procedure.

Any comment would be greatly appreciate.

You can use a vbscript function. Go to Report->Report Properties->Code tab.

Create a calculate function there passing in some parameters. I think you can even connect back to the database in that code. There is even a way to include a code reference so you can call an existing application.

No comments:

Post a Comment