One idea could be to use a function to parse your values. To get you started, check out this solution and see if it offers any inspiration: http://social.technet.microsoft.com/wiki/contents/articles/26937.t-sql-splitting-a-string-into-multiple-columns.aspx

What logic defines...

Are you getting an error message when you try to utilise your CTE?

It doesn't look like it, as all regional/language settings were identical to all other RDLs (the default!)

Okay I just deleted the item and added it into the project again (after taking a copy) and the problem seems to have gone away! :s

Would still be interested to...

Hi Mohamed,

Thankyou for the quick response!

Unfortunately this is not the case - the number appears the same whether 'Use regional formatting' is ticked or unticked. The regional setting is 'English...

What are the page break options set to when you go to tablix properties/group properties?

You may need to play around with the page layout options, if the report is simply...

Are you using the send mail task on the loop container itself? If so, you will need to attach them to the individual step(s) within the loop, as of course...

Enable the OnError event handlers for the steps in your container, then on the event handlers pane, under variables click the icon to show system variables (a grey box with...

D'oh!! That works great, thankyou!

This will work as long as the group is sorted by date, but as the report is subject to change I was hoping there would be a way to retrieve...

Thankyou for responding.

However, I need the 'Outstanding' value for the maximum date - this may not necessarily be the highest value.

So, January could have '1,000', February could have '400',...

Thanks John, speedy response and very helpful 🙂

Yes, I would usually keep them as files - and no-one here knows of a reason why I shouldn't, I've just been told...

Rename 'mytable' as appropriate:

SELECT DateDay,

STUFF((SELECT ',' + CAST(SP2.ID AS VARCHAR(10)) FROM dbo.mytable SP2

WHERE SP2.DateDay = SP1.DateDay FOR XML Path('')), 1, 1, '') ID

FROM dbo.mytable SP1

GROUP BY...

SELECT o.[Order], o.Product, o.qtyOrd, oh.[Date], P.MinQty

FROM ORDDET O

INNER JOIN ORDHEAD OH ON OH.[Order] = O.[Order]

LEFT JOIN (SELECT o.Product, MIN(o.[Order]) MinOrder

FROM ORDDET O

GROUP BY o.Product

...

There's a potential workaround here you might like to consider (option 2): http://tpuch.blogspot.co.uk/2011/02/options-for-filtering-parameter-values.html