Urgent Help...

[4Vikram]

I need a help in creating a custom feild in the table to use it... then condition is whenever I have a conflict my first feild shows 'Y' in the report.

I need a new field which should show the project name on which the conflicts have. Ante 'Y' vaste  project name ravali..

 

This is what I was trying and manam motham bebe asalu deentlo..

 

FunctionField
    {
    FieldName = ConflictProj
    FieldDescription = Conflict Project Name
    Calc = {
            case when ConflictFlag = 'Y' then JOB_DESCR
            else ''
            end
            }    
    FieldType = ftString
    Flags=ReportsUse
    FieldExplanation ={Conflict Project Name}

 

Twist enti ante JOB_DESCR anedi mali total from different table and the table where I am trying to add is a view table used for customization...

 

Any one please help...

[4Vikram]

LTT

[bulleye]

ltt

[SwamyRaRa]

Ltt

[4Vikram]

No one in DB aa

[lolliman]

adi em coding?

asalu question enti vayya?

 

ConflictFlag = 'Y' vasthee.. do u need to show up project name?

[Pournami1]

help

[SeemaLekka]

Ltt

[riashli]

Ltt

[4Vikram]

adi em coding?

asalu question enti vayya?

 

ConflictFlag = 'Y' vasthee.. do u need to show up project name?

Yes conflict Flag Y vaste project name ravali... C# coding maya

 

.cff file lo code create chesi dani maa report developer tool ki lagutunaru mayya...

 

so required feilds ani add cheskuntu untaru.. naaku emo em radu

[lolliman]

Yes conflict Flag Y vaste project name ravali... C# coding maya

 

ante edina varibale ki set cheyyali antunnava??? adi C# code kaadu vayya

 

 

FieldExplanation ={

            If ConflictFlag = 'Y' then FieldDescription
            else ''
            end if
            }    

 

mari JOB_DESCRIPTION matter enti?

 

 

[lolliman]

aa code nuvvu raasava?? already existing di? existing di ayithee koncham aa function motham veyyi mayya...

[4Vikram]

ante edina varibale ki set cheyyali antunnava??? adi C# code kaadu vayya

 

 

FieldExplanation ={

            If ConflictFlag = 'Y' then FieldDescription
            else ''
            end if
            }    

 

mari JOB_DESCRIPTION matter enti?

Job_description anedi ee project name bhaiyya,,, database lo job-descr ani undi...

 

twist endi ante dani code dorakatledu  and adi vere table lo undi.. ivi memu cheyamu London team chestadi, ma jeffa gadu kavalani naaku cheptundu ivani.. ipudu ekadi nundi extract cheyalo emo ardam aitaledu...

[4Vikram]

aa code nuvvu raasava?? already existing di? existing di ayithee koncham aa function motham veyyi mayya...

inthaku mundu post esindi nenu rasina,, inka veredi esta for example...

 

FunctionField
    {
    FieldName = ConflictBKGHours
    FieldDescription = Conflict Booked Time Hours
    Calc = {
            case when REPL(POSDELAYEDFN)('ConflictHoursDailyOT',RES, SRE) > 0 then _FN(InternalBookedTime, JOBRESBOOKEDVIEW, BaseAlias)
            else 0
            end
            }
    From = RES SRE
    Condition = {
        SRE.RES_ID=BaseAlias.BRJ_RES_ID        
    }
    FieldType = ftFloat
    Flags=ReportsUse
    FieldExplanation ={Conflict Hours}
    }    

 

FunctionField
    {
    FieldName = ConflictFlag
    FieldDescription = Conflict (Y/N)
    Calc = {
            case when ConflictBKGHours > 0 then 'Y'   
            else ''
            end
            }    
    FieldType = ftString
    Flags=ReportsUse
    FieldExplanation ={Conflict Hours Flag}
    }

[lolliman]

Job_description vere table lo undi, twist endi ante dani code dorakatledu.. ipudu ekadi nundi extract cheyalo emo ardam aitaledu...

 

kaadu mayya.. ippudu ee table lo vunna fields anni ela extract chestunnaru... each table ki different class or file code vuntada?

 

paina ekkado import or define chesi vuntaru kada  table name ni alaanee inko table ni kooda define cheyyu