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

Hiding table columns creates solid black columns in PDF

Hello all,

I am having a slight problem when dynamically hiding columns in a data table.

When I use the set the "Hidden" property to true, I seem to end up with a solid black column on the far right of the report... but only when generating the report as a PDF.

I've searched the internet quite a bit trying to track down the issue, but I can't seem to find anything.

Has anyone encountered this problem before? Suggestions?

Thanks,

David

check the background color

it should be transperant

|||

All the cells and columns are set to have a background of transparent

no luck :(

|||Anyone else have any thoughts on this problem?|||

ur best bet would be to hide table row itself rather than just hiding a column and u can give a condition instead of just setting the hidden column to true.

Hiding Other options from Format Drop down in Report Viewer Control

Hi All
We have requirement where we need to hide some of the options which we have in Format drop down i.e we need only CSV,PDF and excel .
How can we do this?
Thanks in advance
Rehan Mustafa Khan
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.To disable export to a particular rendering format, add the string
Visible="false" to the end of the rendering extension entry in
%PROGRAMFILES%\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config file. For example, to disable
Excel from showing up in the Export dropdown in report manager, change
<Extension Name="EXCEL"
Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Micr
osoft.ReportingServices.ExcelRendering"/>
to
<Extension Name="EXCEL"
Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Micr
osoft.ReportingServices.ExcelRendering" Visible="false"/>
Note that disabling a rendering extension does not prevent users from
rendering to those extensions using SOAP API or use URL access to reports
like so:
http://localhost/reportserver?%2fSampleReports%2fCompany+Sales&rs:Command=Render&rs:Format=EXCEL
If you want to remove the rendering extension completely, just delete the
corresponding line from the <Render> section of the config file (in which
case URL access like shown above will throw rsRenderingExtensionNotFound
exception.)
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:uDqFX7%23YEHA.1264@.TK2MSFTNGP11.phx.gbl...
> Hi All
> We have requirement where we need to hide some of the options which we
have in Format drop down i.e we need only CSV,PDF and excel .
> How can we do this?
> Thanks in advance
> Rehan Mustafa Khan
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.|||Hi Ravi,
I tried ur Suggestion.Not Sure Y its not working for me'
Can u Plz Guide where im going wrong'
My Code is
<Extension Name="XML"
Type="Microsoft.ReportingServices.Rendering.XmlDataRenderer.XmlDataReport,Microsoft.ReportingServices.XmlRendering" Visible="false"//>
<Extension Name="NULL"
Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsoft.ReportingServices.NullRendering"Visible="false"/ >
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering" Visible="false"/>
<Extension Name="IMAGE"
Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport,Microsoft.ReportingServices.ImageRendering"Visible="false"/>
<Extension Name="PDF"
Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsoft.ReportingServices.ImageRendering"Visible="false"/>
<Extension Name="HTML4.0"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRendering"Visible="false"/>
<Extension Name="HTML3.2"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html32RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>
<Extension Name="MHTML"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExtension,Microsoft.ReportingServices.HtmlRendering"Visible="false"/>
<Extension Name="EXCEL"
Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"Visible="false"/>
<Extension Name="HTMLOWC"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.HtmlOWCRenderingExtension,Microsoft.ReportingServices.HtmlRendering"Visible="false"/>
Im waiting for ur response,
Thanks in Advance,
"Ravi Mumulla (Microsoft)" wrote:
> To disable export to a particular rendering format, add the string
> Visible="false" to the end of the rendering extension entry in
> %PROGRAMFILES%\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\RSReportServer.config file. For example, to disable
> Excel from showing up in the Export dropdown in report manager, change
> <Extension Name="EXCEL"
> Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Micr
> osoft.ReportingServices.ExcelRendering"/>
> to
> <Extension Name="EXCEL"
> Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Micr
> osoft.ReportingServices.ExcelRendering" Visible="false"/>
> Note that disabling a rendering extension does not prevent users from
> rendering to those extensions using SOAP API or use URL access to reports
> like so:
> http://localhost/reportserver?%2fSampleReports%2fCompany+Sales&rs:Command=Render&rs:Format=EXCEL
> If you want to remove the rendering extension completely, just delete the
> corresponding line from the <Render> section of the config file (in which
> case URL access like shown above will throw rsRenderingExtensionNotFound
> exception.)
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
> news:uDqFX7%23YEHA.1264@.TK2MSFTNGP11.phx.gbl...
> > Hi All
> >
> > We have requirement where we need to hide some of the options which we
> have in Format drop down i.e we need only CSV,PDF and excel .
> >
> > How can we do this?
> >
> > Thanks in advance
> >
> > Rehan Mustafa Khan
> >
> > --
> > Posted using Wimdows.net NntpNews Component -
> >
> > Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
> supports Post Alerts, Ratings, and Searching.
>
>