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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formula error

Status
Not open for further replies.

Chrillef

Programmer
Joined
Jan 16, 2003
Messages
7
Location
SE
Hi

Can anyone help me with what is wrong with my formula.
It is not creted as a SQL formula, just Crystal formula.

select {MAINTENT_1.ID} where
{MELINK.DTEND_DATE} = Date (3000, 12, 31);

The date format may look funny but this is taken straight from the DB so the error is probably that some (( or )))are missing. I have tested and tested but Iäm not a proper programmer so I just don't get it right.

Thanks in advance
 
Chrillef,

Crystal formulas are not formatted this way.

I have two interpretations of what you are trying to do so I will post to both:

(1) You are trying to filter the data for {MAINTENT_1.ID} where the date = date given.

To select the id where the date = your odd date field then in the select expert you would do:

{MELINK.DTEND_DATE} = Date (3000, 12, 31)

and would get the field

{MAINTENT_1.ID} by placing it on the report.

(2) You want to "print" the {MAINTENT_1.ID} if the date = your date field:

If {MELINK.DTEND_DATE} = Date (3000, 12, 31)
then {MAINTENT_1.ID}

I hope that helps,

ro Rosemary Lieberman
rosemary@microflo.com, Microflo provides expert consulting on MagicTSD and Crystal Reports.
 
Hi

Thanks for the help I tried the second solution but I get the same message. The first doesn't work I tried that before.

What I want do is to show maintent_1.id that has a melink.dtend_date that is equal to xxxxxx.
The melink.dtend_date can be of various dates but I want to show the maintent_i.id that has a specific date.
This is in a subreport. And I have other maintent fields on other places so that is why I need this formula and not a selection.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top