Can't you just use Interactive Sorting? (I am pretty sure it's in SSRS 2008, but I haven't used 2008 in a long time, esp. R1)

Right-click on column header row (with...

If you can, buy a copy of SQL Server Developer. It costs about $60 US, which is an absolute steal. While there is a cap on the size of...

I would start by reading Kendra Little's article, which is here[/url].

You might use the WITH RECOMPILE hint to force the generation of a new execution plan, but read her article...

"I have a model with two fact tables. There's a one to many relationship between them."

Begging your pardon, but shouldn't the two fact tables just share common dimensions? I don't...

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...