Viewing 15 posts - 376 through 390 (of 402 total)
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 21, 2012 at 9:40 am
Your Welcome 🙂
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 21, 2012 at 4:21 am
Max(Fields.Month.Value,"Dataset1") + Sum(Fields.Amount.Value,"Dataset2")
Assuming you wanted to Sum the second field
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 21, 2012 at 4:05 am
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 17, 2012 at 5:38 am
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 16, 2012 at 9:35 am
No Problem - hope it works for you!
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 16, 2012 at 9:11 am
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 16, 2012 at 8:51 am
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 16, 2012 at 3:25 am
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
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 16, 2012 at 3:10 am
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
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 16, 2012 at 3:05 am
Heres a link to get you started
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 10, 2012 at 8:39 am
Hi
Just a thought but can't you do this in your dataset using the CEILING function rather than in SSRS?
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 10, 2012 at 8:14 am
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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 9, 2012 at 8:57 am
@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...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 9, 2012 at 7:52 am
That wouldn't handle the bad data tho :ermm:
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 9, 2012 at 7:44 am
Viewing 15 posts - 376 through 390 (of 402 total)