If I have a textbox called Sum_M with this expression for it's value:

=SUM(code.GetValue(Fields!Sum_M.Value))

And this expression for the Format:

= SWITCH(

ReportItems!Sum_M.Value >= 1000000 , "$ #,##0,,.00...

Can you explain more about the problem, because that expression should work just fine.

I have tested it to make sure and it does apply the formatting.

AFAIK, SMO doesn't treat indexes as objects, which is why you have scripting options to include them or not (in the table scripts).

To get NCI into a separate file from...

As we are all having a guess at your problem, did you try running the...

The easiest way is to add a column to the dataset that flags whether the row contains a value that is in the top 20%.

then in SSRS, you can use...

Orlando Colamatteo (2/3/2016)

---

By the very nature of how a compiled application's deployment model works the developer or admin is compelled to go to a VCS where the plain-text class and...

Yes,...

Before making changes to SQL objects, I'm in the habit of updating my dev VCS from production, then checking for any changes that may have "slipped" in before starting my...

I would take a look at the xml being produced.

First step is to "unzip" the xlsx file after it has been created - before you try and open it with...

...and what if the intention was to update all rows matched on those three columns?

Before you go changing something just because it "looks wrong", I suggest you check with the...

mishka-723908 (1/22/2016)

---

Hello, Thanks for your reply.

This will group all the rows where A = 1 and B = Al to one row.

I only want to sum those up where...

Pleased to hear it.

Funnily enough, I had just been doing HTML email this way myself a day or so ago, so it was...

Try this, but if you get errors about collation incompatibility, don't forget that Sage requires a binary collation, so you may need to add COLLATE Latin1_General_BIN to the WHERE clause,...

donato1026 (1/20/2016)

---

Hello everyone,

I am trying to pull back a hyperlink from a table, but when it is emailed to me, it shows the whole hyperlink and everything in the email....

dandrews 45259 (1/20/2016)

---

This is the script I need to run:

...

Ive removed half the entries above from both the SELECT and INSERT INTO

Where needs to be where the sage_prdocut code matches...