engg.pankaj (1/3/2013)
Thanks for the reply again.I know how to write SUM() and group by queries in T-SQL however, I want to know how to write this query and show the result in that particular column.
If i right click on a column on the report, where do I write the query in it so that we can display the result of the query in that column.
I am new to SSRS and need guidance.
You put your query in the Dataset area of the report. First, make sure you have a data source that points to your database. Then create a new dataset (right click on Datasets and choose Add Dataset if you're creating your report in Report Builder -- it's similar in VS as well). From here you can either go to the query designer, or just past in your query into the text window.
Now in your tablix, make sure it's connected to that dataset (in the tablix properties, Dataset name). And then you can select the fields from your dataset for the columns of your report table.
HTH,
Rob