Crystal Reports

Re: Easy Formula Question

WanderingEye — Thu, 02 Jul 2009 01:34:07 GMT

Got it.....Create a formula:

If ToText({table.DateFiled}) <> "" Then

"text string"

Else

Drag the formula into the textbox.

Re: Easy Formula Question

WanderingEye — Wed, 01 Jul 2009 21:04:20 GMT

Aderegil - thanks for the reply. Let me explain a little more just to be sure we're on the same page.

I have a date field that is filled from the DataSet. I also have a text object that has no corresponding record. If the database field for date is not null I want to supply a static string value to the text object.

Can this be handled through a Formula? It appears your solution deals with DB fields only.

Re: Easy Formula Question

aderegil — Wed, 01 Jul 2009 20:49:36 GMT

Hello WanderingEye:

One option is to delegate that responsability to the data source and on the Crystal Reports just expect a field with exactly the info that you will put on the text object.

I do not know the details about your field but you can usually choose between the two values with a CASE statement in your query:

SELECT

CASE LEN(TheColumn)

WHEN 0 THEN ''

ELSE 'Static text'

END AS NewColumn

FROM ...

Your NewColumn field will always have the correct text to be assigned to your text object.

Easy Formula Question

WanderingEye — Wed, 01 Jul 2009 19:41:05 GMT

Hey all,

Quick question. On a Crystal Report I need to fill a text object based on a Report Field. For example, I have 2 fields 1 populates from the DataSet the other is just a text object. If the dataset field contains a date populate the text object with a static text string.

There has to be an easy way to do this - right?

Thanks!