Have Chart displayed but want tables when printing

Question

I don't know if this is possible but I thought I would ask.
I have create a chart Report/dashboard. When it runs it displays the data in a bar chart. What I would like is when the user prints this Report/Dashboard the print out will not have the bars on it but look like an ordinary report with tables on it.

Is this possible? If so please let me know how.
Thanks

Answer 1

Hello Mutlyp,

I don't think it is possible to do while printing but you can apply work around and can make it possible.

In Report, Create a Parameter name 'Display or Print' and can give 2 values one Display and another Print.

Based on value display report should display only 'Charts' and It should hide tables and when user select Print, It should hide charts and display only tables.

and when it is displaying tables user can print that. 

---

Thanks Shiven:) If Answer is Helpful, Please Vote

Answer 2

Hi mutlyp,

Per my understanding that you want to hide the bar chart after you print the report, right?

I have tested on my local environment and that S Kumar Dubey have provided an very good solution. If your SQL Server version is 2008 R2 or higher you can also take reference of another method below.

This method is use the expression to show/hide the chart in the report, when you print/ export the report it will hide, only when you preview in the designer or view the report in report manager/report server you can see the chart.

Details information below for your reference:

1. Right click the chart and select the "Chart Properties"
2. Check the "Visibility" on the left pane and check the "Show or hide base on an Expression"
   Expression:
   =iif(Globals!RenderFormat.IsInteractive,False,True)

You can choose either of the method based on your requirements.

If you have any problem, please feel free to ask.

Regards
Vicky Liu