Eliza:

I hate to say it, but you need to provide a little bit more information. When you say the reports differ only slightly, does that suggest that all three reports...

Take a look at two articles written by Mike Davis over at BIDN.com. The articles contain steps for SSRS 2008, but I imagine they might work for 2005 as well...

Without knowing the relationships of your tables (i.e. one-to-one vs. one-to-many vs. many-to-many), try the following code.

SELECT RMPROP.RMPROPID

,PROPNAME

...

David Burrows (3/8/2013)

---

I was thinking more on line of

SELECT XX.XY, XX.YY, XX.YX

FROM Properties

JOIN XX ON XX.RMPROPID = Properties.RMPROPID

WHERE Properties.RMPROPID IN (@PROPERTIES)

Which will give you one...

I wish I could tell you exactly why a report might be so much slower in report manager vs. BIDS, especially when the report is referencing a parameterized stored proc.

Nonetheless,...

Sometimes when a report seems to run "forever" or timeout, the problem stems from either having an underlying query that is written as "Select * From...." -- Seems like SSRS...

While I think I'm somewhat understanding what you are trying to achieve (i.e., one row of data per property), your approach is confusing me. So, I have a couple of...

renato_mech_334 (2/27/2013)

---

Where the document data would be the previous month,

there would be multiple accounts: for eg: [FTS Yearly Query].Account >= 847000 and [FTS Yearly Query].Account <=847900 or [FTS Yearly Query].Account...

I think you're striving for a master-detail report style: Here's an idea

Try using a list data region, grouping by Account, and add your two tables within the list region. Here's...

As Anthony.Green mentioned, it sounds like you need to be grouping your data in the first table. Without seeing a sample dataset it's difficult to provide info on what to...

We've run into a couple of cases where a report ran slow but the same query in SSMS responded just fine. In those instances the problem was either an issue...

Mike:

It sounds like you haven't set the Maxiumum scale to the same value (y axis, typically) for the embedded chart, consequently, your graphs aren't visually reliable when comparing values. Couple...

Simon -- congrats on your first steps towards all things OLAP and SSAS. I find your writings of your journey tantalizing and indeed humorous. (And, I must admit, I'm a...

Bushan:

You don't necessarily need sharepoint to create and display a dashboard that is built within a SSRS report.

You can actually create a dashboard within a single SSRS report. If necessary,...

Your description of a z-axis isn't quite right. I think you mean to say dual Y-axis. A z-axis would result in a three-dimensional rendering, compared to dual y-axis which is...