Hello,


  I have created one crystal 9 reports with two subreports and in asp.net I am calling it. if I will use the code

 subRepDoc.DataDefinition.FormulaFields.Item("Schoo lID").Text = "'ab0'" for passing the record formula, it's working fine.

But if I will assign like

 subRepDoc.DataDefinition.FormulaFields.Item("Schoo lID").Text = "'" & session("SchoolID") & "'"

it's not giving the result. Do you have any suggestion?

Thanks
Ceema

Hi,

  I have got the reason, it was because if was searching for case sensitive data. I was passing Ab0 and database was having ab0 as data.

Thank you
Ceema