Maintaining a Date/Time Last Updated Value

Using SQL Server 2000...
In support of a Web site's product catalogs; we will have at least two
tables [Products] and [ProductCatalogs].
The application needs to show the Date/Time any given product catalog was
last updated. For purposes of this "last updated date/time" value, we
consider the catalog as having been updated when [anything about the
catalog, itself] has been updated OR [any items presented in the catalog]
have been updated. This means one Date/Time value when either (1) the given
catalog's row in [ProductCatalogs] or (2) any associated rows in [Products]
have been updated. We do not need a complete update history - we only want
to know the last date/time an update happened to either the given catalog or
to any of the items presented in the catalog (and not any "per item" update
date/time).
One solution would be to have a column in [ProductCatalogs] of the DateTime
data type. The value in this column gets maintained by triggers on both
[Products] and [ProductCatalogs].
While that solution would work, I'd appreciate your perspective, opinions,
and alternatives - if any - before I go off and implement this.
Thanks!As far as I can see, you only need one datetime field on the table
ProductCatalogs. If you have only one way of updating your data (through
stored procedure) I would recommend implementing this logic in the stored
procedure. If not (or you think that someone could change data without using
sp) you would need to implement triggers.
MC
"Jeff" <Jeff@.NoSpam.com> wrote in message
news:u87GGjH9FHA.3020@.TK2MSFTNGP09.phx.gbl...
> Using SQL Server 2000...
> In support of a Web site's product catalogs; we will have at least two
> tables [Products] and [ProductCatalogs].
> The application needs to show the Date/Time any given product catalog was
> last updated. For purposes of this "last updated date/time" value, we
> consider the catalog as having been updated when [anything about the
> catalog, itself] has been updated OR [any items presented in the catalog]
> have been updated. This means one Date/Time value when either (1) the
> given catalog's row in [ProductCatalogs] or (2) any associated rows in
> [Products] have been updated. We do not need a complete update history -
> we only want to know the last date/time an update happened to either the
> given catalog or to any of the items presented in the catalog (and not any
> "per item" update date/time).
> One solution would be to have a column in [ProductCatalogs] of the
> DateTime data type. The value in this column gets maintained by triggers
> on both [Products] and [ProductCatalogs].
> While that solution would work, I'd appreciate your perspective, opinions,
> and alternatives - if any - before I go off and implement this.
> Thanks!
>

Mailing Reports

Hi,
I am rendering a report in PDF Format when a user needs in my Web Form(on
click of a button)
When this report is rendered in PDF format, Is there a way to send him the
report by Email.
An Email has to be sent when a report is rendered by a particular user.
Is there an option for this...
Thanks
KiranKiran:
I was coming in to ask a similar question. I know what you want to do can be
done through subscriptions, and I have looked at the database table where
subscriptions are stored and I believe it would just be a matter of inserting
a onetime subscription line into the subscription table. But what I want to
know is there any resource out there taht tells you how to add lines to the
subscription table. I have been thinking of purchasing hitchhikers guide but
I am unsure if it is going to help me with anything I do not already know.
"Kiran" wrote:
> Hi,
> I am rendering a report in PDF Format when a user needs in my Web Form(on
> click of a button)
> When this report is rendered in PDF format, Is there a way to send him the
> report by Email.
> An Email has to be sent when a report is rendered by a particular user.
> Is there an option for this...
> Thanks
> Kiran
>
>|||Since you have your own webform here is another option for you (although
doing a one time subscription will work as well) but you might find this
easier. Save the PDF as a file and then send it using the following SMTP
client. This SMTP client requires no install of any mail client. You need to
have a SMTP server somewhere for this to work. It is very easy to use and is
widely used in the SQL Server community.
http://sqldev.net/xp/xpsmtp.htm
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Kiran" <Kiran@.nospam.net> wrote in message
news:%23Tr1E%232DFHA.512@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I am rendering a report in PDF Format when a user needs in my Web Form(on
> click of a button)
> When this report is rendered in PDF format, Is there a way to send him the
> report by Email.
> An Email has to be sent when a report is rendered by a particular user.
> Is there an option for this...
> Thanks
> Kiran
>|||Hi Bruce,
How will I save the PDF on the server so as to mail it.
Thanks
Kiran
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eBl8qd3DFHA.576@.TK2MSFTNGP15.phx.gbl...
> Since you have your own webform here is another option for you (although
> doing a one time subscription will work as well) but you might find this
> easier. Save the PDF as a file and then send it using the following SMTP
> client. This SMTP client requires no install of any mail client. You need
> to
> have a SMTP server somewhere for this to work. It is very easy to use and
> is
> widely used in the SQL Server community.
> http://sqldev.net/xp/xpsmtp.htm
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Kiran" <Kiran@.nospam.net> wrote in message
> news:%23Tr1E%232DFHA.512@.TK2MSFTNGP15.phx.gbl...
>> Hi,
>> I am rendering a report in PDF Format when a user needs in my Web Form(on
>> click of a button)
>> When this report is rendered in PDF format, Is there a way to send him
>> the
>> report by Email.
>> An Email has to be sent when a report is rendered by a particular user.
>> Is there an option for this...
>> Thanks
>> Kiran
>>
>|||Bruce; That was very helpful.. but is there a reference to where I can add
the subscription to the database through my application?
thanks
"Bruce L-C [MVP]" wrote:
> Since you have your own webform here is another option for you (although
> doing a one time subscription will work as well) but you might find this
> easier. Save the PDF as a file and then send it using the following SMTP
> client. This SMTP client requires no install of any mail client. You need to
> have a SMTP server somewhere for this to work. It is very easy to use and is
> widely used in the SQL Server community.
> http://sqldev.net/xp/xpsmtp.htm
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Kiran" <Kiran@.nospam.net> wrote in message
> news:%23Tr1E%232DFHA.512@.TK2MSFTNGP15.phx.gbl...
> > Hi,
> >
> > I am rendering a report in PDF Format when a user needs in my Web Form(on
> > click of a button)
> >
> > When this report is rendered in PDF format, Is there a way to send him the
> > report by Email.
> >
> > An Email has to be sent when a report is rendered by a particular user.
> >
> > Is there an option for this...
> >
> > Thanks
> > Kiran
> >
> >
>
>|||To add a subscription from you web app you have to use soap (web services)
if you have been using URL integration then you need to learn how to use the
web services to accomplish this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Patrick K" <PatrickK@.discussions.microsoft.com> wrote in message
news:162C8BD3-843B-44FE-A968-3A08770105E4@.microsoft.com...
> Bruce; That was very helpful.. but is there a reference to where I can add
> the subscription to the database through my application?
> thanks
> "Bruce L-C [MVP]" wrote:
> > Since you have your own webform here is another option for you (although
> > doing a one time subscription will work as well) but you might find this
> > easier. Save the PDF as a file and then send it using the following SMTP
> > client. This SMTP client requires no install of any mail client. You
need to
> > have a SMTP server somewhere for this to work. It is very easy to use
and is
> > widely used in the SQL Server community.
> >
> > http://sqldev.net/xp/xpsmtp.htm
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Kiran" <Kiran@.nospam.net> wrote in message
> > news:%23Tr1E%232DFHA.512@.TK2MSFTNGP15.phx.gbl...
> > > Hi,
> > >
> > > I am rendering a report in PDF Format when a user needs in my Web
Form(on
> > > click of a button)
> > >
> > > When this report is rendered in PDF format, Is there a way to send him
the
> > > report by Email.
> > >
> > > An Email has to be sent when a report is rendered by a particular
user.
> > >
> > > Is there an option for this...
> > >
> > > Thanks
> > > Kiran
> > >
> > >
> >
> >
> >|||I know it is possible but I haven't been programming asp.net for awhile now
so I can't help you with that.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Kiran" <Kiran@.nospam.net> wrote in message
news:%230kCjB4DFHA.1496@.TK2MSFTNGP14.phx.gbl...
> Hi Bruce,
> How will I save the PDF on the server so as to mail it.
> Thanks
> Kiran
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:eBl8qd3DFHA.576@.TK2MSFTNGP15.phx.gbl...
> > Since you have your own webform here is another option for you (although
> > doing a one time subscription will work as well) but you might find this
> > easier. Save the PDF as a file and then send it using the following SMTP
> > client. This SMTP client requires no install of any mail client. You
need
> > to
> > have a SMTP server somewhere for this to work. It is very easy to use
and
> > is
> > widely used in the SQL Server community.
> >
> > http://sqldev.net/xp/xpsmtp.htm
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Kiran" <Kiran@.nospam.net> wrote in message
> > news:%23Tr1E%232DFHA.512@.TK2MSFTNGP15.phx.gbl...
> >> Hi,
> >>
> >> I am rendering a report in PDF Format when a user needs in my Web
Form(on
> >> click of a button)
> >>
> >> When this report is rendered in PDF format, Is there a way to send him
> >> the
> >> report by Email.
> >>
> >> An Email has to be sent when a report is rendered by a particular user.
> >>
> >> Is there an option for this...
> >>
> >> Thanks
> >> Kiran
> >>
> >>
> >
> >
>|||I have a similar question.
I am using the email provider available out of the box with reporting
services. I am on a flat network using 2 separated domains (resource and
user)and Routed IP schemes. The companies email is handled offsite using an
SMTP server that requires the user to login. There does not appear to be an
option to do this using the out of the box delivery method. And
unfortunately I do not know enough about setting up my own SMTP server
locally. I am trying to mail the reports from the resource domain to the
user domain.
--Eric Cathell, MCSA
"Kiran" <Kiran@.nospam.net> wrote in message
news:%23Tr1E%232DFHA.512@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I am rendering a report in PDF Format when a user needs in my Web Form(on
> click of a button)
> When this report is rendered in PDF format, Is there a way to send him the
> report by Email.
> An Email has to be sent when a report is rendered by a particular user.
> Is there an option for this...
> Thanks
> Kiran
>

