Check all of your parameters - one of them could be lacking a default. That's what fixed it for me when I was getting this error.

Regards

Jonathan

Why is that?

I recently had an issue where 'AND @ProfileIDI IS NOT NULL' was extremely slow (> 1 min), whereas using 'OR @ProfileIDI IS NULL' was much faster (< 10...

If the value won't change for each row, you can do this by putting the first value of the field into a hidden parameter, and then using the hidden parameter...

Rather than using dynamic code unnecessarily, why not do it like this?

[font="Courier New"]

SELECT*

FROMtbl_profile

WHERE(id = @id OR @id IS NULL)

AND(lastname = @lastname OR @lastname IS NULL)

AND(jobs = @jobs OR @jobs IS...

The simple answers are to either use a parameter variable in your where clause in the SQL, or filter the rows in the table properties based on a parameter.

If you're...

On a slightly different note, in Business Intelligence Design Studio any date parameters seems to want input in MM/DD/YYYY format regardless of the language setting of the report. As...

Does this article help?

http://www.sqlservercentral.com/columnists/bKhawaja/2945.asp

Regards

Jonathan

I think that the answer is simply to forgo the creation of history items...as this requires default parameters. Then I can have multiple subscriptions (set to run the report)...

Many thanks for the response Scott - I'll take a look at the Pratt book, though it seems to be Oracle-based whereas for this purpose I'm looking at SQL Server.

Jeff -...

I'd say your best bet would be to use VBA in Access.  You could then loop through all the ppt files and use the PowerPoint object model to inspect the...