Conditional Print Expression

[SkyRider]

Hi,

I can't get the Conditional Print Expression in Report Builder working. Could anyone please give me an example of an expression that would print a field only when page number is greater than 1 (or any other expression that would work). I've tried quite a few, but the condition never seems to be true.
One more different question is, if it's possible to set some arguments when calling a report from a macro, so that the report is not created read-only.
Thank you

[DrewJensen]

I believe that is a bug with the Report Builder extension in versions 1.0.1 and less - It may be fixed in 1.0.2 ( to be released simultaneously with OOo 2.4 - so this week sometime most likely )

Anyway - I'll be doing some testing later tonight and give that a whirl with 2.4 RC6 and Report Builder 1.0.2.

I'll post here how it goes - if it works I'll put up an example and it not - a link to the Bug report...

[SkyRider]

Hi Drew,

Did you have a chance to take a look at this?

I've installed 2.4 and also Report Builder 1.0.2. (though probably not official release, from ftp.linux.cz), but still no luck getting the conditional print expressions working... starting to believe the fault is between my chair and keyboard.

One more thing I'm not sure works as expected is, when on report's General tab I select 'Page header' - 'Not With Report Header' it doesn't print Page header on Report header page (which is expected of course), but also doesn't print any detail data on that page... i.e. it only prints Report header by itself... but that might be by design.

Any ideas? Thanks.

[Ant]

I can't get it to work either, but I can't find out what constitues an expression.

Is it SQL?, Basic, something else?

All I want to do is stop a label printing when the adjoining field is empty, pretty simple.

[goodvibes]

Code: Select all

NOT([Ingredient]  = "COMMENT")

works to make a field invisible when [Ingredient] = "COMMENT" in Oracle Report Builder 1.2.1

[carolkn]

Code: Select all

([Note]<>NULL())

works nicely, too.