Madness?!? This is SQL!

I'm charged with building a web service that accepts data from
multiple locations and stores it to be queried by users. The data we
receive will vary from business unit to business unit and we intend to
add more units as the project progresses. Each unit's system we add
will return data in a different format, and I really don't want to try
and replicate all of their databases.
Someone tell me whether the way I have this planned is a good way of
doing it, or if it's pure madness.
Lets say I get data from 2 different business units as follows:
Unit 1 Data:
<employees>
<employee id="1">
<name>Doe, Jane</name>
<phone>999-999-9999</phone>
</employee>
<employee>
<name>Doe, John</name>
<phone>888-888-8888</phone>
</employee>
</employees>
Unit 2 Data:
<systems>
<system id="123" name="wrk001">
<ip>1.1.1.1</ip>
<os>WindowsXP</os>
<location>D105</location>
</system>
<system id="234" name="wrk002">
<ip>1.1.1.2</ip>
<os>WindowsXP</os>
<location>D106</location>
</system>
</systems>
When a user needs to look up data from unit 1, they'll need to be able
to supply the employee's name and or id, while users searching unit 2
will need to know an ip address and or location name.
First, lets say I have a System Table:
TBL_System
---
| System_ID | System_Name
+--+--
| 1 | Business Unit 1
+--+--
| 2 | Business Unit 2
+--+--
Then, I create a table that explains what keys users will be searching
for. These keys will be based off of the XML document structure.
---
| System_ID | System_Key | Key_Name
+--+--+--
| 1 | 1 | id
+--+--+--
| 1 | 2 | name
+--+--+--
| 2 | 1 | location
+--+--+--
| 2 | 2 | ip
+--+--+--
Then, lets say I create a Table called TBL_DataStore to hold this
info.
TBL_DataStore
---
| DS_ID | DS_Data
+--+--
| 1 | <employee id="z1">
| | <name>Doe, Jane</name>
| | <phone>999-999-9999</phone>
| | </employee>
+--+--
| 2 | <employee id="z2">
| | <name>Doe, John</name>
| | <phone>888-888-8888</phone>
| | </employee>
+--+--
| 3 | <system id="123" name="wrk001">
| | <ip>1.1.1.1</ip>
| | <os>WindowsXP</os>
| | <location>D105</location>
| | </system>
+--+--
| 4 | <system id="234" name="wrk002">
| | <ip>1.1.1.2</ip>
| | <os>WindowsXP</os>
| | <location>D106</location>
| | </system>
+--+--
Finally, I create a Lookup table that holds key values that the user
will be searching for
TBL_Lookup
---
| System_ID | System_Key | DS_ID | Key_Value
+--+--+--+--
| 1 | 1 | 1 | z1
+--+--+--+--
| 1 | 2 | 1 | Doe, Jane
+--+--+--+--
| 1 | 1 | 2 | z2
+--+--+--+--
| 1 | 2 | 2 | Doe, John
+--+--+--+--
| 2 | 1 | 3 | D105
+--+--+--+--
| 2 | 2 | 3 | 1.1.1.1
+--+--+--+--
| 2 | 1 | 4 | D106
+--+--+--+--
| 2 | 2 | 4 | 1.1.1.2
+--+--+--+--
Now, based on this structure, I can load data from any business unit
without having to change the data structure to add more businesses.
Further, In order to query the data, I don't have to know the specific
xPath of a piece of information.
Is this a good way to accomplish what I'm trying to achieve, or should
I figure out some way to use OpenXML() queries based on XML supplied
by the different business units. My concern about OpenXML() is it's
speed and flexability.Hello Kris,
What volumes are you dealing with?
My view is the effort in creating a table far out ways the effort to support
a system like the one you are suggesting.
One simple view is to use full text, which allows full text to filter down
in a rough manner and then filter further using normal search predicates.
i.e. system and/or an xpath query
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons

