That depends on whether you just want to skip Sunday every time or whether you are saying you want to skip any day that has no data...

Case 1 : Skip...

GPO (11/14/2012)

---

I'm not against using obscure hacks, and there's always going to be a debate about the point at which you even classify something as...

Show us the code you use in the expression that builds the hyperllink and also copy the generated hyperlink from the rendered report and show us that.

Michael Meierruth (11/14/2012)

---

MM and Mark,

This is what I was looking for.

select top 1000 identity(int,1,1) as N

into dbo.HTally

from master.sys.all_columns ac1

cross join master.sys.all_columns ac2

But you would then have to do...

="http://servername/ReportServer/Pages/ReportViewer.aspx?%2ftest+1%2ftestds%2fReport2&rs:Command=Render&ReportParameter1="

& UrlEncode(Parameters!ReportParameter1.Value)

A quick google search found this blog, which seems a reasonable way:

http://capstonebi.blogspot.co.uk/2010/04/url-encoding-in-reporting-services.html

Yes,...

Jeff Moden (11/12/2012)

---

Just like the old cartoon, I've got to say... "Ah, Magoo! You've done it again!"

Here are the run results using the same machine I used in testing...

Excellent article once again Jeff 🙂

Nicely written and excellent Resource zip.

I have made a revision and I would be interested if you could take a look at it and let...

Jeff Moden (11/9/2012)

---

You're...

Jeff Moden (11/9/2012)

---

As a bit of a side bar, I think I'm really bad at XML and, for some...

Ha!, you were just pretending not to know all along! 😀

Here is a version that would handle things for multiple RootA nodes and multiple Payees, assuming you just want a cross-join of payees with due dates for now....

--===== This shreds...

A couple of points to bear in mind about OPENXML:

1. Memory ( http://msdn.microsoft.com/en-us/library/ms187367(v=sql.90).aspx

A parsed document is stored in the internal cache of SQL Server 2005. The MSXML parser uses one-eighth...

Jeff Moden (11/9/2012)

---

Does this help ?

That does, in fact, help. I realize that I didn't have it in my test data and so apologize for that but if you...