Friday, March 30, 2012

Receiving garbage in excel when rendered via Subscription

Hi,
I set up a standard subscription and am rendering the report to excel.
After recieving the email, I open the excel report and it displays a bunch of
garbage. Is there a known issue or a patch out for this?Did you install the SQL 2000 Reporting Services SP1?
"clutch" <clutch@.discussions.microsoft.com> wrote in message
news:3C59803E-CAB9-4BEC-BA2A-A5E90A0B21B2@.microsoft.com...
> Hi,
> I set up a standard subscription and am rendering the report to excel.
> After recieving the email, I open the excel report and it displays a bunch
> of
> garbage. Is there a known issue or a patch out for this?|||Yes, we have.
"Sal Young" wrote:
> Did you install the SQL 2000 Reporting Services SP1?
>
> "clutch" <clutch@.discussions.microsoft.com> wrote in message
> news:3C59803E-CAB9-4BEC-BA2A-A5E90A0B21B2@.microsoft.com...
> > Hi,
> >
> > I set up a standard subscription and am rendering the report to excel.
> > After recieving the email, I open the excel report and it displays a bunch
> > of
> > garbage. Is there a known issue or a patch out for this?
>
>|||What email system is being used for delivery (I know there has been some
issue with Lotus for example).
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"clutch" <clutch@.discussions.microsoft.com> wrote in message
news:0469D6D0-9A84-4BF5-B927-2308CB81F882@.microsoft.com...
> Yes, we have.
> "Sal Young" wrote:
> > Did you install the SQL 2000 Reporting Services SP1?
> >
> >
> > "clutch" <clutch@.discussions.microsoft.com> wrote in message
> > news:3C59803E-CAB9-4BEC-BA2A-A5E90A0B21B2@.microsoft.com...
> > > Hi,
> > >
> > > I set up a standard subscription and am rendering the report to excel.
> > > After recieving the email, I open the excel report and it displays a
bunch
> > > of
> > > garbage. Is there a known issue or a patch out for this?
> >
> >
> >|||Our email system is Novell GroupWise 6.5.
"Bruce L-C [MVP]" wrote:
> What email system is being used for delivery (I know there has been some
> issue with Lotus for example).
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "clutch" <clutch@.discussions.microsoft.com> wrote in message
> news:0469D6D0-9A84-4BF5-B927-2308CB81F882@.microsoft.com...
> > Yes, we have.
> >
> > "Sal Young" wrote:
> >
> > > Did you install the SQL 2000 Reporting Services SP1?
> > >
> > >
> > > "clutch" <clutch@.discussions.microsoft.com> wrote in message
> > > news:3C59803E-CAB9-4BEC-BA2A-A5E90A0B21B2@.microsoft.com...
> > > > Hi,
> > > >
> > > > I set up a standard subscription and am rendering the report to excel.
> > > > After recieving the email, I open the excel report and it displays a
> bunch
> > > > of
> > > > garbage. Is there a known issue or a patch out for this?
> > >
> > >
> > >
>
>|||Unless someone else jumps in I suggest calling support. If it is a bug you
will not be charged.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"clutch" <clutch@.discussions.microsoft.com> wrote in message
news:E23BCE25-0B8A-4259-9446-2479071A3144@.microsoft.com...
> Our email system is Novell GroupWise 6.5.
> "Bruce L-C [MVP]" wrote:
> > What email system is being used for delivery (I know there has been some
> > issue with Lotus for example).
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "clutch" <clutch@.discussions.microsoft.com> wrote in message
> > news:0469D6D0-9A84-4BF5-B927-2308CB81F882@.microsoft.com...
> > > Yes, we have.
> > >
> > > "Sal Young" wrote:
> > >
> > > > Did you install the SQL 2000 Reporting Services SP1?
> > > >
> > > >
> > > > "clutch" <clutch@.discussions.microsoft.com> wrote in message
> > > > news:3C59803E-CAB9-4BEC-BA2A-A5E90A0B21B2@.microsoft.com...
> > > > > Hi,
> > > > >
> > > > > I set up a standard subscription and am rendering the report to
excel.
> > > > > After recieving the email, I open the excel report and it displays
a
> > bunch
> > > > > of
> > > > > garbage. Is there a known issue or a patch out for this?
> > > >
> > > >
> > > >
> >
> >
> >|||We also recieve garbage when trying to open a PDF report via email as well. I
assume this is the same as Excel exporting garbage? One other item, when we
include the link in the email, the link itself is placed on two lines. The
top line is a hyperlink and the bottom isn't. Meaning, you can't click on it.
We have to place the top line in and then go back and copy the bottom line
and paste it after the first. Can this be fixed?
"Bruce L-C [MVP]" wrote:
> Unless someone else jumps in I suggest calling support. If it is a bug you
> will not be charged.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "clutch" <clutch@.discussions.microsoft.com> wrote in message
> news:E23BCE25-0B8A-4259-9446-2479071A3144@.microsoft.com...
> > Our email system is Novell GroupWise 6.5.
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > What email system is being used for delivery (I know there has been some
> > > issue with Lotus for example).
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "clutch" <clutch@.discussions.microsoft.com> wrote in message
> > > news:0469D6D0-9A84-4BF5-B927-2308CB81F882@.microsoft.com...
> > > > Yes, we have.
> > > >
> > > > "Sal Young" wrote:
> > > >
> > > > > Did you install the SQL 2000 Reporting Services SP1?
> > > > >
> > > > >
> > > > > "clutch" <clutch@.discussions.microsoft.com> wrote in message
> > > > > news:3C59803E-CAB9-4BEC-BA2A-A5E90A0B21B2@.microsoft.com...
> > > > > > Hi,
> > > > > >
> > > > > > I set up a standard subscription and am rendering the report to
> excel.
> > > > > > After recieving the email, I open the excel report and it displays
> a
> > > bunch
> > > > > > of
> > > > > > garbage. Is there a known issue or a patch out for this?
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>|||I have having the same problem.
"clutch" wrote:
> We also recieve garbage when trying to open a PDF report via email as well. I
> assume this is the same as Excel exporting garbage? One other item, when we
> include the link in the email, the link itself is placed on two lines. The
> top line is a hyperlink and the bottom isn't. Meaning, you can't click on it.
> We have to place the top line in and then go back and copy the bottom line
> and paste it after the first. Can this be fixed?
> "Bruce L-C [MVP]" wrote:
> > Unless someone else jumps in I suggest calling support. If it is a bug you
> > will not be charged.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "clutch" <clutch@.discussions.microsoft.com> wrote in message
> > news:E23BCE25-0B8A-4259-9446-2479071A3144@.microsoft.com...
> > > Our email system is Novell GroupWise 6.5.
> > >
> > > "Bruce L-C [MVP]" wrote:
> > >
> > > > What email system is being used for delivery (I know there has been some
> > > > issue with Lotus for example).
> > > >
> > > > --
> > > > Bruce Loehle-Conger
> > > > MVP SQL Server Reporting Services
> > > >
> > > > "clutch" <clutch@.discussions.microsoft.com> wrote in message
> > > > news:0469D6D0-9A84-4BF5-B927-2308CB81F882@.microsoft.com...
> > > > > Yes, we have.
> > > > >
> > > > > "Sal Young" wrote:
> > > > >
> > > > > > Did you install the SQL 2000 Reporting Services SP1?
> > > > > >
> > > > > >
> > > > > > "clutch" <clutch@.discussions.microsoft.com> wrote in message
> > > > > > news:3C59803E-CAB9-4BEC-BA2A-A5E90A0B21B2@.microsoft.com...
> > > > > > > Hi,
> > > > > > >
> > > > > > > I set up a standard subscription and am rendering the report to
> > excel.
> > > > > > > After recieving the email, I open the excel report and it displays
> > a
> > > > bunch
> > > > > > > of
> > > > > > > garbage. Is there a known issue or a patch out for this?
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >|||Hi bokey,
This may help you.
http://support.microsoft.com/default.aspx?scid=kb;[LN];872774
"bokey" wrote:
> I have having the same problem.
> "clutch" wrote:
> > We also recieve garbage when trying to open a PDF report via email as well. I
> > assume this is the same as Excel exporting garbage? One other item, when we
> > include the link in the email, the link itself is placed on two lines. The
> > top line is a hyperlink and the bottom isn't. Meaning, you can't click on it.
> > We have to place the top line in and then go back and copy the bottom line
> > and paste it after the first. Can this be fixed?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > Unless someone else jumps in I suggest calling support. If it is a bug you
> > > will not be charged.
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > >
> > > "clutch" <clutch@.discussions.microsoft.com> wrote in message
> > > news:E23BCE25-0B8A-4259-9446-2479071A3144@.microsoft.com...
> > > > Our email system is Novell GroupWise 6.5.
> > > >
> > > > "Bruce L-C [MVP]" wrote:
> > > >
> > > > > What email system is being used for delivery (I know there has been some
> > > > > issue with Lotus for example).
> > > > >
> > > > > --
> > > > > Bruce Loehle-Conger
> > > > > MVP SQL Server Reporting Services
> > > > >
> > > > > "clutch" <clutch@.discussions.microsoft.com> wrote in message
> > > > > news:0469D6D0-9A84-4BF5-B927-2308CB81F882@.microsoft.com...
> > > > > > Yes, we have.
> > > > > >
> > > > > > "Sal Young" wrote:
> > > > > >
> > > > > > > Did you install the SQL 2000 Reporting Services SP1?
> > > > > > >
> > > > > > >
> > > > > > > "clutch" <clutch@.discussions.microsoft.com> wrote in message
> > > > > > > news:3C59803E-CAB9-4BEC-BA2A-A5E90A0B21B2@.microsoft.com...
> > > > > > > > Hi,
> > > > > > > >
> > > > > > > > I set up a standard subscription and am rendering the report to
> > > excel.
> > > > > > > > After recieving the email, I open the excel report and it displays
> > > a
> > > > > bunch
> > > > > > > > of
> > > > > > > > garbage. Is there a known issue or a patch out for this?
> > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >|||That work-around (sending just a link to the report, etc.) does get
around the problem in some cases, but unfortunately it is impossible to
control what users select when they create a subscription.
I want to make sure that people were aware of a third-party product,
Proposion Report Adapter for Microsoft Reporting Services and Lotus
Notes/Domino, that fixes this problem and a lot more. It not only
allows you to deliver reports via NATIVE NOTES MAIL, it also allows you
to use Notes/Domino as data sources for reports and/or allows you to
automatically deposit scheduled reports into Notes databases.) See
http://www.proposion.com/ReportAdapter.

No comments:

Post a Comment