> I'm charged with building a web service that accepts data from
> multiple locations and stores it to be queried by users. The data we
> receive will vary from business unit to business unit and we intend to
> add more units as the project progresses. Each unit's system we add
> will return data in a different format, and I really don't want to try
> and replicate all of their databases.
> Someone tell me whether the way I have this planned is a good way of
> doing it, or if it's pure madness.
> Lets say I get data from 2 different business units as follows:
> Unit 1 Data:
> <employees>
> <employee id="1">
> <name>Doe, Jane</name>
> <phone>999-999-9999</phone>
> </employee>
> <employee>
> <name>Doe, John</name>
> <phone>888-888-8888</phone>
> </employee>
> </employees>
> Unit 2 Data:
> <systems>
> <system id="123" name="wrk001">
> <ip>1.1.1.1</ip>
> <os>WindowsXP</os>
> <location>D105</location>
> </system>
> <system id="234" name="wrk002">
> <ip>1.1.1.2</ip>
> <os>WindowsXP</os>
> <location>D106</location>
> </system>
> </systems>
> When a user needs to look up data from unit 1, they'll need to be able
> to supply the employee's name and or id, while users searching unit 2
> will need to know an ip address and or location name.
> First, lets say I have a System Table:
> TBL_System
> ---
> | System_ID | System_Name
> +--+--
> | 1 | Business Unit 1
> +--+--
> | 2 | Business Unit 2
> +--+--
> Then, I create a table that explains what keys users will be searching
> for. These keys will be based off of the XML document structure.
> ---
> | System_ID | System_Key | Key_Name
> +--+--+--
> | 1 | 1 | id
> +--+--+--
> | 1 | 2 | name
> +--+--+--
> | 2 | 1 | location
> +--+--+--
> | 2 | 2 | ip
> +--+--+--
> Then, lets say I create a Table called TBL_DataStore to hold this
> info.
> TBL_DataStore
> ---
> | DS_ID | DS_Data
> +--+--
> | 1 | <employee id="z1">
> | | <name>Doe, Jane</name>
> | | <phone>999-999-9999</phone>
> | | </employee>
> +--+--
> | 2 | <employee id="z2">
> | | <name>Doe, John</name>
> | | <phone>888-888-8888</phone>
> | | </employee>
> +--+--
> | 3 | <system id="123" name="wrk001">
> | | <ip>1.1.1.1</ip>
> | | <os>WindowsXP</os>
> | | <location>D105</location>
> | | </system>
> +--+--
> | 4 | <system id="234" name="wrk002">
> | | <ip>1.1.1.2</ip>
> | | <os>WindowsXP</os>
> | | <location>D106</location>
> | | </system>
> +--+--
> Finally, I create a Lookup table that holds key values that the user
> will be searching for
> TBL_Lookup
> ---
> | System_ID | System_Key | DS_ID | Key_Value
> +--+--+--+--
> | 1 | 1 | 1 | z1
> +--+--+--+--
> | 1 | 2 | 1 | Doe, Jane
> +--+--+--+--
> | 1 | 1 | 2 | z2
> +--+--+--+--
> | 1 | 2 | 2 | Doe, John
> +--+--+--+--
> | 2 | 1 | 3 | D105
> +--+--+--+--
> | 2 | 2 | 3 | 1.1.1.1
> +--+--+--+--
> | 2 | 1 | 4 | D106
> +--+--+--+--
> | 2 | 2 | 4 | 1.1.1.2
> +--+--+--+--
> Now, based on this structure, I can load data from any business unit
> without having to change the data structure to add more businesses.
> Further, In order to query the data, I don't have to know the specific
> xPath of a piece of information.
> Is this a good way to accomplish what I'm trying to achieve, or should
> I figure out some way to use OpenXML() queries based on XML supplied
> by the different business units. My concern about OpenXML() is it's
> speed and flexability.
>

Madness?!? This is SQL!

I'm charged with building a web service that accepts data from
multiple locations and stores it to be queried by users. The data we
receive will vary from business unit to business unit and we intend to
add more units as the project progresses. Each unit's system we add
will return data in a different format, and I really don't want to try
and replicate all of their databases.
Someone tell me whether the way I have this planned is a good way of
doing it, or if it's pure madness.
Lets say I get data from 2 different business units as follows:
Unit 1 Data:
<employees>
<employee id="1">
<name>Doe, Jane</name>
<phone>999-999-9999</phone>
</employee>
<employee>
<name>Doe, John</name>
<phone>888-888-8888</phone>
</employee>
</employees>
Unit 2 Data:
<systems>
<system id="123" name="wrk001">
<ip>1.1.1.1</ip>
<os>WindowsXP</os>
<location>D105</location>
</system>
<system id="234" name="wrk002">
<ip>1.1.1.2</ip>
<os>WindowsXP</os>
<location>D106</location>
</system>
</systems>
When a user needs to look up data from unit 1, they'll need to be able
to supply the employee's name and or id, while users searching unit 2
will need to know an ip address and or location name.
First, lets say I have a System Table:
TBL_System
| System_ID | System_Name
+--+--
| 1 | Business Unit 1
+--+--
| 2 | Business Unit 2
+--+--
Then, I create a table that explains what keys users will be searching
for. These keys will be based off of the XML document structure.
| System_ID | System_Key | Key_Name
+--+--+--
| 1 | 1 | id
+--+--+--
| 1 | 2 | name
+--+--+--
| 2 | 1 | location
+--+--+--
| 2 | 2 | ip
+--+--+--
Then, lets say I create a Table called TBL_DataStore to hold this
info.
TBL_DataStore
| DS_ID | DS_Data
+--+--
| 1 | <employee id="z1">
| | <name>Doe, Jane</name>
| |<phone>999-999-9999</phone>
|| </employee>
+--+--
| 2 | <employee id="z2">
| | <name>Doe, John</name>
| | <phone>888-888-8888</phone>
| | </employee>
+--+--
| 3 | <system id="123" name="wrk001">
| | <ip>1.1.1.1</ip>
| | <os>WindowsXP</os>
| | <location>D105</location>
| | </system>
+--+--
| 4 | <system id="234" name="wrk002">
| | <ip>1.1.1.2</ip>
| | <os>WindowsXP</os>
| | <location>D106</location>
| | </system>
+--+--
Finally, I create a Lookup table that holds key values that the user
will be searching for
TBL_Lookup
| System_ID | System_Key | DS_ID | Key_Value
+--+--+--+--
| 1 | 1 | 1 | z1
+--+--+--+--
| 1 | 2 | 1 | Doe, Jane
+--+--+--+--
| 1 | 1 | 2 | z2
+--+--+--+--
| 1 | 2 | 2 | Doe, John
+--+--+--+--
| 2 | 1 | 3 | D105
+--+--+--+--
| 2 | 2 | 3 | 1.1.1.1
+--+--+--+--
| 2 | 1 | 4 | D106
+--+--+--+--
| 2 | 2 | 4 | 1.1.1.2
+--+--+--+--
Now, based on this structure, I can load data from any business unit
without having to change the data structure to add more businesses.
Further, In order to query the data, I don't have to know the specific
xPath of a piece of information.
Is this a good way to accomplish what I'm trying to achieve, or should
I figure out some way to use OpenXML() queries based on XML supplied
by the different business units. My concern about OpenXML() is it's
speed and flexability.
Hello Kris,
What volumes are you dealing with?
My view is the effort in creating a table far out ways the effort to support
a system like the one you are suggesting.
One simple view is to use full text, which allows full text to filter down
in a rough manner and then filter further using normal search predicates.
i.e. system and/or an xpath query
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons

