Crystal Reports Problem

Posted by Lakn2 under Regular Expressions on 7/7/2011 | Points: 10 | Views : 1078 | Status : [Member] | Replies : 2
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.



Responses

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

Up
0
Down
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

Up
0
Down
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

Login to post response