Need help: Crystal Reports Formula Editor

[mmcshane]

I have a few questions. I have a UI built with VB.net 2003 with a couple of Range fields. I am also using a view out of a SQL server 2000 DB. One is a date range and I am trying to figure out how to handle the case where if there is no date entered. If there is no date entered does Crystal see this field as null or is it "" or some other value?

If a valid date is entered I want to do a myDate is between ?myDateStart and ?myDateEnd in the Forumla Editor to take care of the possible values entered.

How would I build a parameter formula for this it is null and if its a valid date?

Another thought I had was instead of using the Formula editor I could maybe use a stored procedure but the problem here is in the Database Expert when I choose OLE DB (ADO) for my datasource and select my server and login all I see are Tables and Views. Stored Procedures I am not seeing here for some reason.

Any help would be greatly appreaciated. Thanks in advance

[yousufkhan]

yes you can put if condition in formula editor to check the field wheather there is null or valid date then do what you want

[brucevde]

Another thought I had was instead of using the Formula editor I could maybe use a stored procedure but the problem here is in the Database Expert when I choose OLE DB (ADO) for my datasource and select my server and login all I see are Tables and Views. Stored Procedures I am not seeing here for some reason.

I don't have your version of Crystal but in previous versions you use the File->Options menu. On the Database tab, within the Explorer Frame, set the desired options. They affect what you see in the Data Explorer screen.

You can also get to this Database options tab by clicking the Option button on the Data Explorer screen.