reporting services - SSRS : New calculated field based on where condition -

reporting services - SSRS : New calculated field based on where condition -

i'm new ssrs reporting , i'm need of help...

i have dataset fields "process", "level" , "workweek"

process level ww ------- ----- -- test lvl_0 3 test lvl_1 28 test lvl_2 48 samp lvl_0 10 samp lvl_1 39 samp lvl_2 51

what want create 2 more calculated fields called start_ww , pro_start has values ww field.

ww of lvl_0 considered process_start.

the logic

process level ww start_ww pro_start ------- ----- -- -------- --------- test lvl_0 3 0 3 test lvl_1 28 3 3 test lvl_2 48 28 3 samp lvl_0 10 0 10 samp lvl_1 39 10 10 samp lvl_2 51 39 10

i know similar sql

update table set start_ww=(select ww table level='lvl_0') level='lvl_1'

update table set proc_start=(select ww table level='lvl_0')

i'm not sure how write look it. pls help me.

thanks in advance!!

if start_ww previous ww don't need calculated field; can utilize previous() function in look table's cell:

=iif(fields!process.value = previous(fields!process.value), previous(fields!ww.value), 0)

for pro_start, can add together sql:

select mytable.process, mytable.level, mytable.ww, start.pro_start mytable inner bring together ( select process, level, min(ww) pro_start mytable grouping process, level ) start on mytable.process = start.process , mytable.level = start.level

with no access query, can pro_start via lookup():

=lookup(fields!process.value, fields!process.value, fields!ww.value, "mydataset")

the lookup() homecoming first instance of process , give ww of row.

reporting-services ssrs-2008 ssrs-2008-r2