Disappearing text boxes when exporting to PDF

I'm having a problem with text boxes disappearing when a report is exported
to PDF. Everything appears fine in the designer and in Report Manager, even
when exporting to Excel, but when the report is exported to PDF, a couple of
text boxes (one being a label above a table, and the other, next to the
label, shows a company name returned from a stored procedure) appear on some
pages of the report, but not on others. There is another text box label, and
another text box beside it which returns a company's branch name...this is
directly under the company name...this appears OK on the PDF. There are no
null/blank company names being returned in the dataset.
I created a test copy of the same report (from scratch) and exported it to
PDF. This time, the company name text boxes that were missing before appeared
OK, but went missing on other pages which were previously fine.
I've tried putting the text boxes into a rectangle, even a list, but to no
avail. I can't really see any pattern to the problem...the two copies of the
report are returning exactly the same data, but the company name text boxes
randomly disappear.
Can anyone shed some light on this problem? Is it a bug?
Thanks in advance.
--
Jadranka Krapic
DBA
Stargate Technologies
(www.stargatetech.com.au)Jadranka wrote:
<snip>
> I've tried putting the text boxes into a rectangle, even a list, but
> to no avail. I can't really see any pattern to the problem...the two
> copies of the report are returning exactly the same data, but the
> company name text boxes randomly disappear.
> Can anyone shed some light on this problem? Is it a bug?
> Thanks in advance.
The "export engines" as they are often called are black boxes and yes,
I think you are seeing evidence that the PDF export engine has defects.
I have "solved" similar problems through hours of fiddling redesign.
The PDF engine has problems with the widths of things, with things next
to each other horizontally, and don't ever overlap ReportItems by so
much as a single twip or you'll regret it.
Interesting that for you also there is no obvious consistent pattern to
what works and what does not, my experience precisely.
I have moaned and groaned about these issues for a week or two without
getting any meaningful answers from Microsoft support, sometimes
without getting any answers at all.
One hopes that SP2 will address these genuine showstopper issues. It's
one thing for members of an IT organization to put up with a
not-done-yet product like Microsoft SQL Reporting Services, quite
another for business users: they WON'T put up with it. They won't buy
solutions based on it. They will renege on deals already made because
of it. They are uninterested in WHY I can't do for them what needs
doing in a way that is useful to them, all they care about is that I
didn't do it as I said I would.
Under the gun but smiling, smiling, I am
Highly Obscure|||I can most definately relate to your experiences! If I weren't smiling
through it all, I reckon I'd be a basket-case!!
Speaking of smiling, the latest installment of this saga had me and the
senior DBA laughing...
Originally, the company name text box label had a location of 0cm, 0cm on
the list that it was sitting on. Thought I'd nudge everything down a little,
just so it wasn't at the very top of the list control. Exported it to
PDF...HEY PRESTO! A perfect PDF report! Go figure.
Still doesn't explain why previously some text box controls were appearing
on some pages and not on others, but I (and the customer) are happy with what
we've got now.
Jadranka.
"HighlyObscure" wrote:
> Jadranka wrote:
> <snip>
> >
> > I've tried putting the text boxes into a rectangle, even a list, but
> > to no avail. I can't really see any pattern to the problem...the two
> > copies of the report are returning exactly the same data, but the
> > company name text boxes randomly disappear.
> >
> > Can anyone shed some light on this problem? Is it a bug?
> >
> > Thanks in advance.
> The "export engines" as they are often called are black boxes and yes,
> I think you are seeing evidence that the PDF export engine has defects.
> I have "solved" similar problems through hours of fiddling redesign.
> The PDF engine has problems with the widths of things, with things next
> to each other horizontally, and don't ever overlap ReportItems by so
> much as a single twip or you'll regret it.
> Interesting that for you also there is no obvious consistent pattern to
> what works and what does not, my experience precisely.
> I have moaned and groaned about these issues for a week or two without
> getting any meaningful answers from Microsoft support, sometimes
> without getting any answers at all.
> One hopes that SP2 will address these genuine showstopper issues. It's
> one thing for members of an IT organization to put up with a
> not-done-yet product like Microsoft SQL Reporting Services, quite
> another for business users: they WON'T put up with it. They won't buy
> solutions based on it. They will renege on deals already made because
> of it. They are uninterested in WHY I can't do for them what needs
> doing in a way that is useful to them, all they care about is that I
> didn't do it as I said I would.
> Under the gun but smiling, smiling, I am
> Highly Obscure
>

Disabling 'Export to excel' option when record count >5000 in a re

