Display only the latest two consecutive years?

Hi all,

I have a Matrix with several static rows of financial information with a column group that groups the information by date:
01.02.04 12.09.03
Dividend 455,789 346,098
Profit 100,787 264,687
Deposits 89,078 76,003
Currently I have a filter on the column group that limits the information to the top two dates (Fields!dateField.Value Top N =2). What I also need is to filer the data so that only consecutive years are displayed. I have tried the filter (Year(Fields!dateField.Value) >= Year(Max(Fields!dateField.Value)) - 1), but this doesn't stop non-consecutive years being added to the Matrix. What am I missing here?
Any help you have to offer is much appreciated!
Thank you,
Stephen.

stephen,

i think that this task seems to be "database work" - just evoke the needed data by an appropriate sql-statement.

cheers
markus

|||

Thank you for your reply.

Is there any way that I can do this without altering the underlying dataset? Unfortunately, the query already returns all of the data that is required and nothing more, so limiting any of the data there would cause problems elsewhere in the report.

Stephen.

|||How about creating a second dataset with a modified query to get only the data you need. So then you have one dataset with all the dataand one with the last two years.|||That's a good idea! I will have a play around with it and will let you know how I get on.

Thanks!

Regards,

Stephen.|||

That seems to have done the trick!

Thanks!

Stephen.

Display number in thousands

How do I display a number in thousands rather than the full numer
e.g. 100,000 as 100. THis is for a financial report and managers are not
interested in numbers in the hundreds. I know i can divide by a thousand.
But can the Format command do it instead
--
Gerry Connolly"GerryC" wrote:
> How do I display a number in thousands rather than the full numer
> e.g. 100,000 as 100. THis is for a financial report and managers are not
> interested in numbers in the hundreds. I know i can divide by a thousand.
> But can the Format command do it instead
> --
> Gerry Connolly|||I am assuming that you are using Report Designer.
Textbox formatting functionality supports custom format strings. To reach
this functionality right click in a textbox and select Properties. From there
navigate to the Format tab and click on the "..." button associated with the
Format Code option.
Select the Custom option on the Choose Format dialog. You may want to review
the Formatting Numeric and Date Values in a Report topic in SQL Server 2005
Books Online at http://msdn2.microsoft.com/en-us/library/ms157406.aspx
"GerryC" wrote:
> How do I display a number in thousands rather than the full numer
> e.g. 100,000 as 100. THis is for a financial report and managers are not
> interested in numbers in the hundreds. I know i can divide by a thousand.
> But can the Format command do it instead
> --
> Gerry Connolly