Report Builder Query
Hi all
I am trying to create an expression in report builder 3.0 based on a table in sql called orders
I have these columns that i need in the table
Order Date
Value
what i would like to do in the expression is return all orders with the current month and current year, and then total the value for these values.
Is this possible in Report Builder?
Could anybody guide me.
Thanks
John
April 19th, 2011 7:05am
Hi,
You do not to use expression.
What you can do is create group over CSTR(Month(Fields!OrderDate.Value)) + CSTR(Year(Fields!OrderDate.Value)) value and then add total for this group.
Kindly revert if this not the solution you wanted.- Chintak (My Blog)
Free Windows Admin Tool Kit Click here and download it now
April 19th, 2011 8:22am
Are there any examples availiable for creating groups in Report Builder?
im still pretty new to it
April 19th, 2011 8:55am
Hi,
I think you can have a look at SSRS sample reports
http://msftrsprodsamples.codeplex.com/
And then there are some sample reports for RB 3.0
http://msftrsprodsamples.codeplex.com/wikipage?title=SS2008R2!Report%20Builder%203.0%20Stand-alone%20Report%20Samples
Hope this helps.- Chintak (My Blog)
Free Windows Admin Tool Kit Click here and download it now
April 20th, 2011 2:22am
Thanks for the advice
I have also just found out when selecting sql as a datasource you can submit a sql query there.
Thanks
John
April 20th, 2011 10:10am