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.

Real time "live" data on a windows application .NET 2.0

I want to build a windows application in Visual Studio 2005 that grabs some data from a SQL DB and displays it in a gridview. That is easy and I already have it done, but I also want to know how to show this data in real-time. For example: right now we have a application that pulls some login information for all the users and displays their phone extension, their name, and their status. They can change their status by clicking on some radios below the datagrid and on change it updates the data and then posts back. However, I dont know how the guy who did it made it so that these local changes are automatically shown on everyone elses computers around the office. In other words, they are shown the live data as it changes, without having to refresh it or anything. How would I go about doing this or does anyone have any places/resources that could help me accomplish this task. Thanks.

Oh and the guy who wrote this is no longer working here and he deleted the source code so i cant look at it.

Here's the answer I got from one of our Dev:

there are two methods, a push method or a pull method: you could use something like NotificationServices (I haven't used this. There's some data on it athttp://msdn2.microsoft.com/en-us/library/ms170722(en-US,SQL.90).aspx) to tell you that the data has changed, or you could poll at intervals (or during lulls in processing time) for changes in data.

Either way you go, you're going to face problems of collisions if the users can change the same data. What would you do if you're in the middle of editing a row, and another user deletes it, and you poll for data?

Hope that helps,

Lan

|||

thanks for the reply. the application is designed to only allow the user to change their own data, therefore there will be no way that any user can be changing the same data. I will take a look at that article.