Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Shared DateVar Formula Issue

Status
Not open for further replies.

CappsRLO

Vendor
Apr 18, 2007
31
US
Crystal 8.5
Previous Formula:
If IsNull({SubmittalRegister.SubmittalRegister~DueDate}) Then 0 Else 1

In the previous formula I was using an actual field in the MAIN report. Now we want to use a Shared DateVar from a SubReport but it won't let me use it in a IsNull

New Formula:
Shared DateVar DueDateVar;
If IsNull(DueDateVar) Then 0 Else 1

Error Received: A field is required here (cursor blinking for the DueDateVar)
 
Please explain your solution so others an benefit.

-LB
 
Correct Formula:
Shared DateVar DueDateVar;
If IsNull(@DueDateVar) Then 0 Else 1

I manually typed in 'DueDateVar' whereas if I inserted the field from the field chooser it is actually '@DueDateVar'
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top