• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 342
  • Last Modified:

SQL server 2008 report design question

I am working on a report in sql server 2008 using the report designer 2.0.  What I want to do is have an option of either including a chart or not.  Currently when you choose this report it asks for a date range and then will produce the results with the charts included.  I would like to have a third option before displaying any results as to show the charts or not.  I hope this is possible.  Please ask questions if needed for clarification.
1 Solution
You can get answer on this


check out and let us know.
basically you can create a parameter and use that to set visibility to true or false

something like iif(parameters!showGraph.value="yes",false,true)

you put that in the graph property where it says visibility

if you wanna do a group of items use a rectangle to group them
zachmsAuthor Commented:
Worked great.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now