Search code examples
c#crystal-reports

A Boolean is required here in Crystal Report

I want to show "NoData" if its value is less than Zero and "Commission" if its value is greater than Zero. When i show "String" its gave me error the boolean is required here and then if i do toText{VBookingCommission.MarketingPersonnelCommission1} it gaves me Error Convert it to String

This is my Query for Crystal Report

        if({VBookingCommission.MarketingPersonnelCommission1}<0)
           then "NOData" else "Commission";

If i do this its working Fine

        if({VBookingCommission.MarketingPersonnelCommission1}<0)
             then true else false;
Solution

  • I wrote a code like what you need. in formula edit form set visual basic instead of crystal report. code: if({VBookingCommission.MarketingPersonnelCommission1}<0) then formula="NOData" else if({VBookingCommission.MarketingPersonnelCommission1}>0) then formula="Commission"