Danish Habib

Danish Habib

  • NA
  • 694
  • 245.7k

crystal report with parameters

Jul 28 2015 4:47 AM
I am using crystal report and parameter in it , I am not using any dataset or datatable i am using direct Crystal report wizard and direct connection to my Db , I have added two parameter
{Year.Year_Name} = {?Year} and
{AnswersNew.CdfPErsonName} = {?CDF Name} and
 
and when i am going to add a third parameter into my report the crystal report append NOT HAS VALUE Method in it just like that and it also does not shown into the parameter selection list 
(not HasValue({?Village}) OR {Villages.VillageName} = {?Village})
 
Not the whole string formula becomes like that
{Year.Year_Name} = {?Year} and
{AnswersNew.CdfPErsonName} = {?CDF Name} and
(not HasValue({?Village}) OR {Villages.VillageName} = {?Village})
and it does not show the Village parameter when selecting the parameter pane