> I'm charged with building a web service that accepts data from
> multiple locations and stores it to be queried by users. The data we
> receive will vary from business unit to business unit and we intend to
> add more units as the project progresses. Each unit's system we add
> will return data in a different format, and I really don't want to try
> and replicate all of their databases.
> Someone tell me whether the way I have this planned is a good way of
> doing it, or if it's pure madness.
> Lets say I get data from 2 different business units as follows:
> Unit 1 Data:
> <employees>
> <employee id="1">
> <name>Doe, Jane</name>
> <phone>999-999-9999</phone>
> </employee>
> <employee>
> <name>Doe, John</name>
> <phone>888-888-8888</phone>
> </employee>
> </employees>
> Unit 2 Data:
> <systems>
> <system id="123" name="wrk001">
> <ip>1.1.1.1</ip>
> <os>WindowsXP</os>
> <location>D105</location>
> </system>
> <system id="234" name="wrk002">
> <ip>1.1.1.2</ip>
> <os>WindowsXP</os>
> <location>D106</location>
> </system>
> </systems>
> When a user needs to look up data from unit 1, they'll need to be able
> to supply the employee's name and or id, while users searching unit 2
> will need to know an ip address and or location name.
> First, lets say I have a System Table:
> TBL_System
> | System_ID | System_Name
> +--+--
> | 1 | Business Unit 1
> +--+--
> | 2 | Business Unit 2
> +--+--
> Then, I create a table that explains what keys users will be searching
> for. These keys will be based off of the XML document structure.
> | System_ID | System_Key | Key_Name
> +--+--+--
> | 1 | 1 | id
> +--+--+--
> | 1 | 2 | name
> +--+--+--
> | 2 | 1 | location
> +--+--+--
> | 2 | 2 | ip
> +--+--+--
> Then, lets say I create a Table called TBL_DataStore to hold this
> info.
> TBL_DataStore
> | DS_ID | DS_Data
> +--+--
> | 1 | <employee id="z1">
> | | <name>Doe, Jane</name>
> | |<phone>999-999-9999</phone>
> || </employee>
> +--+--
> | 2 | <employee id="z2">
> | | <name>Doe, John</name>
> | | <phone>888-888-8888</phone>
> | | </employee>
> +--+--
> | 3 | <system id="123" name="wrk001">
> | | <ip>1.1.1.1</ip>
> | | <os>WindowsXP</os>
> | | <location>D105</location>
> | | </system>
> +--+--
> | 4 | <system id="234" name="wrk002">
> | | <ip>1.1.1.2</ip>
> | | <os>WindowsXP</os>
> | | <location>D106</location>
> | | </system>
> +--+--
> Finally, I create a Lookup table that holds key values that the user
> will be searching for
> TBL_Lookup
> | System_ID | System_Key | DS_ID | Key_Value
> +--+--+--+--
> | 1 | 1 | 1 | z1
> +--+--+--+--
> | 1 | 2 | 1 | Doe, Jane
> +--+--+--+--
> | 1 | 1 | 2 | z2
> +--+--+--+--
> | 1 | 2 | 2 | Doe, John
> +--+--+--+--
> | 2 | 1 | 3 | D105
> +--+--+--+--
> | 2 | 2 | 3 | 1.1.1.1
> +--+--+--+--
> | 2 | 1 | 4 | D106
> +--+--+--+--
> | 2 | 2 | 4 | 1.1.1.2
> +--+--+--+--
> Now, based on this structure, I can load data from any business unit
> without having to change the data structure to add more businesses.
> Further, In order to query the data, I don't have to know the specific
> xPath of a piece of information.
> Is this a good way to accomplish what I'm trying to achieve, or should
> I figure out some way to use OpenXML() queries based on XML supplied
> by the different business units. My concern about OpenXML() is it's
> speed and flexability.
>

Macintosh Excel v.x Rendering

