Sorry "Old Hand"

But this just messes things up, you may need to explain a little more in-depth, if you don,t mind

The data type is datetime, and this is the full copy of the cold:

SELECTCONVERT(varchar(11), T_OrderHeader.OrderDate, 106) AS [Order Date], T_OrderHeader.OrderID, T_OrderHeader.CustomerID, T_OrderHeader.ShipTitle,

T_OrderHeader.ShipForename, T_OrderHeader.ShipSurname, T_OrderHeader.OrderTotal,

T_OrderHeader.OrderStatusID, T_Customers.ExpiryDate

FROMT_OrderHeader INNER JOIN ...

Thanks Hari

Somehow it didnt return any records, but I used the following code:

WHERET_OrderHeader.OrderDate >= DATEADD(day, DATEDIFF(day, 0, DATEADD(day, -7,

GETDATE())), 0)

AND T_OrderHeader.OrderDate < DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0)

it returned records, but...

Hello

To be able to have a group total, you will need to select the table area of your report, right click on the group that needs to have a...

Hi All

In case you come across this topic, I have found a solution which was pretty straight forward

You can also have a look at the following link:

http://msdn.microsoft.com/en-us/library/aa337401.aspx

Cheers

Hi All

In case you come across this topic, I have found a solution which was pretty straight forward :ermm:

You can also have a look at the following link:

http://msdn.microsoft.com/en-us/library/aa337401.aspx

Cheers

:w00t: I meant Ryan!!

Ralph

Your a life saver thanks very much!!!

Hi All

I used the query this way and i got an error message saying incorrect syntax near Price on line 4, can anyone help?

SELECT ParentProductClassID , CatalogueID,...

Thanks Nigel, your explanation made A LOT of sense. Am creating a report model for a department to pull reports from where end users can use the report model to...

I have another problem with the order by syntax, in my query the order date is in DESC order, but when i preview it in SSRS, it appears the in...

Thanks Hari

You saved my day, better to have it done this way than using all that CAST and CONVERT syntax in the query

It may sound a bit naive, but where is the ReportItem?

The query actually adds the the £ symbol in front of the figures, and the data type format of the column is money

Fixed!!!!!!!!!!

I forgot to set the correct parameter value:blush: