I also assumed that he was using BIDS as well but turns out that might not be the case. What he needed to achieve can be done very easily...

Paul - I never worked with SSRS 2005 and don't have it installed so I am afraid I can't help you further. Did you give any thought to doing...

Paul -

For your first question, the easiest way is to set a default value for your date parameter. Set it so that the default value pulls from a query....

I think that this is best handled in your query but if you must do it in RS, there is indeed a solution. I didn't think it was possible...

Here's another way using row_number/partitioning

DECLARE @tDUMMY TABLE (

StartDate DATE,

Activity VARCHAR(100),

CategoryID INT

);

INSERT INTO @tDUMMY

SELECT CONVERT(DATE, '1876-01-01'), 'Action in 1876', 1 UNION ALL

SELECT CONVERT(DATE, '1945-01-01'), 'Action...

jcrawf02 (10/8/2010)

Filter on Active suggestions (left hand side) and...

Thanks jcrawf02. I bookmarked the link. Will look through the 6K or so suggestions when I find some time!

Indeed. Fairness is key. Unfortunately, many businesses do not put that principle to practice.

I think that any opinion that are well-formed and rational deserves to be heard and discussed, no matter how controversial. As long as it was not intended to be...

Luke - I am relatively new to Microsoft technologies still feel kinda lost navigating their forums and sites but I will take a look to see if anyone has requested...

I hope that one day SSRS would come with a string aggregation feature where the SUM() function would work on strings as well as numeric values. The result would...

A couple of people mentioned using Join to solve the problem on the GUI side but I'd be curious to know how to implement it. I had this problem...

Your second main query should work but you had a parenthesis in the wrong place. Here's the corrected version:

SELECT servername, dbname, CollectionDateTime, datafileinmbs, logfileinmbs, databaseinmbs

FROM temp2

WHERE (CollectionDateTime BETWEEN...

Abs-225476 (9/30/2010)

Like Veeren4urs said you need to have a dataset which will provide a pick list for the parameters, something like :

select distinct country_name from customers

union all

select 'ALL'

Then...

Someone mentioned that the author probably should have broken the article into a series. I agree. It would certainly make the material more digestable (if that's a word)....