Print Layout feature showing black

Today I received a Windows Update that included SQL 2005 SP2. Since
that time whenever I try to use the "Print Layout" feature in
Reporting Services, it shows nothing but black. Does anyone know of a
fix for this?Here you go: http://support.microsoft.com/kb/935356/en-us
This is the new cumulative update that should fix your issue. You'll need
to follow the steps on the page to request the fix.
This is one of the bugs fixed:
50001105 After you apply SQL Server 2005 SP2, the Print Preview feature in
Reporting Services may show a solid black page.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: cphite@.gmail.com
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: Print Layout feature showing black
> Date: Thu, 04 Oct 2007 13:17:24 -0700
> Today I received a Windows Update that included SQL 2005 SP2. Since
> that time whenever I try to use the "Print Layout" feature in
> Reporting Services, it shows nothing but black. Does anyone know of a
> fix for this?
>|||On Oct 4, 4:52 pm, cal...@.online.microsoft.com (Chris Alton [MSFT])
wrote:
> Here you go:http://support.microsoft.com/kb/935356/en-us
> This is the new cumulative update that should fix your issue. You'll need
> to follow the steps on the page to request the fix.
Thanks, Chris - that worked perfectly.|||Great. You wern't the only person I've seen that had that problem.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: cphite@.gmail.com
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: Re: Print Layout feature showing black
> Date: Fri, 05 Oct 2007 07:56:08 -0700
> Organization: http://groups.google.com
> On Oct 4, 4:52 pm, cal...@.online.microsoft.com (Chris Alton [MSFT])
> wrote:
> > Here you go:http://support.microsoft.com/kb/935356/en-us
> >
> > This is the new cumulative update that should fix your issue. You'll
need
> > to follow the steps on the page to request the fix.
> Thanks, Chris - that worked perfectly.
>

Print icon not showing up in RS

Has anyone ever seen the print icon not show up in the top toolbar in
Reporting Services? Normally, the print icon shows between the refresh
button and the help button. We saw one instance where the print icon
was not showing: it was just the refresh and help button together. Does
anyone know what could cause this? Is this security related? Thanks.
JustinMy guess is the user of the PC is not in the administrator's group (local
administrators group) and the activeX control is not getting installed.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<jdyer521@.hotmail.com> wrote in message
news:1142869367.565307.13420@.j33g2000cwa.googlegroups.com...
> Has anyone ever seen the print icon not show up in the top toolbar in
> Reporting Services? Normally, the print icon shows between the refresh
> button and the help button. We saw one instance where the print icon
> was not showing: it was just the refresh and help button together. Does
> anyone know what could cause this? Is this security related? Thanks.
> Justin
>

Print button not showing in Firefox -- ReportViewer control

Hi, I'm having a problem with the ReportViewer control (Reporting Service 2005) in Firefox. Neither the print button nor the Search box are showing up, even when I explicitly set them to be visible. They are showing up fine in IE.

Anyone else had this problem?

When you look at the HTML source, it's clear why it is not showing up. The following code does not even appear in the Firefox version (most important part in bold):

<table cellpadding="0" cellspacing="0" ToolbarSpacer="true" style="display:inline;">
<tr>
<td style="width:20px;"></td>
</tr>
</table>

<div id="RptView_ctl01_ctl07" style="display:inline;font-family:Verdana;font-size:8pt;height:30px;">
<table cellpadding="0" cellspacing="0" style="display:inline;">
<tr>
<td height="28px"><div id="RptView_ctl01_ctl07_ctl00">
<table id="RptView_ctl01_ctl07_ctl00_ctl00" onmouseover="HoverImageRptView_ctl01_ctl07_ctl00_ctl00.OnHover();" onmouseout="HoverImageRptView_ctl01_ctl07_ctl00_ctl00.OnNormal();" title="Print" style="display:none;">
<tr>
<td><input type="image" name="RptView$ctl01$ctl07$ctl00$ctl00$ctl00" src="http://pics.10026.com/?src=/MandateMaker/Reserved.ReportViewerWebControl.axd?OpType=Resource&Version=8.0.50727.42&Name=Icons.Print.gif"onclick="ClientToolbarRptView_ctl01.LoadPrintControl();return false;" style="height:16px;width:16px;border-width:0px;padding:2px;" /></td>
</tr>
</table><script>
HoverImageRptView_ctl01_ctl07_ctl00_ctl00.OnNormal();
</script><table id="RptView_ctl01_ctl07_ctl00_ctl01" onmouseout="HoverImageRptView_ctl01_ctl07_ctl00_ctl01.OnNormal();" title="Print" style="display:inline;">
<tr>
<td><img src="http://pics.10026.com/?src=/MandateMaker/Reserved.ReportViewerWebControl.axd?OpType=Resource&Version=8.0.50727.42&Name=Icons.Print.gif" alt="Print" style="border-width:0px;" /></td>
</tr>
</table><script>
HoverImageRptView_ctl01_ctl07_ctl00_ctl01.OnNormal();
</script>
</div></td>
</tr>
</table>
</div>

