Block level filter in Crystal report

building reports crystal reports
1

Is there a way in Crystal report to apply block level filters the same way as in Webi.
For example I run a report with a prompt that says Town = ‘Dallas’ I need to then get my report to display Graph 1 and hide graph 2 from my report.
If the user select Town = ‘Seattle’ I then need Graph 2 to be displayed and hide graph 1.

How can I do that in Crystal reports ?

Cheers

gogo (BOB member since 2005-06-03)

2

use the value of the prompt ie: Dallas in a X+2 conditional format formula

  1. create the prompt (I assume you did this already)
  2. create a formula
    if @prompt = ‘Dallas’ then true
    else false
  3. use the formula in the Suppress attribute of the chart

dglinka :us: (BOB member since 2004-11-12)