Hi I sometimes use "Calculated Field" in my reports but I often wondered what a "Query Field" is and how that is used. Any direction to good tutorials is also appreciated. This feature looks very interesting and I would love to learn to use if someone could please put me in the right direction. Thanks

Hi, Check this Blog you will get better idea:- http://blog.hoegaerden.be/2011/03/07/cascading-calculated-fields-ssrs/ Please let us know your feedback. Thanks KumarKG, MCTS

Hi, Check this Blog you will get better idea:- http://blog.hoegaerden.be/2011/03/07/cascading-calculated-fields-ssrs/ Please let us know your feedback. Thanks KumarKG, MCTS

If you use calculated field, the loigc(expression) will be calculated by SSRS and if you use Query field, the calculation logic(expression) will be performed by the database engine. Hope that helps.

If you use calculated field, the loigc(expression) will be calculated by SSRS and if you use Query field, the calculation logic(expression) will be performed by the database engine. Hope that helps.

Thanks. So that means I can really use any one of the field types 1) in exactly the same ways (so there is no difference in the way that they are used) and 2) they should both return me the same result What are the factors that I should consider in deciding whcih type to go for?

Thanks. So that means I can really use any one of the field types 1) in exactly the same ways (so there is no difference in the way that they are used) and 2) they should both return me the same result What are the factors that I should consider in deciding whcih type to go for?

Hi, Check this Blog you will get better idea:- http://blog.hoegaerden.be/2011/03/07/cascading-calculated-fields-ssrs/ Please let us know your feedback. Thanks Kumar KG, MCTS Sorry but this blog dos not disucss anythign about query field. how is this relevant to what I have asked ???

Hi, Check this Blog you will get better idea:- http://blog.hoegaerden.be/2011/03/07/cascading-calculated-fields-ssrs/ Please let us know your feedback. Thanks Kumar KG, MCTS Sorry but this blog dos not disucss anythign about query field. how is this relevant to what I have asked ???

Thanks. So that means I can really use any one of the field types 1) in exactly the same ways (so there is no difference in the way that they are used) and 2) they should both return me the same result What are the factors that I should consider in deciding whcih type to go for? Glad to be helpful. 1) There is no difference from an end user perspective, but the syntax of the expression logic you used will be different in calculated field and query field. 2) Yes, as long as the logic is right. Go with the one you are comfortable with. If you know the database engine syntax(for example T-SQL), use query field. Generally speaking, processing will be faster when performed by the database engine, so I recommend that you try to do all the calculations on the database side. Hope that helps.

Thanks again I think I now understand. If you could please provide an example of a query field using T-Sql that would be brilliant and help me grasp the syntax. I was thinking you can only perform mathematical calculatioins like sum, avg etc. and not CRUD operations, or is there a way to execute any TSQL command? Please let me know. Thanks