0
Answer

how to write formula field with huge formula in cryst report

prabhu p

prabhu p
10y
577
1
i am using huge formula fields in crystal report so when deploying in IIS 7.5 its not working ..Can you help me out with this problem But in local host crystal report have been executing with the same formula This wht my sample fomula





this my formula.asp.net c# crystal reports
 
if({Attendance.Grade}="G" and {Attendance.mont}="January") then
({client_info.sal_Basic_G} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}="G" and {Attendance.mont}="February") then
({client_info.sal_Basic_G} /28) * {Attendance.tot_days}
else if ({Attendance.Grade}="G" and {Attendance.mont}="March") then
({client_info.sal_Basic_G} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}="G" and {Attendance.mont}="April") then
({client_info.sal_Basic_G} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}="G" and {Attendance.mont}="May") then
({client_info.sal_Basic_G} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}="G" and {Attendance.mont}="June") then
({client_info.sal_Basic_G} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}="G" and {Attendance.mont}="July") then
({client_info.sal_Basic_G} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}="G" and {Attendance.mont}="August") then
({client_info.sal_Basic_G} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}="G" and {Attendance.mont}="September") then
({client_info.sal_Basic_G} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}="G" and {Attendance.mont}="October") then
({client_info.sal_Basic_G} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}="G" and {Attendance.mont}="November") then
({client_info.sal_Basic_G} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}="G" and {Attendance.mont}="December") then
({client_info.sal_Basic_G} /31) * {Attendance.tot_days}
 

else if({Attendance.Grade}="SO" and {Attendance.mont}="January") then
({client_info.sal_Basic_so}/31) * {Attendance.tot_days}
else if ({Attendance.Grade}="SO" and {Attendance.mont}="February") then
({client_info.sal_Basic_so} /28) * {Attendance.tot_days}
else if ({Attendance.Grade}="SO" and {Attendance.mont}="March") then
({client_info.sal_Basic_so} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}="SO" and {Attendance.mont}="April") then
({client_info.sal_Basic_so} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}="SO" and {Attendance.mont}="May") then
({client_info.sal_Basic_so} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}="SO" and {Attendance.mont}="June") then
({client_info.sal_Basic_so} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}="SO" and {Attendance.mont}="July") then
({client_info.sal_Basic_so} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}="SO" and {Attendance.mont}="August") then
({client_info.sal_Basic_so} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}="SO" and {Attendance.mont}="September") then
({client_info.sal_Basic_so} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}="SO" and {Attendance.mont}="October") then
({client_info.sal_Basic_so} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}="SO" and {Attendance.mont}="November") then
({client_info.sal_Basic_so} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}="SO" and {Attendance.mont}="December") then
({client_info.sal_Basic_so} /31) * {Attendance.tot_days}
 

else if({Attendance.Grade}="ASO" and {Attendance.mont}="January") then
({client_info.sal_basic_ASo}/31) * {Attendance.tot_days}
else if ({Attendance.Grade}="ASO" and {Attendance.mont}="February") then
({client_info.sal_basic_ASo} /28) * {Attendance.tot_days}
else if ({Attendance.Grade}="ASO" and {Attendance.mont}="March") then
({client_info.sal_basic_ASo} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}="ASO" and {Attendance.mont}="April") then
({client_info.sal_basic_ASo} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}="ASO" and {Attendance.mont}="May") then
({client_info.sal_basic_ASo} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}="ASO" and {Attendance.mont}="June") then
({client_info.sal_basic_ASo} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}="ASO" and {Attendance.mont}="July") then
({client_info.sal_basic_ASo} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}="ASO" and {Attendance.mont}="August") then
({client_info.sal_basic_ASo} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}="ASO" and {Attendance.mont}="September") then
({client_info.sal_basic_ASo} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}="ASO" and {Attendance.mont}="October") then
({client_info.sal_basic_ASo} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}="ASO" and {Attendance.mont}="November") then
({client_info.sal_basic_ASo} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}="ASO" and {Attendance.mont}="December") then
({client_info.sal_basic_ASo} /31) * {Attendance.tot_days}
 

else if({Attendance.Grade}="LG" and {Attendance.mont}="January") then
({client_info.sal_Basic_LG}/31) * {Attendance.tot_days}
else if ({Attendance.Grade}="LG" and {Attendance.mont}="February") then
({client_info.sal_Basic_LG} /28) * {Attendance.tot_days}
else if ({Attendance.Grade}="LG" and {Attendance.mont}="March") then
({client_info.sal_Basic_LG} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}="LG" and {Attendance.mont}="April") then
({client_info.sal_Basic_LG} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}="LG" and {Attendance.mont}="May") then
({client_info.sal_Basic_LG} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}="LG" and {Attendance.mont}="June") then
({client_info.sal_Basic_LG} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}="LG" and {Attendance.mont}="July") then
({client_info.sal_Basic_LG} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}="LG" and {Attendance.mont}="August") then
({client_info.sal_Basic_LG} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}="LG" and {Attendance.mont}="September") then
({client_info.sal_Basic_LG} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}="LG" and {Attendance.mont}="October") then
({client_info.sal_Basic_LG} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}="LG" and {Attendance.mont}="November") then
({client_info.sal_Basic_LG} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}="LG" and {Attendance.mont}="December") then
({client_info.sal_Basic_LG} /31) * {Attendance.tot_days}
 

 
else if({Attendance.Grade}="FG" and {Attendance.mont}="January") then
({client_info.sal_Basic_FG}/31) * {Attendance.tot_days}
else if ({Attendance.Grade}="FG" and {Attendance.mont}="February") then
({client_info.sal_Basic_FG} /28) * {Attendance.tot_days}
else if ({Attendance.Grade}="FG" and {Attendance.mont}="March") then
({client_info.sal_Basic_FG} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}="FG" and {Attendance.mont}="April") then
({client_info.sal_Basic_FG} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}="FG" and {Attendance.mont}="May") then
({client_info.sal_Basic_FG} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}="FG" and {Attendance.mont}="June") then
({client_info.sal_Basic_FG} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}="FG" and {Attendance.mont}="July") then
({client_info.sal_Basic_FG} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}="FG" and {Attendance.mont}="August") then
({client_info.sal_Basic_FG} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}="FG" and {Attendance.mont}="September") then
({client_info.sal_Basic_FG} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}="FG" and {Attendance.mont}="October") then
({client_info.sal_Basic_FG} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}="FG" and {Attendance.mont}="November") then
({client_info.sal_Basic_FG} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}="FG" and {Attendance.mont}="December") then
({client_info.sal_Basic_FG} /31) * {Attendance.tot_days}
 

 
//OTH1
 
else if({Attendance.Grade}={client_info.grade6} and {Attendance.mont}="January") then
({client_info.sal_Basic_other1}/31) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade6} and {Attendance.mont}="February") then
({client_info.sal_Basic_other1} /28) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade6} and {Attendance.mont}="March") then
({client_info.sal_Basic_other1} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade6} and {Attendance.mont}="April") then
({client_info.sal_Basic_other1} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade6} and {Attendance.mont}="May") then
({client_info.sal_Basic_other1} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade6} and {Attendance.mont}="June") then
({client_info.sal_Basic_other1} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade6} and {Attendance.mont}="July") then
({client_info.sal_Basic_other1} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade6} and {Attendance.mont}="August") then
({client_info.sal_Basic_other1} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade6} and {Attendance.mont}="September") then
({client_info.sal_Basic_other1} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade6} and {Attendance.mont}="October") then
({client_info.sal_Basic_other1} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade6} and {Attendance.mont}="November") then
({client_info.sal_Basic_other1} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade6} and {Attendance.mont}="December") then
({client_info.sal_Basic_other1} /31) * {Attendance.tot_days}
 
//OTH2
 

else if({Attendance.Grade}={client_info.grade7} and {Attendance.mont}="January") then
({client_info.sal_Basic_other2}/31) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade7} and {Attendance.mont}="February") then
({client_info.sal_Basic_other2} /28) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade7} and {Attendance.mont}="March") then
({client_info.sal_Basic_other2} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade7} and {Attendance.mont}="April") then
({client_info.sal_Basic_other2} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade7} and {Attendance.mont}="May") then
({client_info.sal_Basic_other2} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade7} and {Attendance.mont}="June") then
({client_info.sal_Basic_other2} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade7} and {Attendance.mont}="July") then
({client_info.sal_Basic_other2} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade7} and {Attendance.mont}="August") then
({client_info.sal_Basic_other2} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade7} and {Attendance.mont}="September") then
({client_info.sal_Basic_other2} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade7} and {Attendance.mont}="October") then
({client_info.sal_Basic_other2} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade7} and {Attendance.mont}="November") then
({client_info.sal_Basic_other2} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade7} and {Attendance.mont}="December") then
({client_info.sal_Basic_other2} /31) * {Attendance.tot_days}
 

