null display

[Hellopin]

i am using isNull in if else but and putting the formula in displayString still there is no output

 

[synapsevampire]

Post your formula...

Try something like:

If isnull({table.field}) then
"Null"
Else
{table.field}

Note that the isnull check must come first.

-k

 

[Hellopin]

yes i am doing the same but no output it would be great if you can help me

 

[kskid]

As SV said, please post your formula... Could be something else that may be causing the problem

 

[Hellopin]

this is the formula written in Display String or let me know where to place the formula there is no output at all

if isNull({TASKS.WOTYPE3})
or
trim({TASKS.WOTYPE3})="" then
"Null"
else
{TASKS.WOTYPE3}

 

[synapsevampire]

What does "yes i am doing the same but no output it would be great if you can help me" mean?

I assume Display String the name of your formula?

Place the formula in the report wherever you would have placed the field.

Think punctuation...

-k

 

[Hellopin]

nope i have the formula in Format--Display string so where exactly i should place it i have the data to be pulled in Group header

 

[Hellopin]

i got it but one question can i place that formula instead group header

Thnaks a lot

 

[synapsevampire]

In the field explorer right click Formulas and select New.

Then you'll use that formula in the report after you create it.

-k

 

[Hellopin]

i got the outout but my summary value changes as i display formula in group header and delete the groupheader value

please let me know what should i do to get value and summary correct

 

[synapsevampire]

There appears to be a language barrier involved, so you might be better served to use some visual aids.

Try showing an example of the report layout (group and other sections used), example data, and expected output.

If you say something changes, state how it has changed and provide examples, your descriptions aren't going to serve us well.

-k