Skip to main content
C
Cozmo2
Inspiring
July 9, 2014
Question

Print When with two conditions

  • July 9, 2014
  • 2 replies
  • 500 views

I only want to print a page if two conditions are met. On each section I am using the following Print When Condition:

DateFormat(query.asofdate, "mm/dd/yyyy") NEQ DateFormat(calc.AmtDate, "mm/dd/yyyy")  AND LSNumberFormat((query.bal + calc.anticipated), "_.__") LTE LSNumberFormat(25.00, "_.__").

The date check works great by itself and the amount check works great by itself but I can't get them to work together. Any ideas?

I am using CF10.

This topic has been closed for replies.

2 replies

C
Cozmo2Author
Inspiring
July 11, 2014

That fixed the problem Thanks!

Is there anyway I can apply this to the whole page and not have to add it to every sections 'Print When Condition'?

EddieLotter
EddieLotter
Inspiring
July 14, 2014

Cozmo2 wrote:

That fixed the problem Thanks!

Is there anyway I can apply this to the whole page and not have to add it to every sections 'Print When Condition'?

One way would be to exclude records that meet those conditions. That way you would not need to take them into account in your report.

EddieLotter
EddieLotter
Inspiring
July 10, 2014

If the field types are explicit, then you don't need to format them as strings before comparing them.

What happens if you try the following expression?:

( (query.asofdate NEQ calc.AmtDate) AND (query.bal + calc.anticipated LTE 25.00) )

Firefly Community Gallery
Adobe Firefly

Remix with Firefly Community Gallery

Thousands of free creations to fall in love with and remix in Firefly.

Explore now
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices