=Format([Value Field],"N")&" "&[Currency Field]

That should do it - the format function is great for controlling individual items inside a larger composite.

Info on the number codes is available on the BOL,...

I'm pretty sure you need to play around with the KeepTogether property. I added a titbit to my old blog a longtime ago on it that should help:

IceDread (5/29/2012)

---

Most of you on this board is in the u.s. I believe however, and my gut feeling is that companies does not compete over workforce like this and are...

Wouldn't the guy with more experience be hired back pretty darned...

chrisn-585491 (5/23/2012)

---

I so often see people working in IT fail to take advantage of all the tools we have to automate much of their jobs. They often tell me if...

My attitude is that I'd rather spend the time creating a standardised way of retrieving the information in future and produce an easy output than spend the time trying to...

Marco Barroso (5/21/2012)

---

(2) Implementing Data Warehouses should not be on basic SQL Server cert. It should be on its own track under BI .. anyone with logical...

// removed as double posted

At least I'll be a lot closer to remembering the acronym I'll be working towards now!

Not a huge fan of the course contents, however, it's like the first year...

ditto

The query is neat and some mention to A's was...

Good article, interested in reading more but none of the links work - I reckon you need to remove the date components

I spend at least 30 minutes a day in work reading an article from SSC or investigating a way of doing some more efficiently/effectively. On top of that I...

Daniel Bowlin (5/10/2012)

---

This wouldn't actually restrict them from using other formats from Report Manager but if you created a report subscription with an output format of PDF and emailed them...

I don't think you can conditionally display some items as PDF in Report Manager. You could possibly create a URL rewrite that always add the render parameter but that...

sku370870 (5/9/2012)

---

stephanie.sullivan (5/9/2012)

---

sku370870 (5/9/2012)

---

You've spend hundreds of hours developing. A lot of your business logic is in your stored procedures and functions. You can't afford SQL Server hosting of your...