We have built a new front end to the report server to run reports. When
making calls to the RS Web Service, is there anything special that needs to
be done for Excel (xls) rendering? We have a few clients utlizing Apple MAC
OS X with Office v.x. We thought that SP1 would take care of their ability
to open the xls files as with prior versions of PC xls before Office XP.
After further testing, the MAC version still does not open the excel file
correctly. It only has MIME type values in the file. What are the options
to ensure MAC Excel opens the same as PC Excel with SP1? We currently have
them export to CSV and then open that in excel with the text to columns
re-formatting. Any help you could provide would be greatly appreciated.Have you tried to export the file using a PC, save it to disk and then open
it on the Mac? I wouldn't be surprised if there were some glitches.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lance" <Lance@.discussions.microsoft.com> wrote in message
news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
> We have built a new front end to the report server to run reports. When
> making calls to the RS Web Service, is there anything special that needs
> to
> be done for Excel (xls) rendering? We have a few clients utlizing Apple
> MAC
> OS X with Office v.x. We thought that SP1 would take care of their
> ability
> to open the xls files as with prior versions of PC xls before Office XP.
> After further testing, the MAC version still does not open the excel file
> correctly. It only has MIME type values in the file. What are the
> options
> to ensure MAC Excel opens the same as PC Excel with SP1? We currently
> have
> them export to CSV and then open that in excel with the text to columns
> re-formatting. Any help you could provide would be greatly appreciated.|||Yes...It works fine if I save down to Excel 95-2000 workbook and then send
it. The mac opens fine, but that is not a viable solution to our problem as
the mac clients will need to run reports on demand. Do you by chance know
if there is a solution in the works to ensure MAC Excel versions export
without incidence as the PC version?
Thanks...
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
> Have you tried to export the file using a PC, save it to disk and then
open
> it on the Mac? I wouldn't be surprised if there were some glitches.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Lance" <Lance@.discussions.microsoft.com> wrote in message
> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
> > We have built a new front end to the report server to run reports. When
> > making calls to the RS Web Service, is there anything special that needs
> > to
> > be done for Excel (xls) rendering? We have a few clients utlizing Apple
> > MAC
> > OS X with Office v.x. We thought that SP1 would take care of their
> > ability
> > to open the xls files as with prior versions of PC xls before Office XP.
> > After further testing, the MAC version still does not open the excel
file
> > correctly. It only has MIME type values in the file. What are the
> > options
> > to ensure MAC Excel opens the same as PC Excel with SP1? We currently
> > have
> > them export to CSV and then open that in excel with the text to columns
> > re-formatting. Any help you could provide would be greatly appreciated.
>|||So what happens if you open the workbook directly in Excel on the mac (don't
open it in PC Excel)?
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lance" <ldacy@.fellowshiptech.com> wrote in message
news:ueFapmtfEHA.2848@.TK2MSFTNGP10.phx.gbl...
> Yes...It works fine if I save down to Excel 95-2000 workbook and then send
> it. The mac opens fine, but that is not a viable solution to our problem
> as
> the mac clients will need to run reports on demand. Do you by chance know
> if there is a solution in the works to ensure MAC Excel versions export
> without incidence as the PC version?
> Thanks...
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
>> Have you tried to export the file using a PC, save it to disk and then
> open
>> it on the Mac? I wouldn't be surprised if there were some glitches.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "Lance" <Lance@.discussions.microsoft.com> wrote in message
>> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
>> > We have built a new front end to the report server to run reports.
>> > When
>> > making calls to the RS Web Service, is there anything special that
>> > needs
>> > to
>> > be done for Excel (xls) rendering? We have a few clients utlizing
>> > Apple
>> > MAC
>> > OS X with Office v.x. We thought that SP1 would take care of their
>> > ability
>> > to open the xls files as with prior versions of PC xls before Office
>> > XP.
>> > After further testing, the MAC version still does not open the excel
> file
>> > correctly. It only has MIME type values in the file. What are the
>> > options
>> > to ensure MAC Excel opens the same as PC Excel with SP1? We currently
>> > have
>> > them export to CSV and then open that in excel with the text to columns
>> > re-formatting. Any help you could provide would be greatly
>> > appreciated.
>>
>|||The document is garbage...It looks exactly what happens when someone who has
a lower version of excel than XP.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:enJe9r8fEHA.536@.TK2MSFTNGP11.phx.gbl...
> So what happens if you open the workbook directly in Excel on the mac
(don't
> open it in PC Excel)?
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Lance" <ldacy@.fellowshiptech.com> wrote in message
> news:ueFapmtfEHA.2848@.TK2MSFTNGP10.phx.gbl...
> > Yes...It works fine if I save down to Excel 95-2000 workbook and then
send
> > it. The mac opens fine, but that is not a viable solution to our
problem
> > as
> > the mac clients will need to run reports on demand. Do you by chance
know
> > if there is a solution in the works to ensure MAC Excel versions export
> > without incidence as the PC version?
> >
> > Thanks...
> >
> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> > news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
> >> Have you tried to export the file using a PC, save it to disk and then
> > open
> >> it on the Mac? I wouldn't be surprised if there were some glitches.
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> Microsoft SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >>
> >> "Lance" <Lance@.discussions.microsoft.com> wrote in message
> >> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
> >> > We have built a new front end to the report server to run reports.
> >> > When
> >> > making calls to the RS Web Service, is there anything special that
> >> > needs
> >> > to
> >> > be done for Excel (xls) rendering? We have a few clients utlizing
> >> > Apple
> >> > MAC
> >> > OS X with Office v.x. We thought that SP1 would take care of their
> >> > ability
> >> > to open the xls files as with prior versions of PC xls before Office
> >> > XP.
> >> > After further testing, the MAC version still does not open the excel
> > file
> >> > correctly. It only has MIME type values in the file. What are the
> >> > options
> >> > to ensure MAC Excel opens the same as PC Excel with SP1? We
currently
> >> > have
> >> > them export to CSV and then open that in excel with the text to
columns
> >> > re-formatting. Any help you could provide would be greatly
> >> > appreciated.
> >>
> >>
> >
> >
>|||In SP1, we support Excel 97 and 2000. You should not get a MIME document
after applying the service pack.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lance" <ldacy@.fellowshiptech.com> wrote in message
news:Og9BSRGgEHA.3964@.TK2MSFTNGP12.phx.gbl...
> The document is garbage...It looks exactly what happens when someone who
> has
> a lower version of excel than XP.
>
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:enJe9r8fEHA.536@.TK2MSFTNGP11.phx.gbl...
>> So what happens if you open the workbook directly in Excel on the mac
> (don't
>> open it in PC Excel)?
>> --
>> Brian Welcker
>> Group Program Manager
>> SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "Lance" <ldacy@.fellowshiptech.com> wrote in message
>> news:ueFapmtfEHA.2848@.TK2MSFTNGP10.phx.gbl...
>> > Yes...It works fine if I save down to Excel 95-2000 workbook and then
> send
>> > it. The mac opens fine, but that is not a viable solution to our
> problem
>> > as
>> > the mac clients will need to run reports on demand. Do you by chance
> know
>> > if there is a solution in the works to ensure MAC Excel versions export
>> > without incidence as the PC version?
>> >
>> > Thanks...
>> >
>> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
>> > news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
>> >> Have you tried to export the file using a PC, save it to disk and then
>> > open
>> >> it on the Mac? I wouldn't be surprised if there were some glitches.
>> >>
>> >> --
>> >> Brian Welcker
>> >> Group Program Manager
>> >> Microsoft SQL Server Reporting Services
>> >>
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >>
>> >> "Lance" <Lance@.discussions.microsoft.com> wrote in message
>> >> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
>> >> > We have built a new front end to the report server to run reports.
>> >> > When
>> >> > making calls to the RS Web Service, is there anything special that
>> >> > needs
>> >> > to
>> >> > be done for Excel (xls) rendering? We have a few clients utlizing
>> >> > Apple
>> >> > MAC
>> >> > OS X with Office v.x. We thought that SP1 would take care of their
>> >> > ability
>> >> > to open the xls files as with prior versions of PC xls before Office
>> >> > XP.
>> >> > After further testing, the MAC version still does not open the excel
>> > file
>> >> > correctly. It only has MIME type values in the file. What are the
>> >> > options
>> >> > to ensure MAC Excel opens the same as PC Excel with SP1? We
> currently
>> >> > have
>> >> > them export to CSV and then open that in excel with the text to
> columns
>> >> > re-formatting. Any help you could provide would be greatly
>> >> > appreciated.
>> >>
>> >>
>> >
>> >
>>
>|||I understand that, but the MAC version still gets this MIME document...The
PC version is fine.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:%239umLe7gEHA.3548@.TK2MSFTNGP09.phx.gbl...
> In SP1, we support Excel 97 and 2000. You should not get a MIME document
> after applying the service pack.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Lance" <ldacy@.fellowshiptech.com> wrote in message
> news:Og9BSRGgEHA.3964@.TK2MSFTNGP12.phx.gbl...
> > The document is garbage...It looks exactly what happens when someone who
> > has
> > a lower version of excel than XP.
> >
> >
> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> > news:enJe9r8fEHA.536@.TK2MSFTNGP11.phx.gbl...
> >> So what happens if you open the workbook directly in Excel on the mac
> > (don't
> >> open it in PC Excel)?
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >>
> >> "Lance" <ldacy@.fellowshiptech.com> wrote in message
> >> news:ueFapmtfEHA.2848@.TK2MSFTNGP10.phx.gbl...
> >> > Yes...It works fine if I save down to Excel 95-2000 workbook and then
> > send
> >> > it. The mac opens fine, but that is not a viable solution to our
> > problem
> >> > as
> >> > the mac clients will need to run reports on demand. Do you by chance
> > know
> >> > if there is a solution in the works to ensure MAC Excel versions
export
> >> > without incidence as the PC version?
> >> >
> >> > Thanks...
> >> >
> >> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in
message
> >> > news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
> >> >> Have you tried to export the file using a PC, save it to disk and
then
> >> > open
> >> >> it on the Mac? I wouldn't be surprised if there were some glitches.
> >> >>
> >> >> --
> >> >> Brian Welcker
> >> >> Group Program Manager
> >> >> Microsoft SQL Server Reporting Services
> >> >>
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> > rights.
> >> >>
> >> >> "Lance" <Lance@.discussions.microsoft.com> wrote in message
> >> >> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
> >> >> > We have built a new front end to the report server to run reports.
> >> >> > When
> >> >> > making calls to the RS Web Service, is there anything special that
> >> >> > needs
> >> >> > to
> >> >> > be done for Excel (xls) rendering? We have a few clients utlizing
> >> >> > Apple
> >> >> > MAC
> >> >> > OS X with Office v.x. We thought that SP1 would take care of
their
> >> >> > ability
> >> >> > to open the xls files as with prior versions of PC xls before
Office
> >> >> > XP.
> >> >> > After further testing, the MAC version still does not open the
excel
> >> > file
> >> >> > correctly. It only has MIME type values in the file. What are
the
> >> >> > options
> >> >> > to ensure MAC Excel opens the same as PC Excel with SP1? We
> > currently
> >> >> > have
> >> >> > them export to CSV and then open that in excel with the text to
> > columns
> >> >> > re-formatting. Any help you could provide would be greatly
> >> >> > appreciated.
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>|||Any suggestions or comments?
"Lance" <ldacy@.fellowshiptech.com> wrote in message
news:%23K488YfhEHA.3928@.TK2MSFTNGP11.phx.gbl...
> I understand that, but the MAC version still gets this MIME document...The
> PC version is fine.
>
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:%239umLe7gEHA.3548@.TK2MSFTNGP09.phx.gbl...
> > In SP1, we support Excel 97 and 2000. You should not get a MIME document
> > after applying the service pack.
> >
> > --
> > Brian Welcker
> > Group Program Manager
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Lance" <ldacy@.fellowshiptech.com> wrote in message
> > news:Og9BSRGgEHA.3964@.TK2MSFTNGP12.phx.gbl...
> > > The document is garbage...It looks exactly what happens when someone
who
> > > has
> > > a lower version of excel than XP.
> > >
> > >
> > > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in
message
> > > news:enJe9r8fEHA.536@.TK2MSFTNGP11.phx.gbl...
> > >> So what happens if you open the workbook directly in Excel on the mac
> > > (don't
> > >> open it in PC Excel)?
> > >>
> > >> --
> > >> Brian Welcker
> > >> Group Program Manager
> > >> SQL Server Reporting Services
> > >>
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > >>
> > >> "Lance" <ldacy@.fellowshiptech.com> wrote in message
> > >> news:ueFapmtfEHA.2848@.TK2MSFTNGP10.phx.gbl...
> > >> > Yes...It works fine if I save down to Excel 95-2000 workbook and
then
> > > send
> > >> > it. The mac opens fine, but that is not a viable solution to our
> > > problem
> > >> > as
> > >> > the mac clients will need to run reports on demand. Do you by
chance
> > > know
> > >> > if there is a solution in the works to ensure MAC Excel versions
> export
> > >> > without incidence as the PC version?
> > >> >
> > >> > Thanks...
> > >> >
> > >> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in
> message
> > >> > news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
> > >> >> Have you tried to export the file using a PC, save it to disk and
> then
> > >> > open
> > >> >> it on the Mac? I wouldn't be surprised if there were some
glitches.
> > >> >>
> > >> >> --
> > >> >> Brian Welcker
> > >> >> Group Program Manager
> > >> >> Microsoft SQL Server Reporting Services
> > >> >>
> > >> >> This posting is provided "AS IS" with no warranties, and confers
no
> > >> > rights.
> > >> >>
> > >> >> "Lance" <Lance@.discussions.microsoft.com> wrote in message
> > >> >> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
> > >> >> > We have built a new front end to the report server to run
reports.
> > >> >> > When
> > >> >> > making calls to the RS Web Service, is there anything special
that
> > >> >> > needs
> > >> >> > to
> > >> >> > be done for Excel (xls) rendering? We have a few clients
utlizing
> > >> >> > Apple
> > >> >> > MAC
> > >> >> > OS X with Office v.x. We thought that SP1 would take care of
> their
> > >> >> > ability
> > >> >> > to open the xls files as with prior versions of PC xls before
> Office
> > >> >> > XP.
> > >> >> > After further testing, the MAC version still does not open the
> excel
> > >> > file
> > >> >> > correctly. It only has MIME type values in the file. What are
> the
> > >> >> > options
> > >> >> > to ensure MAC Excel opens the same as PC Excel with SP1? We
> > > currently
> > >> >> > have
> > >> >> > them export to CSV and then open that in excel with the text to
> > > columns
> > >> >> > re-formatting. Any help you could provide would be greatly
> > >> >> > appreciated.
> > >> >>
> > >> >>
> > >> >
> > >> >
> > >>
> > >>
> > >
> > >
> >
> >
>|||We aren't generating MIME any more. That code is gone. Something else must
be wrong with the file type. We will take a look but it is not a highly
demanded scenario.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lance" <ldacy@.fellowshiptech.com> wrote in message
news:%23FHK6dSiEHA.2952@.TK2MSFTNGP09.phx.gbl...
> Any suggestions or comments?
>
> "Lance" <ldacy@.fellowshiptech.com> wrote in message
> news:%23K488YfhEHA.3928@.TK2MSFTNGP11.phx.gbl...
>> I understand that, but the MAC version still gets this MIME
>> document...The
>> PC version is fine.
>>
>> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
>> news:%239umLe7gEHA.3548@.TK2MSFTNGP09.phx.gbl...
>> > In SP1, we support Excel 97 and 2000. You should not get a MIME
>> > document
>> > after applying the service pack.
>> >
>> > --
>> > Brian Welcker
>> > Group Program Manager
>> > Microsoft SQL Server Reporting Services
>> >
>> > This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> >
>> > "Lance" <ldacy@.fellowshiptech.com> wrote in message
>> > news:Og9BSRGgEHA.3964@.TK2MSFTNGP12.phx.gbl...
>> > > The document is garbage...It looks exactly what happens when someone
> who
>> > > has
>> > > a lower version of excel than XP.
>> > >
>> > >
>> > > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in
> message
>> > > news:enJe9r8fEHA.536@.TK2MSFTNGP11.phx.gbl...
>> > >> So what happens if you open the workbook directly in Excel on the
>> > >> mac
>> > > (don't
>> > >> open it in PC Excel)?
>> > >>
>> > >> --
>> > >> Brian Welcker
>> > >> Group Program Manager
>> > >> SQL Server Reporting Services
>> > >>
>> > >> This posting is provided "AS IS" with no warranties, and confers no
>> > > rights.
>> > >>
>> > >> "Lance" <ldacy@.fellowshiptech.com> wrote in message
>> > >> news:ueFapmtfEHA.2848@.TK2MSFTNGP10.phx.gbl...
>> > >> > Yes...It works fine if I save down to Excel 95-2000 workbook and
> then
>> > > send
>> > >> > it. The mac opens fine, but that is not a viable solution to our
>> > > problem
>> > >> > as
>> > >> > the mac clients will need to run reports on demand. Do you by
> chance
>> > > know
>> > >> > if there is a solution in the works to ensure MAC Excel versions
>> export
>> > >> > without incidence as the PC version?
>> > >> >
>> > >> > Thanks...
>> > >> >
>> > >> > "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in
>> message
>> > >> > news:Ohc$PCnfEHA.2764@.TK2MSFTNGP11.phx.gbl...
>> > >> >> Have you tried to export the file using a PC, save it to disk and
>> then
>> > >> > open
>> > >> >> it on the Mac? I wouldn't be surprised if there were some
> glitches.
>> > >> >>
>> > >> >> --
>> > >> >> Brian Welcker
>> > >> >> Group Program Manager
>> > >> >> Microsoft SQL Server Reporting Services
>> > >> >>
>> > >> >> This posting is provided "AS IS" with no warranties, and confers
> no
>> > >> > rights.
>> > >> >>
>> > >> >> "Lance" <Lance@.discussions.microsoft.com> wrote in message
>> > >> >> news:061952A6-F39C-49F3-AA13-F568C4588772@.microsoft.com...
>> > >> >> > We have built a new front end to the report server to run
> reports.
>> > >> >> > When
>> > >> >> > making calls to the RS Web Service, is there anything special
> that
>> > >> >> > needs
>> > >> >> > to
>> > >> >> > be done for Excel (xls) rendering? We have a few clients
> utlizing
>> > >> >> > Apple
>> > >> >> > MAC
>> > >> >> > OS X with Office v.x. We thought that SP1 would take care of
>> their
>> > >> >> > ability
>> > >> >> > to open the xls files as with prior versions of PC xls before
>> Office
>> > >> >> > XP.
>> > >> >> > After further testing, the MAC version still does not open the
>> excel
>> > >> > file
>> > >> >> > correctly. It only has MIME type values in the file. What are
>> the
>> > >> >> > options
>> > >> >> > to ensure MAC Excel opens the same as PC Excel with SP1? We
>> > > currently
>> > >> >> > have
>> > >> >> > them export to CSV and then open that in excel with the text to
>> > > columns
>> > >> >> > re-formatting. Any help you could provide would be greatly
>> > >> >> > appreciated.
>> > >> >>
>> > >> >>
>> > >> >
>> > >> >
>> > >>
>> > >>
>> > >
>> > >
>> >
>> >
>>
>

