Sorry no one has answered your question yet. Hopefully this helps...

As to Item 1) I haven't tested you code, but it would certainly seem that it would work for...

Very good one Larry.

-Luke.

I'd imagine this is actually an error form the source database not from SSRS, but I could be wrong... Have you tried to execute the same query directly from...

Roy Ernest (10/1/2010)

---

I just wanted to let you all know that Jeff Moden gave a great presentation for our user group yesterday using Netmeeting. Everyone loved it. And they like...

Also, if it runs fine on the server but not your development machine, your dev machine probably needs more ram.

but this is what I Was trying to say earlier

when...

I'd have to really, really really disagree with this as a method for solving the OP's issue.

First, it's Dynamic SQL which can cause security and performance issues down...

spending a few extra minutes or hour developing the other(extra) reports (since you'll probably be using the same general format) will over the lifetime of the report cost your company...

I'm guessing that your SSRS instance is not on the same physical machine as your source database. If it is then some of this won't apply, but the same...

How would you use DATEDIFF to solve the OP's problem?

ok from another thread here talking about issues connecting to SSRS 05 using the 08 tools and other things, try connecting via a hostname or URL not by IP. ...

Can you connect with the Report Manager web admin tool?

Did you try to connect with an account that has appropriate permissions to the SSRS instance?

What about from a remote machine?...

What errors are you seeing in your security log, application log, etc?

One of your screenshots in your first posts had an error message that basically said hey, go look at...

Greg, it might be helpful if you provided some details into what exactly you are trying to do. You say you have 1 that's working and 1 that isn't....

Daniel Bowlin (9/27/2010)

---

Your dataset query for the invoice data must include start and end parameters. Something like

SELECT *

FROM invoice

WHERE invoice.date BETWEEN @Start AND @End

These should automatically link to like...

First I'm slightly confused by this statement...

everything checks out when we run the report through the ReportManager. It only prompts us for credentials coming from the second instance of...