Geek asks and answers

Best way to calculate a column in a DB or SSRS

When we have some calculated column in the database for reports, what is the best way to calculate its value in case of developing an SSRS report.

  • Calculate it in SSRS tablix
  • Calculate it from the database and return it as a data set

If I repeat this question, then I'm sorry for this, but I did not have the correct answer during the search.

+3
source share
1 answer

In principle, it depends.

  • If the computed value is fairly static, this helps to preserve the computed column.
  • If the calculated value is useful in several reports, then this supports the calculated column.
  • SQL ,
  • db OLTP, tablix.
  • . .

, , , , .

+5

More articles:


All Articles