*grin* Don't tell them

Gaurav.Vinodkumar (3/22/2010)

---

nice article...but one question..if we have to do the same thing at run time (means when user export the rport to pdf or excel) from the report viewer..is there...

How do you come to the value of 3 for left nodes with a value of 2 passed in? The way I understand it. ID 2 is a left (that’s...

What's the ultimate goal of this task?

or remove the case all together...

SELECT * FROM yourTable WHERE yourField <= @parameter + 1

You should find out why the subscription is getting messed up instead of working around the problem. 🙂

Kevin,

When that situation occurs it means that something went wrong during the execution. You will need to delete that subscription and create a new one.

One possible hack...

Look through the SQL jobs on your ReportServer instance named with a GUID. Since you've changed it so it would run in the past, you should be able...

Does your MonthYear table have entries for 2010?

Actually, it's less complicated than that. One (or more) of your parameters "depend" on the user's selection of another parameter. Simply move any paramter the relies on another parameter lower...

What's on line 95? 🙂

Search this site for the SPLIT function...

If you have a table like "tblTeamMembers" or "tblTeams" you'll need to LEFT JOIN the tblActivity to it.

All,

This is a link to the most recent version. I have not returned to work on this process since it's creation and there may be many ways to improve upon...

You'll have to address the security issue. I haven't gone down that path, so good luck ... !!!!

and if you get it, post your solution here for all to see...