I appreciate all of the help on this sdvoranchik and Phil.

Unfortunately your suggestion gives me the same values that my previous expression did. Your suggestion also wouldn't let me add...

That's a good catch (seeing the connection 134,648.44 - 63,530.00 = 71,118.44) , but that actually didn't work out.

Here's what it did:

Before Your Suggestion

SpecialistTeamTotal SalesBudgetDifference

DICK MATCHINSKY"$35,174.00""$63,530.00""($28,356.00)"

NATHAN MATCHINSKY"$16,193.00""$40,000.00""($23,807.00)"

PAUL MATCHINSKY"$52,096.00""$55,000.00" "($2,904.00)"

STEVE MATCHINSKY"$31,185.44""$66,700.00""($35,514.56)"

TOTALS:...

My grasshopper status has proven right!

It was a brain malfuntion on my end. I had two sums (a group sum, and a total group sum) and I used the wrong...

SSRSTips,

I wanted to finish explaining to Jeff what was going. I'm not a fan of unanswered questions 🙂

I just tried your solution and it actually didn't work, but it...

Jeff,

This dataset example needs to have these sums

Grand Total: $20,256.74

Subtotal: $20,256.74

Commission: $1,012.84

But what my report is giving me is

Grand Total: $60,770.22

Subtotal: $60,770.22

Commission: $3,038.52

I only want to see one, distinct Doc...

Jeff,

Here's the query. Our 3 database systems don't actually interface with each other. I failed to mention that in my previous post. But here's the query; there's nothing overly complex...

Already tried that....if only it were that easy 🙂

What I'm doing is making a list of all sales that have been paid and shipped. If a partial payment has been...

Steve, I'll let you know our situation and the method to my madness.

We have no development happening. I'm managing production systems on the database and user level.

We have a CRM...

Steve,

To answer your question about validity, I always copy tables to a seperate testing database that I need to test transactions on. That way data is consistent.

I'll take a look...

I guess there's nothing wrong with copying data over, it'd just be more convenient to have "live" data being pushed to the test environment. I'll probably end up scheduling my...