0

I have created one report in crystal report...
i want to filter that report in vb6 with different conditions...
i have created selection formula, like,

str = "isnull({Prescriptions.RecDateR})"
Report.RecordSelectionFormula = str

but while running this it gives error that " SERVER HAS NOT YET BEEN OPNED"...
if i remove the 2nd line ten it runs fine, but adding formula to report it gives error...

Please can anyone help me..
thnak you...

3
Contributors
5
Replies
7
Views
5 Years
Discussion Span
Last Post by sanket044
0

te database connection is correct, but wile adding selection formula its not working, without it its working fine...

1

Hi,

In report, if "Convert Null To Defaults" setting is ON, then you have to check like this :

Report.RecordSelectionFormula = "totext({Prescriptions.RecDateR}) = ''"

Regards
Veena

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.