TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
prabhu p
NA
181
114.5k
how to write formula field with huge formula in cryst report
Nov 28 2014 12:29 PM
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
Reply
Answers (
0
)
can anyoen tell me when i use file upload in asp.net
Entity framework 5 Log