Crystal Reports Problem

Posted by Lakn2 under Regular Expressions on 7/7/2011 | Points: 10 | Views : 1919 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

i have one crystalreport ,i am getting data from storedprocedure to crystal report , my crystalreport data is

regdno: billno date
Name: Doa: Dod:

Particulars: Amount:
ConsultantFee -
SurgeonFee -
OtherExpenses -

now my question is if amount is zero then Consultantfee should hide . Give me any Suggessions

Thanks&Regards
LakshmiNarayana Nalluri.

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Sashys on: 7/7/2011 [Member] Starter | Points: 25

0	Hi, To hide some fields , you might want to get the fieldobject and hide it's content: FieldObject field; field = Report.ReportDefinition.ReportObjects[reportObjectName] as FieldObject; Don't remeber the code exactly, pls see if it can help you... Sasikumar .M Lakn2, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Sandeepkasar on: 4/17/2012 [Member] Starter | Points: 25

0	well this is quite simple don't use direct value instead 1. create a formula field for ConsultantFee (e.g. ffConsultantFee) like if {yourSP;1.Amount}=0 then 0 else {yourSP;1.ConsultantFee } 2. format this formula field (supress if zero) Lakn2, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts