New to SSRS - Advise on basic formulas

[LROTA]

Hey,

i work for a small software company providing .net systems in the insurance / reinsurance world.

i am on the front end sales / client management side but know my way round a computer pretty well, and basic coding of creating a website.

we have a datawarehouse, and use MS SSRS, with Sequel 2005 and our expert has left on this, so it has been allocated to me to learn and be in charge of

does anyone know the best book to learn formulas from, as i have learnt how to use the report, how to gets fields across etc but now i need to start creating fields from the fields it brings through

for example i need to create the following field

Sum(Decimal(IF(Field A > or = 0 & Field A < 31)"0.00","0.00"))

well at least that doesnt work so i need to learn how to change that, as i need to:
A - change the field to a number from a text field
B - have two parameters, this field must be equal or greater than a number, and lower then another number

can anyone help me with this or put in the right direction of a good book i can learn all this from

thanks

 

[xlbo]

IF needs to be IIF

The brackets follow the same syntax as excel e.g.

=IIF(TestCondition,ResultIfTrue,ResultIfFalse)

To convert things you need to use functions such as:

CDec
CInt
Cstr

etc etc

Best book I've found is the Hitchhikers guide but generally a google search or here on Tek-Tips is a good resource

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question