Showing posts with label export. Show all posts
Showing posts with label export. Show all posts

Tuesday, March 27, 2012

HLP! PDF headings suddenly squished

I had a report that was working fine ... and now suddenly when it renders it
looks fine but if I export to pdf it squishes up the headings on the table.
All I can think of that changed is that I am showing or hiding table based on
the value of a field (this expression on the visibility for table =IIF(SUM(
Fields!Downtime.Value) > 0, False, True). AND I am showing or hiding a doc
map based on that same expression. This is very odd If the report werent so
complex I would just delete and re-create again. Any suggestions
appreciated!!This was fixed with SP2 which I now have
"MJT" wrote:
> I had a report that was working fine ... and now suddenly when it renders it
> looks fine but if I export to pdf it squishes up the headings on the table.
> All I can think of that changed is that I am showing or hiding table based on
> the value of a field (this expression on the visibility for table =IIF(SUM(
> Fields!Downtime.Value) > 0, False, True). AND I am showing or hiding a doc
> map based on that same expression. This is very odd If the report werent so
> complex I would just delete and re-create again. Any suggestions
> appreciated!!sql

Friday, February 24, 2012

Hiding PRINT and EXPORT buttons/links

Is there a way to hide the PRINT and Export buttons of the Toolbar? I still
want to show page navigation etc.I have figured out you have to use the stylesheet.
"Sammy" wrote:
> Is there a way to hide the PRINT and Export buttons of the Toolbar? I still
> want to show page navigation etc.|||I have the same exact issue. Can you give me more detail about what you did
with the stylesheet? Thanks.
--
-RB
:)
"Sammy" wrote:
> I have figured out you have to use the stylesheet.
> "Sammy" wrote:
> > Is there a way to hide the PRINT and Export buttons of the Toolbar? I still
> > want to show page navigation etc.|||if you followed the default installation, there should be a FOLDER called
Styles in the directory
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer
Look for HtmlViewer.css. Make a copy before you continue. Change the
display property of the relevant items to "none"
eg
.ToolbarExport
{
display: none;
}
.ToolbarPrint
{
display: none;
}
Save it as a new file eg MyViewer.css
To access the report thru a link include
rc:StyleSheet=MyViewer (NOTE there is no css)
To Deploy:
be sure you include the new css you folder and Deploy it if you are finally
running from a deployment site. It will (should) work from your development
environment if you don't include it in your project.
"capricorn" wrote:
> I have the same exact issue. Can you give me more detail about what you did
> with the stylesheet? Thanks.
> --
> -RB
> :)
>
> "Sammy" wrote:
> > I have figured out you have to use the stylesheet.
> >
> > "Sammy" wrote:
> >
> > > Is there a way to hide the PRINT and Export buttons of the Toolbar? I still
> > > want to show page navigation etc.

Hiding elements for print and export

Is it possible to suppress the output of certain report elements when the report is printed or exported? I want a particular image element that has a hyperlink to be visible when the report is viewed within RS's ReportViewer, but don't want it to show up on the printed or exported file. I figure, if this is even possible, the most obvious methods would be either:

1. Put the element in the page header or footer, then set up the page header or footer to not show up on the printed or exported report.

2. Put the element anywhere on the report, and set it to hidden when the report is printed or exported.

Are either of these possible? If not, is there another way to accomplish this?

Thanks,
DonThere is no way to do this. You can however write your own rendering extension in which you have full control over how to render the report.