Setting Temporary Value to Dataset field

Dear All.

I have a variable(tempstatus) that should be on the top of the report,that should show the following values, that depends upon the parameter (status(work status) and work type) from the request page

in the fetch method of the dataset i set tempstatus as follow.

if ((DataSet.getString("status")== "CLOSE") ||(DataSet.getString("status")== "COMP") && (DataSet.getString("WORKTYPE")== "CM"))
row["TEMPSTATUS"]= "Close Work Order Report CM";

if ((DataSet.getString("status")== "CLOSE") ||(DataSet.getString("status")== "COMP") && (DataSet.getString("WORKTYPE")== "PM"))
row["TEMPSTATUS"]= "Close Work Order Report(PPM)"

else if ((DataSet.getString("status")== "WAPPR") ||(DataSet.getString("status")== "WSH") ||(DataSet.getString("status")== "APPR") && (DataSet.getString("WORKTYPE")== "CM"))
row["TEMPSTATUS"]= "Open Work Order Report"

elseif

But the thing is when i ran the report for the first time,it show correctly ,later on if we change the status,it is taking the previous value,not showng the tempstatus value correctly,is there anything worng on this or is there any other way to do this..

Thanks in advance

Thanks

Find more posts tagged with

Comments

JasonW

can you post the whole report? If you want the variable to depend on a report parameter why are you using the fetch method?

Jason

Sneha

Jason,

whereever i gave it is taking only the first if section,at last i tried in fetch method.

Thanks

Sneha

Jason,

i did it one by one and i got the result.

Thanks a lot