<iframe id="PrintFrameRptView_ctl01_ctl07" src="http://pics.10026.com/?src=javascript:''" style="display:none;"></iframe>

Is the "print control" IE-only?

|||I believe that the print controler is an active x controler and that firefox does not suport active x. so yeah the print control would appear to be IE only. however you might be able to find a plugin for firefox that would allow you to run active x|||

Actually, the Microsoft documentation says certain things do not work in non-IE browsers, but the print button is not one of them.

Honest to God, I think Microsoft is just lazy or arrogant sometimes. It's not THAT hard to get printing from a non-IE browser to work. I was able to do it when I had my own custom page to display Reporting Service reports. If I can do it, surely the well-paid gurus at Microsoft can do it!

Grrrrr....I may have to put in code to generate my old custom stuff for non-IE browsers. My custom page does not work as well as the Report Viewer control, so I really would rather not do that.

|||Yeah, it's because they implemented it as an ActiveX control, which is totally the wrong direction to be heading. Microsoft should be moving away from ActiveX since other browsers don't support it (although I think there is a plug-in that allows Firefox to use at least some ActiveX controls). Plus it is a major focal point for security exploits and bugs, it would be better if it was removed from the browser environment entirely.

cs|||

CynthiaD wrote:

Actually, the Microsoft documentation says certain things do not work in non-IE browsers, but the print button is not one of them.

Honest to God, I think Microsoft is just lazy or arrogant sometimes. It's not THAT hard to get printing from a non-IE browser to work. I was able to do it when I had my own custom page to display Reporting Service reports. If I can do it, surely the well-paid gurus at Microsoft can do it!

Grrrrr....I may have to put in code to generate my old custom stuff for non-IE browsers. My custom page does not work as well as the Report Viewer control, so I really would rather not do that.

Hi Cynthia - I know what you are feeling. I moved over most of my clients to LGX Report (www.logixml) because of that issue and similar ones. For most of my clients IE only is not a solution that works. The Logi product is zero footprint and integrates easily with ASP.NET applications. It's also free, but I have one client who needed more features available on their paid version.

Good luck

Steve

|||

Hi,

In my case the print icon is not displayed in the report viewer viewed through the IE.(in the client server)

But able to see the same in our local network

|||Probably security. You are probably allowed to use ActiveX controls in a trusted site (your network), but outside of that the security restrictions prevent using ActiveX controls. If they add your site to the trusted sites in the IE security area, they will likely be able to see the print button. Just my hunch.

cssql

Preview pane not showing data

I have a problem within the Report Designer in Visual Studio .NET. I a new
report, I define a dataset that returns data via a SQL query fine. I design
the report without issues, but when I try to preview the report, no data is
displayed.
This error seems to have occured after applying reporting services SP1 to my
machine. No errors are reported, and nothing appears in the event log.
Any ideas as to how I can correct this problem out there?
Thanks in advance.
MattIs there an .rdl.data file in the same directory as your .rdl file? If so, delete it and try again.
Also, does hitting the Refresh button in the preview pane have any effect?
--
Thanks.
Donovan R. Smith
Software Test Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
"Matt Pothier" <Matt.Pothier@.sonepar-us.com> wrote in message
news:eEtr8WvfEHA.596@.TK2MSFTNGP11.phx.gbl...
> I have a problem within the Report Designer in Visual Studio .NET. I a new
> report, I define a dataset that returns data via a SQL query fine. I design
> the report without issues, but when I try to preview the report, no data is
> displayed.
> This error seems to have occured after applying reporting services SP1 to my
> machine. No errors are reported, and nothing appears in the event log.
> Any ideas as to how I can correct this problem out there?
> Thanks in advance.
> Matt
>|||Thanks for the response. There were .rdl.data files in the same directory.
I tried deleting them, but got the same results. The refresh button did not
help either.
In a moment of frustration I uninstalled reporting services; performed a
repair install on VS .Net, reinstalled Reporting services; applied the
service pack and started over again. Everything seems to be working now.
"Donovan R. Smith [MSFT]" <donovans@.online.microsoft.com> wrote in message
news:%23iGKIuvfEHA.3556@.TK2MSFTNGP12.phx.gbl...
> Is there an .rdl.data file in the same directory as your .rdl file? If
so, delete it and try again.
> Also, does hitting the Refresh button in the preview pane have any effect?
> --
> Thanks.
> Donovan R. Smith
> Software Test Lead
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Matt Pothier" <Matt.Pothier@.sonepar-us.com> wrote in message
> news:eEtr8WvfEHA.596@.TK2MSFTNGP11.phx.gbl...
> > I have a problem within the Report Designer in Visual Studio .NET. I a
new
> > report, I define a dataset that returns data via a SQL query fine. I
design
> > the report without issues, but when I try to preview the report, no data
is
> > displayed.
> >
> > This error seems to have occured after applying reporting services SP1
to my
> > machine. No errors are reported, and nothing appears in the event log.
> >
> > Any ideas as to how I can correct this problem out there?
> >
> > Thanks in advance.
> >
> > Matt
> >
> >
>