So what was your question?

From the looks of it, you have a typo... or several. You can use joins, but your SQL has some typos.

customers <> custimers

orders <> order

SELECT...

Apologies if I'm repeating myself. Here's one way of exploring what your best options are...

Since your target users are already Excel folks, either PowerPivot or PowerBI sounds like the...

... that way I can tell my boss that second monitor really is required!

You could always restore a read-only copy of your database and let your users connect to that... then at least the two databases would be separate... if you ran a...

What if you change the formatting to some kind of decimal? If SSRS is rounding behind the scenes and the numbers are less than .5, then they may be rounding...

Young Jedi,

A LEFT/RIGHT/OUTER join is "lossless". In other words, you'll get NULLs propagated on the "outside" table if you use an outer join. It's the way outer joins are...

oh, use "" instead.

There are several options...

If they're already good at Excel, you might try either PowerPivot or PowerBI Desktop. I would lean toward PowerBI Desktop. If you have something like...

I need =Parameters!FundId.Value if this equals Fields!Fund_Name.Value than show =Parameters!FundId.Value

=IIF(Fields!Fund_Name.Value = Parameters!FundID.Value,Parameters!FundID.Value,NULL)

?

Since you're new, maybe this won't hurt... watching Grant Fritchey explain it and walk you through it...

Probably the easiest way is to (temporarily) set those values as the defaults for the respective fields. If you want the same values tested over and over again, because...

I'm not an expert on SSAS, so I can't answer that part, but PowerBI lets you build a quick star schema and start analyzing data immediately. SSAS can do...

Hi,

this is close, but not quite right, I think... First off, since you're new, it would help those folks trying to help you if you could post your table...

Jeff,

Just wondering what you would say to an applicant that admitted up front that he may be underqualified, but asked you to help him figure out what he needed to...

I would start by reading this article: The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url]