Formula error

[Chrillef]

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

 

[rosemaryl]

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,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[Chrillef]

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.