• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 345
  • 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.
0
zachms
Asked:
zachms
1 Solution
 
milindsaraswalaCommented:
You can get answer on this

http://www.mssqltips.com/tip.asp?tip=1357

check out and let us know.
0
 
p_nutsCommented:
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
0
 
zachmsAuthor Commented:
Worked great.
0
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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