Hi,
I have a report that has two drill downs that drill to about 5000 records
and due to this I am having time out problems while exporting to excel. For
now, we have worked around the timeout problem but what I would like to know
is whether or not there is a way to disable the excel option in the export
drop down list - only when the SQL report generates like more than 5000 rows.
The reason to disable being, the RS/RM is consuming CPU like crazy and its
repurcussions are unbearable.Hi,
The only thing you can do is to disable Excel export server wide. This you
can do in the RSReportServer.config and add Visible="false" to the element of
the Excel export.
Unfortunately it isn't possible to set it per report or even dynamic.
Jan Pieter Posthuma
"Jammer" wrote:
> Hi,
> I have a report that has two drill downs that drill to about 5000 records
> and due to this I am having time out problems while exporting to excel. For
> now, we have worked around the timeout problem but what I would like to know
> is whether or not there is a way to disable the excel option in the export
> drop down list - only when the SQL report generates like more than 5000 rows.
> The reason to disable being, the RS/RM is consuming CPU like crazy and its
> repurcussions are unbearable.|||"Jan Pieter Posthuma" <JanPieterPosthuma@.discussions.microsoft.com> wrote in
message news:B18CDAAB-35F2-4CA6-AC13-EC30640558EA@.microsoft.com...
> Hi,
> The only thing you can do is to disable Excel export server wide. This you
> can do in the RSReportServer.config and add Visible="false" to the element
> of
> the Excel export.
> Unfortunately it isn't possible to set it per report or even dynamic.
>
If you take a short peek into the generated script when you activate the
toolbar, you can create your own 'export' button with or without excel
export very easily (rs:format=EXCEL)
I modified the ReportViewer sample to display a small popup toolbar with:
export the Excel, PDF and Print on it (takes up way less space then the
standard toolbar)
Alfred|||Hey Alfred,
Can you tell me how you achieved creating your own export to excel bar:
Thanks
Balaji
"Smeenk, A.D." wrote:
> "Jan Pieter Posthuma" <JanPieterPosthuma@.discussions.microsoft.com> wrote in
> message news:B18CDAAB-35F2-4CA6-AC13-EC30640558EA@.microsoft.com...
> > Hi,
> >
> > The only thing you can do is to disable Excel export server wide. This you
> > can do in the RSReportServer.config and add Visible="false" to the element
> > of
> > the Excel export.
> >
> > Unfortunately it isn't possible to set it per report or even dynamic.
> >
> If you take a short peek into the generated script when you activate the
> toolbar, you can create your own 'export' button with or without excel
> export very easily (rs:format=EXCEL)
> I modified the ReportViewer sample to display a small popup toolbar with:
> export the Excel, PDF and Print on it (takes up way less space then the
> standard toolbar)
> Alfred
>
>|||"Balaji" <Balaji@.discussions.microsoft.com> wrote in message
news:29713B57-0C78-4AB9-B7BE-8E5234D59809@.microsoft.com...
> Hey Alfred,
> Can you tell me how you achieved creating your own export to excel bar:
>
Like I said, I modifed the ReportViewer sample, its (by default) installed
here:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\Samples\Applications\ReportViewer
I modified the properties and added 'small' to the ToolBar options, and when
selected I generate different code. I add an extra table around the iframe
and use a div to display a popup menu like when you hover over an image in
IE. The 'onclick' of the images activates a new window with the requested
export of the report (actually a re-render of the report I think, I didn't
add the session ID)
Alfred|||Instead of disabling export to Excel you might want to add a link at the top
of the page that says Export Data. Use jump to URL and specify CSV and ASCII
(the CSV export does Unicode and Excel doesn't handle unicode CSV). By
rendering in ASCII CSV Excel comes up automatically and this is very very
fast. I had an Excel export that took 5 minutes and brought the server to
its knees go to 10 seconds.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Smeenk, A.D." <alfreds@.dbs-at-nospam-at-nl> wrote in message
news:uX66yHuVFHA.2196@.TK2MSFTNGP09.phx.gbl...
> "Balaji" <Balaji@.discussions.microsoft.com> wrote in message
> news:29713B57-0C78-4AB9-B7BE-8E5234D59809@.microsoft.com...
>> Hey Alfred,
>> Can you tell me how you achieved creating your own export to excel bar:
> Like I said, I modifed the ReportViewer sample, its (by default) installed
> here:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\Samples\Applications\ReportViewer
> I modified the properties and added 'small' to the ToolBar options, and
> when selected I generate different code. I add an extra table around the
> iframe and use a div to display a popup menu like when you hover over an
> image in IE. The 'onclick' of the images activates a new window with the
> requested export of the report (actually a re-render of the report I
> think, I didn't add the session ID)
> Alfred
>|||"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23HdntxuVFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Instead of disabling export to Excel you might want to add a link at the
> top of the page that says Export Data. Use jump to URL and specify CSV and
> ASCII (the CSV export does Unicode and Excel doesn't handle unicode CSV).
> By rendering in ASCII CSV Excel comes up automatically and this is very
> very fast. I had an Excel export that took 5 minutes and brought the
> server to its knees go to 10 seconds.
>
That 'export to CSV' should 'officially' be on the right-click menu when you
view a table layout report part, now for some reason that does not function
on all machines... any idea's?
Yes same report, all machines Windows XP SP2, IE 6.
With one person the option re-appeared after a reset of the local intranet
security to default...
Alfred|||No idea about that. Note that the export to CSV you are talking about
exports as Unicode and Excel will bring it all together in a single column.
Bruce L-C
"Smeenk, A.D." <alfreds@.dbs-at-nospam-at-nl> wrote in message
news:OFAlFu4VFHA.1452@.TK2MSFTNGP14.phx.gbl...
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%23HdntxuVFHA.2664@.TK2MSFTNGP15.phx.gbl...
>> Instead of disabling export to Excel you might want to add a link at the
>> top of the page that says Export Data. Use jump to URL and specify CSV
>> and ASCII (the CSV export does Unicode and Excel doesn't handle unicode
>> CSV). By rendering in ASCII CSV Excel comes up automatically and this is
>> very very fast. I had an Excel export that took 5 minutes and brought the
>> server to its knees go to 10 seconds.
> That 'export to CSV' should 'officially' be on the right-click menu when
> you view a table layout report part, now for some reason that does not
> function on all machines... any idea's?
> Yes same report, all machines Windows XP SP2, IE 6.
> With one person the option re-appeared after a reset of the local intranet
> security to default...
> Alfred
>|||Why don't you increase the timeout?
Farahmand
"Jammer" wrote:
> Hi,
> I have a report that has two drill downs that drill to about 5000 records
> and due to this I am having time out problems while exporting to excel. For
> now, we have worked around the timeout problem but what I would like to know
> is whether or not there is a way to disable the excel option in the export
> drop down list - only when the SQL report generates like more than 5000 rows.
> The reason to disable being, the RS/RM is consuming CPU like crazy and its
> repurcussions are unbearable.|||Why don't you increase the timeout?
Farahmand
"Jammer" wrote:
> Hi,
> I have a report that has two drill downs that drill to about 5000 records
> and due to this I am having time out problems while exporting to excel. For
> now, we have worked around the timeout problem but what I would like to know
> is whether or not there is a way to disable the excel option in the export
> drop down list - only when the SQL report generates like more than 5000 rows.
> The reason to disable being, the RS/RM is consuming CPU like crazy and its
> repurcussions are unbearable.

Disable printing / exporting

Anyone of you friends.. / MODERATORS

This is a hake of a challenge .. looks like Microsoft again left some "bug" in their SSRS..

Can anyone help me to know if I can "Hide" print icon on SSRS toolbar control .. ? or say

Remove TIFF /Excel from Export drop down list?

Sam

As far as the printing, here's how we do it (as the printing ActiveX control usually foobars on us, doesn't work except in IE under Windows and even then most of our clients are companies who lock down adding more activeX controls, it just makes more sense to tell them to do a Excel/PDF export...):

Add the ShowPrintButton property to the rsweb:Reportview tag in your .aspx source. Like:

<rsweb:ReportViewerHeight="450px"ID="ReportViewer1"runat="server"Width="100%"processingmode="Remote"SizeToReportContent="True"ShowPrintButton="false" />

I don't know how to limit the export options, though.

|||

http://servername/ReportServer?%2fReportFolder%2fReportName&Parameter1=&Parameter2=&rs%3aClearSession=true&rs%3aFormat=HTML4.0&rs%3aCommand=Render&rc%3aArea=Report&rc%3aLinkTarget=_top&rc%3aJavaScript=True&rc%3aToolbar=False

You could hide the toolbar completely such as in the example above.

Disable exporting in RS

Hi,

I would like to know if it is possible to disable the exporting option for individual reports in Reporting Services. I have seen a post explaining how to disable it for all reports (editing the config file on the reportserver) but the problem in my case is that I still need my users to have the exporting option for a majority of the reports. There are only a few reports that I need to disable this option for. Does anyone know if this is possible?

Thanks in advance

No it is not possible without writing your own UI.

I would like to understand the scenario more. Why would you want to allow users access to some of the reports only in a particular format?