sql server reporting services: Expression ERROR -- sql server reporting services

Expression ERROR

pmud
3/14/2005 1:09:02 PM

sql server reporting services:

Hi,

In my matrix in the report, I need to add a column group which groups the
columns based on months. But i dont have a field in the database for month.
I have a field called Order_Date. Now I need to see all the orders for each
month. So in the column group expression i used :
Fields!(Month(Order_Date.Value)) but i got the following error ::
The group expression expression for the matrix â€˜matrix1â€™ contains an error:
[BC30277] Type character '!' does not match declared data type
'Microsoft.ReportingServices.ReportProcessing.ReportObjectModel.Fields'.

What will be the correct expression for this?
--

Re: Expression ERROR

pmud
3/14/2005 2:27:03 PM

Hi Jordi,

Thanks . That helps. But is how do I use use MONTH NAME to display as column
group? Select ..., Month(Order_Date) as month displays the month
numbers(1,2,3...) & not name. I want Jan , feb to dispaly rather than 1,
2,3.... Is there some way of doing this?

Thanks

[quoted text, click to view]

Re: Expression ERROR

pmud
3/14/2005 4:13:01 PM

Hi,

Thanks for the answer...That helped. For the Month Name , I did
Left(DateName(month, getdate()),3) which gets the first 3 letters of the
month..

Thanks for ur help.:))

[quoted text, click to view]

Re: Expression ERROR

Robert Bruckner [MSFT]
3/14/2005 5:16:46 PM

Try this:
=Month(Fields!Order_Date.Value)

-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Re: Expression ERROR

Jordi Rambla
3/14/2005 10:57:45 PM

Hi pmud

You can do that on SQL itself if you're source can handle it.
It is like

Select ..., Month(Order_Date) as month

And you can use it on your Where clause

Where month(order_date) = 1

Hope this helps

Jordi Rambla
SolidQualityLearning.com

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.