Hi

As far as I know you have to go to the properties on the region of the report that is drilling down and in the Action section of the properties...

Your Welcome 🙂

Max(Fields.Month.Value,"Dataset1") + Sum(Fields.Amount.Value,"Dataset2")

Assuming you wanted to Sum the second field

Hi

You can change the report regional language (by clicking outside the report body in the properties on the right of the screen) to change the parameter default date format...

No sorry I don't think that there is a quicker way of doing this as different parameters have to be passed through to the corresponding reports / report from your...

No Problem - hope it works for you!

No thats not possible but couldn't you assosiate the dataset with the texboxs and just take the MAX / MIN assosiated values from that column within the dataset?

I'm making the...

For me it makes the query a little easier to read - this is such a small script it doesn't really make a difference either way and I would say...

The top script is using variables to pass in the current date whereas the bottom script passes in the current date without using variables

Both should do the same thing

Andy

Hi

You should be able to use the built in MAX and MIN functions in Reporting Services on the date field

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

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

Heres a link to get you started

Hi

Just a thought but can't you do this in your dataset using the CEILING function rather than in SSRS?

Actually think I may have misunderstood this should work better, its not very pretty but it gets the job done I suppose:

-- Build Test Data

DECLARE @PRODA AS TABLE

(

Customer_Number int

,Product_ID CHAR...

@Rafo Thats true I hadn't thought of throwing it into a table variable - I suppose it depends on the volume of data how efficient that solution would be but...

That wouldn't handle the bad data tho :ermm: