How to use reporting engine features effiectvely

[kiranp507]

Hi i have developed stored procedure and able to generate SSRS report for the same. i have two questions here 1)i am getting data from the sql server and i need to do lot of caluclations based on some conditions,so I would like to know how to implement the code without using stored procedures 2)How to use reporting engine features effiectvely Regards, Kiran

[Mycroft Holmes]

I would have thought you would be better to do the calcs in the stored proc, thats generally what it is there for. We do almost no work at the report layer unless it involves report elements (layout and sum totally etc). While the report layer has functions etc I don't think you should be doing "a lot of calculations" using them. As for you second question, what features, what engine?

Never underestimate the power of human stupidity RAH