//OTH3
 

else if({Attendance.Grade}={client_info.grade8} and {Attendance.mont}="January") then
({client_info.sal_Basic_other3}/31) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade8} and {Attendance.mont}="February") then
({client_info.sal_Basic_other3} /28) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade8} and {Attendance.mont}="March") then
({client_info.sal_Basic_other3} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade8} and {Attendance.mont}="April") then
({client_info.sal_Basic_other3} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade8} and {Attendance.mont}="May") then
({client_info.sal_Basic_other3} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade8} and {Attendance.mont}="June") then
({client_info.sal_Basic_other3} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade8} and {Attendance.mont}="July") then
({client_info.sal_Basic_other3} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade8} and {Attendance.mont}="August") then
({client_info.sal_Basic_other3} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade8} and {Attendance.mont}="September") then
({client_info.sal_Basic_other3} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade8} and {Attendance.mont}="October") then
({client_info.sal_Basic_other3} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade8} and {Attendance.mont}="November") then
({client_info.sal_Basic_other3} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade8} and {Attendance.mont}="December") then
({client_info.sal_Basic_other3} /31) * {Attendance.tot_days}
 
//OTH4
 
else if({Attendance.Grade}={client_info.grade9} and {Attendance.mont}="January") then
({client_info.sal_Basic_other4}/31) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade9} and {Attendance.mont}="February") then
({client_info.sal_Basic_other4} /28) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade9} and {Attendance.mont}="March") then
({client_info.sal_Basic_other4} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade9} and {Attendance.mont}="April") then
({client_info.sal_Basic_other4} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade9} and {Attendance.mont}="May") then
({client_info.sal_Basic_other4} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade9} and {Attendance.mont}="June") then
({client_info.sal_Basic_other4} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade9} and {Attendance.mont}="July") then
({client_info.sal_Basic_other4} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade9} and {Attendance.mont}="August") then
({client_info.sal_Basic_other4} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade9} and {Attendance.mont}="September") then
({client_info.sal_Basic_other4} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade9} and {Attendance.mont}="October") then
({client_info.sal_Basic_other4} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade9} and {Attendance.mont}="November") then
({client_info.sal_Basic_other4} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade9} and {Attendance.mont}="December") then
({client_info.sal_Basic_other4} /31) * {Attendance.tot_days}
 
//OTH5
 
else if({Attendance.Grade}={client_info.grade10} and {Attendance.mont}="January") then
({client_info.sal_Basic_other5}/31) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade10} and {Attendance.mont}="February") then
({client_info.sal_Basic_other5} /28) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade10} and {Attendance.mont}="March") then
({client_info.sal_Basic_other5} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade10} and {Attendance.mont}="April") then
({client_info.sal_Basic_other5} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade10} and {Attendance.mont}="May") then
({client_info.sal_Basic_other5} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade10} and {Attendance.mont}="June") then
({client_info.sal_Basic_other5} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade10} and {Attendance.mont}="July") then
({client_info.sal_Basic_other5} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade10} and {Attendance.mont}="August") then
({client_info.sal_Basic_other5} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade10} and {Attendance.mont}="September") then
({client_info.sal_Basic_other5} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade10} and {Attendance.mont}="October") then
({client_info.sal_Basic_other5} /31) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade10} and {Attendance.mont}="November") then
({client_info.sal_Basic_other5} /30) * {Attendance.tot_days}
else if ({Attendance.Grade}={client_info.grade10} and {Attendance.mont}="December") then
({client_info.sal_Basic_other5} /31) * {Attendance.tot_days}
Improve question   Permalink   
 
Next Recommended Forum