Mac/Safari - SQL Server Report, Collapse on left side

Hello,

We are using SQL Server Reporting services in our web application. When we view the report on IE/FF it works normally.
But when we view it on Safari on MAC/Windows the report is collapse towards left. It is not taking the width as provided.
When we view the PDF it shows the normal report.

How can this issue be solved ?

Thanks,
Deepesh Verma

Hi,

In Reporting Services, you use a Web browser to view reports and run Report Manager. Not all report functionality is supported by all browsers. The following table describes report functionality restrictions for the supported browsers.

Browser type

DescriptionMicrosoft Internet Explorer 6.0 or 7.0 for Windows, with all service packs applied and scripting enabled.Internet Explorer is recommended if you want to use all the available report functionality. Although you can use other browsers to view a report, Internet Explorer for Windows is the only browser that is guaranteed to support the complete set of features for working with reports.Netscape 7.2, Mozilla 1.7, Firefox 1.0.3, Safari 1.3, and Safari 2.0The following features are not supported in third-party browsers:· Document map· Searching within the report· Zoom· Fixed table headersThe following additional features are not available when viewing reports in Safari:· The Calendar control that is used to select dates on a parameterized report that runs on a report server has been disabled for Safari. Users must type the dates that they want to use.· Image source files that are retrieved from remote computers do not display correctly in Safari.· The client-side print control used for printing HTML reports.

