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.

Really simple question on Matrix rendering

Hi all,
I have a little problem with matrix rendering.
Here is a description of my report :
Landscape format (29.7cm by 21cm), report header and footer, one matrix
with 1 line group an 1 column group (easy ^o^)
Height of the matrix columns header : 1,3cm
Height of a line element : 2.3cm
Height of the report header : 1.7cm
Height of the report footer : 0.9cm
Margin (top and bottom) of the report : 0.5cm
So "Page height" - "Margins" - "Report Header" - "Report Footer" -
"Matrix Heder" = 16.1cm
And 16.1 = 7x2.3. So, if i'm right, there will be 7 rows by page
Here is the problem :
When I preview the report, I there are 8 rows instead of 7 on the first
page.
And what is really odd, the second page contains 7 rows, as
excpected...
I tried with a table instead of a matrix, just to see if I get the same
thing.
But with a table, I have 7 rows by page, on each page.
It seems that th matrix doesn'y use the same algorithm to calculate
pagebreaks than the table.
Can someone help me please ?
Thanks
DAOK,
Don't search it seems to be a bug of the preview.
When exporting to pdf, the report is correct.
If someone of the RS Team have some time to waste (^o^), I am
interrested in an explanation of the problem.
Thanks for reading ^O^
Bye