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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics