I have 2 graphs that need to display depending on a prompt selection my Crystal report. How can I hide a graph depending on a report prompt selection ?
gogo (BOB member since 2005-06-03)
Hi.
Use the Suppress property of the chart object with a conditional formula. It depends on how you built your parameter field, but the supress formula could be:
{?Hide Chart Y or N} = “Y”
lgonzalez (BOB member since 2002-07-17)
Thanks for your reply. I am new to Crystal report could you please expand on this ?
I thought the suppress function was only to hide data within a graph conditionally but not the whole graph.
My prompt is created named Product and the graph is created but not sure what else needs to be done around the suppress function.
gogo (BOB member since 2005-06-03)
Hi.
A chart, like a field, is also an object, and it has a Suppress check box which, if enabled, suppresses the chart from displaying on the report regardless of whether it can show data. The Suppress box has next to it a conditional format button into which you enter a formula to suppress the chart only if it meets a certain condition, like the value entered for the prompt is equal to “Y”.
lgonzalez (BOB member since 2002-07-17)