Hi Rob

Just tried that and the result is the same.

Just wondering about a where clause..

Cheers

C

Cheers mate - some good suggestions there, I'll give them a bash and see how it goes.

I'll report back later.

Thanks again.

Canazei65

Hi

Yep, that's exactly the setup and yes it does help (at least I know I've not done anything obviously wrong) Now I'm stuck though and wondering about steps to resolve...

Hi

Sorry about that, maybe this will be clearer. I've got the same problem with selecting multiple values from a parameter in another report.

The SQL for the query on which the...

Tried adding

=IIF(Fields!ChargeCode.Value = 1,"AreaGroupA","AreaGroupB")

to the parameter, but SSRS won't allow parameters to reference fields. Is there another way to do this for example by the use of a filter...

Thanks - as you can tell, I'm pretty new at SSRS expressions!

Cheers.

Hi

I managed to get things to work with slightly amended code as follows:

=iif (Parameters!From.Value > CDate("31/3/"+right(Parameters!FinancialYear.Value,2))

or (Parameters!From.Value < DateAdd(DateInterval.Year, -1, CDate("1/4/"+right(Parameters!FinancialYear.Value,2)))

or Parameters!From.Value > Parameters!To.Value)

or...

Thank you cphite, that's brilliant. I'll implement when I get to work tomorrow and let you know how it goes.

I have to admit, I didn't know about the cdate and...

Hi

Thanks for the replies - I shall take a look now. However, I should have made it clear in my post the financial year in the UK runs from 1st...

Sorry my previous post was incomplete (pressed some key combination that submitted).

Here's what I meant to say:

Hi

I have 3 parameters in my report:

[FinancialYr] in text format: '2011/12', '2012/13' etc

[FromDate] in...

Thanks Dwain - nice to come back from hols to some interesting reading. Looks very useful.

Cheers

Canazei

Hi

Yes, we're just talking views here, so you're correct.

Cheers

Canazei65

Good point and I'll definitely bear it in mind. We usually report well over a month in arrears though, so hopefully we should have plenty of time to adjust it.

Cheers

Elliott and SSC Crazy - After a bit of a delay, I've implemented Elliott's solution and will be changing a few other Finance views too. This will make reporting much...

Thank you guys -

I've not written much SQL for a while and this (use of cte's) has really refreshed my knowledge.

I'll implement and let you know how it goes.

Cheers

canazei65