If you are accessing a report server from a Macintosh computer, we recommend that you use Safari. Reporting Services does not support Internet Explorer 5.0 for the Mac.

For details, see
http://msdn2.microsoft.com/en-us/library/ms156511.aspx

Thanks.

|||

Hello,

Thanks.

But any how we want it to work on Sarafi and we did it by putting a transparent image with the width we want to display.

And it worked for us.

Thanks,
Deepesh Verma

LSASS.EXE high CPU usage

I have a web/SQL server (Win2k3sp1, SQL2005) currently experiencing a serious
problem.
Regularly throughout the day, the LSASS.EXE process jumps from <2% CPU usage
to 50-70% CPU, sometime for 30 seconds, sometimes as long as 30 minutes. The
consequence of course being that the server goes to a constant 100% CPU
usage, causing services to be denied or be unacceptably slow. During normal
operation (when LSASS is behaving), the server spec is more than enough to
cope with it's workload, and runs at around 20% CPU usage.
There were issues with LSASS.EXE in Win2k, but none that I know of or can
find in Win2k3. This is not a SASSER type worm virus, it's genuine LSASS.EXE.
I'm not even sure if this is the cause of the problem or a symptom of
something else.
Please suggest something, this is a critical production server and this has
now become a serious issue.
Thanks.
Could you check in your eventLog and see if there are repeated error
messages , particuarly in Directory Services Log?
Jack Vamvas
__________________________________________________ ________________
Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
"The Vogon" <TheVogon@.discussions.microsoft.com> wrote in message
news:0CB0C2E5-4AC5-4F71-B7D7-16180F368002@.microsoft.com...
> I have a web/SQL server (Win2k3sp1, SQL2005) currently experiencing a
serious
> problem.
> Regularly throughout the day, the LSASS.EXE process jumps from <2% CPU
usage
> to 50-70% CPU, sometime for 30 seconds, sometimes as long as 30 minutes.
The
> consequence of course being that the server goes to a constant 100% CPU
> usage, causing services to be denied or be unacceptably slow. During
normal
> operation (when LSASS is behaving), the server spec is more than enough to
> cope with it's workload, and runs at around 20% CPU usage.
> There were issues with LSASS.EXE in Win2k, but none that I know of or can
> find in Win2k3. This is not a SASSER type worm virus, it's genuine
LSASS.EXE.
> I'm not even sure if this is the cause of the problem or a symptom of
> something else.
> Please suggest something, this is a critical production server and this
has
> now become a serious issue.
> Thanks.
>
|||Thanks for the reply...
There are no errors regarding this in the log files, no out of the ordinary
errors or warnings are generated. Incidentally, the server is not a Domain
Controller so no DS logs.
"Jack Vamvas" wrote:

