Your comment about Max() not working doesn't specify why it isn't working or if you're getting an error.

So, in the meantime, below is code that does take the Max(F.FLDDATE), and...

Your left joins are being forced into inner joins because of the criteria in the Where clause. Specifically, when using a left join, any criteria relevant to the tables on...

Hi Dave:

I have a similar problem. I want to set the "ToggleItem" property of the detail row to an expression, but it appears that SSRS 2005 is truly taking any...

SSRS 2005 doesn't appear to have a way to name excel worksheets.

SSRS 2008 R2 can name Excel worksheets when a report is exported -- see Robert Bruckner's blog post:

http://blogs.msdn.com/b/robertbruckner/archive/2010/05/16/report-design-naming-excel-worksheets.aspx

In addition to the awesome reports that Anthony links to, it appears that today's SQLServerCentral newsletter includes a link to similar types of reports for SSRS 2008 R2 as authored...

In addition to deleting the cached data file, if your report has parameters for the end-user to select, you should be able to refresh the cache by selecting different parameters...

Well, one approach is to do the concantenating in sql -- i.e., rather than return a dataset with 900 rows of data of distinct values, return just one row with...

Amir:

Is your goal merely to display all 900 on a single page? If so, why not just concantenate all of the values into a single field? Make the field the...

krypto69 (10/8/2009)

---

Is there a query out there that will show me all of the reports on my report server...and who has access to these reports?

If I use 'select name, path...

To:

GSquared

AccidentalDBA:)

LutzM

Thanks for all of your replies. I plan on testing them out for better understanding. Ultimately, I'll need to grow my knowledge of XML (which currently stands at near-zero)....

kramaswamy

Thanks for the follow-up suggestions. I hadn't yet investigated cascading packages, but may be worth trying.

thanks,

pete

I tried something similar to your suggestion using two different excel file connections, but when the initial excel data connection (with all expected columns) comes across a file that's missing...

It's as if the FINDSTRING function that is set to the expression of the variable just doesn't execute; there are no errors. When I set a breakpoint and watch the...

Ninja's_RGR'us and GSquared -- thanks for the dialogue and examples. I have a better sense of the various forms of conditional joins -- the "or" still looks weird even though...

Ninja's_RGR'us (11/14/2011)

---

GSquared (11/14/2011)

---

It's probably being used to accommodate a poor level of data normalization (should be rows, not columns), but it's not an uncommon thing to do.

It is, indeed, a...