> Could you check in your eventLog and see if there are repeated error
> messages , particuarly in Directory Services Log?
> --
> Jack Vamvas
> __________________________________________________ ________________
> Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
> SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
> New article by Jack Vamvas - SQL and Markov Chains -
> www.ciquery.com/articles/art_04.asp
> "The Vogon" <TheVogon@.discussions.microsoft.com> wrote in message
> news:0CB0C2E5-4AC5-4F71-B7D7-16180F368002@.microsoft.com...
> serious
> usage
> The
> normal
> LSASS.EXE.
> has
>
>

LSASS.EXE high CPU usage

I have a web/SQL server (Win2k3sp1, SQL2005) currently experiencing a serious
problem.
Regularly throughout the day, the LSASS.EXE process jumps from <2% CPU usage
to 50-70% CPU, sometime for 30 seconds, sometimes as long as 30 minutes. The
consequence of course being that the server goes to a constant 100% CPU
usage, causing services to be denied or be unacceptably slow. During normal
operation (when LSASS is behaving), the server spec is more than enough to
cope with it's workload, and runs at around 20% CPU usage.
There were issues with LSASS.EXE in Win2k, but none that I know of or can
find in Win2k3. This is not a SASSER type worm virus, it's genuine LSASS.EXE.
I'm not even sure if this is the cause of the problem or a symptom of
something else.
Please suggest something, this is a critical production server and this has
now become a serious issue.
Thanks.Could you check in your eventLog and see if there are repeated error
messages , particuarly in Directory Services Log?
--
Jack Vamvas
__________________________________________________________________
Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
"The Vogon" <TheVogon@.discussions.microsoft.com> wrote in message
news:0CB0C2E5-4AC5-4F71-B7D7-16180F368002@.microsoft.com...
> I have a web/SQL server (Win2k3sp1, SQL2005) currently experiencing a
serious
> problem.
> Regularly throughout the day, the LSASS.EXE process jumps from <2% CPU
usage
> to 50-70% CPU, sometime for 30 seconds, sometimes as long as 30 minutes.
The
> consequence of course being that the server goes to a constant 100% CPU
> usage, causing services to be denied or be unacceptably slow. During
normal
> operation (when LSASS is behaving), the server spec is more than enough to
> cope with it's workload, and runs at around 20% CPU usage.
> There were issues with LSASS.EXE in Win2k, but none that I know of or can
> find in Win2k3. This is not a SASSER type worm virus, it's genuine
LSASS.EXE.
> I'm not even sure if this is the cause of the problem or a symptom of
> something else.
> Please suggest something, this is a critical production server and this
has
> now become a serious issue.
> Thanks.
>|||Thanks for the reply...
There are no errors regarding this in the log files, no out of the ordinary
errors or warnings are generated. Incidentally, the server is not a Domain
Controller so no DS logs.
"Jack Vamvas" wrote:
> Could you check in your eventLog and see if there are repeated error
> messages , particuarly in Directory Services Log?
> --
> Jack Vamvas
> __________________________________________________________________
> Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
> SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
> New article by Jack Vamvas - SQL and Markov Chains -
> www.ciquery.com/articles/art_04.asp
> "The Vogon" <TheVogon@.discussions.microsoft.com> wrote in message
> news:0CB0C2E5-4AC5-4F71-B7D7-16180F368002@.microsoft.com...
> > I have a web/SQL server (Win2k3sp1, SQL2005) currently experiencing a
> serious
> > problem.
> >
> > Regularly throughout the day, the LSASS.EXE process jumps from <2% CPU
> usage
> > to 50-70% CPU, sometime for 30 seconds, sometimes as long as 30 minutes.
> The
> > consequence of course being that the server goes to a constant 100% CPU
> > usage, causing services to be denied or be unacceptably slow. During
> normal
> > operation (when LSASS is behaving), the server spec is more than enough to
> > cope with it's workload, and runs at around 20% CPU usage.
> >
> > There were issues with LSASS.EXE in Win2k, but none that I know of or can
> > find in Win2k3. This is not a SASSER type worm virus, it's genuine
> LSASS.EXE.
> > I'm not even sure if this is the cause of the problem or a symptom of
> > something else.
> >
> > Please suggest something, this is a critical production server and this
> has
> > now become a serious issue.
> >
> > Thanks.
> >
> >
>
>

LSASS.EXE high CPU usage

I have a web/SQL server (Win2k3sp1, SQL2005) currently experiencing a seriou
s
problem.
Regularly throughout the day, the LSASS.EXE process jumps from <2% CPU usage
to 50-70% CPU, sometime for 30 seconds, sometimes as long as 30 minutes. The
consequence of course being that the server goes to a constant 100% CPU
usage, causing services to be denied or be unacceptably slow. During normal
operation (when LSASS is behaving), the server spec is more than enough to
cope with it's workload, and runs at around 20% CPU usage.
There were issues with LSASS.EXE in Win2k, but none that I know of or can
find in Win2k3. This is not a SASSER type worm virus, it's genuine LSASS.EXE
.
I'm not even sure if this is the cause of the problem or a symptom of
something else.
Please suggest something, this is a critical production server and this has
now become a serious issue.
Thanks.Could you check in your eventLog and see if there are repeated error
messages , particuarly in Directory Services Log?
Jack Vamvas
________________________________________
__________________________
Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
"The Vogon" <TheVogon@.discussions.microsoft.com> wrote in message
news:0CB0C2E5-4AC5-4F71-B7D7-16180F368002@.microsoft.com...
> I have a web/SQL server (Win2k3sp1, SQL2005) currently experiencing a
serious
> problem.
> Regularly throughout the day, the LSASS.EXE process jumps from <2% CPU
usage
> to 50-70% CPU, sometime for 30 seconds, sometimes as long as 30 minutes.
The
> consequence of course being that the server goes to a constant 100% CPU
> usage, causing services to be denied or be unacceptably slow. During
normal
> operation (when LSASS is behaving), the server spec is more than enough to
> cope with it's workload, and runs at around 20% CPU usage.
> There were issues with LSASS.EXE in Win2k, but none that I know of or can
> find in Win2k3. This is not a SASSER type worm virus, it's genuine
LSASS.EXE.
> I'm not even sure if this is the cause of the problem or a symptom of
> something else.
> Please suggest something, this is a critical production server and this
has
> now become a serious issue.
> Thanks.
>|||Thanks for the reply...
There are no errors regarding this in the log files, no out of the ordinary
errors or warnings are generated. Incidentally, the server is not a Domain
Controller so no DS logs.
"Jack Vamvas" wrote:

> Could you check in your eventLog and see if there are repeated error
> messages , particuarly in Directory Services Log?
> --
> Jack Vamvas
> ________________________________________
__________________________
> Receive free SQL tips - register at www.ciquery.com/sqlserver.htm
> SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
> New article by Jack Vamvas - SQL and Markov Chains -
> www.ciquery.com/articles/art_04.asp
> "The Vogon" <TheVogon@.discussions.microsoft.com> wrote in message
> news:0CB0C2E5-4AC5-4F71-B7D7-16180F368002@.microsoft.com...
> serious
> usage
> The
> normal
> LSASS.EXE.
> has
>
>