Hi all,
I have a relatively straight forward report with a Table and a grouping on
the details group. I have the the ToggleItem property of the details group
set to the first cell of the detail row, and it renders as expected in HTML.
(An expand/collapse graphic appears to the left of the cell and dynamically
shows/hides the child rows when clicked.) However, when I export to Excel
the groupings are lost and I see only the root rows and none of the children.
From my understanding the export should render the child rows using the
Outline feature of Excel, but for the life of me I can't get this to work.
Any suggestions on what I'm doing wrong here?
Thanks
BillHello Bill,
If you have drill down reports then you could use show-and-hide toggle
<different from hidden items> and if rendering is done in HTML then it will
show collapsed items so that users can click on the toggle to view hidden
groups.
Using other rendering extension like Excel then the drill down effect is
not supported.
Please see the following topic in Books On-Line for Reporting Services:
Drill Down Reports and Hidden Items.
<http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/h
tm/rcr_creating_interactive_v1_8bg4.asp>
Based on my test, Toggleitem feature seems to work for Matrix after
exporting to Excel. However, it does not work properly for table after
exporting to Excel. I think it needs to contain all of the data and then
provide the ability to toggle but apprarently these data is not included in
this situation.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Excel export drill-down problem (sp2)
| thread-index: AcWMm3svM+OGxhhzSJqE5HRfXsUjew==| X-WBNR-Posting-Host: 156.153.255.243
| From: =?Utf-8?B?QmlsbCBNZXJz?= <billmers@.newsgroup.nospam>
| Subject: Excel export drill-down problem (sp2)
| Date: Tue, 19 Jul 2005 12:53:06 -0700
| Lines: 15
| Message-ID: <452B550C-8D48-4B08-9805-D213BE226172@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:48405
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hi all,
|
| I have a relatively straight forward report with a Table and a grouping
on
| the details group. I have the the ToggleItem property of the details
group
| set to the first cell of the detail row, and it renders as expected in
HTML.
| (An expand/collapse graphic appears to the left of the cell and
dynamically
| shows/hides the child rows when clicked.) However, when I export to
Excel
| the groupings are lost and I see only the root rows and none of the
children.
| From my understanding the export should render the child rows using the
| Outline feature of Excel, but for the life of me I can't get this to work.
|
| Any suggestions on what I'm doing wrong here?
|
| Thanks
| Bill
||||Hi Peter,
I've seen quite a few posts on this newsgroup from other people who have
gotten the "Outlining" feature of Excel to work when rendering from Reporting
Services. How is this done?
If it's only supported through a Matrix report that's ok, however I was
unable to get that working either. I saw the same behavior as before, where
the Matrix renders with expand/collapse columns in HTML and they disappear in
Excel. If I have to write an Excel-specific version of the report that's ok,
but I can't get the Outlining feature to work at all.
I have a hard (non-negotiable) requirement to get this feature working, so
any help would be greatly appreciated!
Thanks
"Peter Yang [MSFT]" wrote:
> Hello Bill,
> If you have drill down reports then you could use show-and-hide toggle
> <different from hidden items> and if rendering is done in HTML then it will
> show collapsed items so that users can click on the toggle to view hidden
> groups.
> Using other rendering extension like Excel then the drill down effect is
> not supported.
> Please see the following topic in Books On-Line for Reporting Services:
> Drill Down Reports and Hidden Items.
> <http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/h
> tm/rcr_creating_interactive_v1_8bg4.asp>
> Based on my test, Toggleitem feature seems to work for Matrix after
> exporting to Excel. However, it does not work properly for table after
> exporting to Excel. I think it needs to contain all of the data and then
> provide the ability to toggle but apprarently these data is not included in
> this situation.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
> --
> | Thread-Topic: Excel export drill-down problem (sp2)
> | thread-index: AcWMm3svM+OGxhhzSJqE5HRfXsUjew==> | X-WBNR-Posting-Host: 156.153.255.243
> | From: =?Utf-8?B?QmlsbCBNZXJz?= <billmers@.newsgroup.nospam>
> | Subject: Excel export drill-down problem (sp2)
> | Date: Tue, 19 Jul 2005 12:53:06 -0700
> | Lines: 15
> | Message-ID: <452B550C-8D48-4B08-9805-D213BE226172@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:48405
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Hi all,
> |
> | I have a relatively straight forward report with a Table and a grouping
> on
> | the details group. I have the the ToggleItem property of the details
> group
> | set to the first cell of the detail row, and it renders as expected in
> HTML.
> | (An expand/collapse graphic appears to the left of the cell and
> dynamically
> | shows/hides the child rows when clicked.) However, when I export to
> Excel
> | the groupings are lost and I see only the root rows and none of the
> children.
> | From my understanding the export should render the child rows using the
> | Outline feature of Excel, but for the life of me I can't get this to work.
> |
> | Any suggestions on what I'm doing wrong here?
> |
> | Thanks
> | Bill
> |
>|||I have table (not Matrix) where it does use the outlining feature. I created
a drill down report and everything worked as advertised in Excel. I'm a loss
at why it isn't for you but it did for me. I only have a single level of
drill down and haven't tried multiple levels (just trying to think what
might be different for you). Create a simple report with a single drilldown,
does it work or not for you?
Anyway, just thought I would let you know that it does work with tables.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bill Mers" <billmers@.newsgroup.nospam> wrote in message
news:E2AA4A4B-09D6-400C-AF2A-657366E71870@.microsoft.com...
> Hi Peter,
> I've seen quite a few posts on this newsgroup from other people who have
> gotten the "Outlining" feature of Excel to work when rendering from
> Reporting
> Services. How is this done?
> If it's only supported through a Matrix report that's ok, however I was
> unable to get that working either. I saw the same behavior as before,
> where
> the Matrix renders with expand/collapse columns in HTML and they disappear
> in
> Excel. If I have to write an Excel-specific version of the report that's
> ok,
> but I can't get the Outlining feature to work at all.
> I have a hard (non-negotiable) requirement to get this feature working, so
> any help would be greatly appreciated!
> Thanks
> "Peter Yang [MSFT]" wrote:
>> Hello Bill,
>> If you have drill down reports then you could use show-and-hide toggle
>> <different from hidden items> and if rendering is done in HTML then it
>> will
>> show collapsed items so that users can click on the toggle to view hidden
>> groups.
>> Using other rendering extension like Excel then the drill down effect is
>> not supported.
>> Please see the following topic in Books On-Line for Reporting Services:
>> Drill Down Reports and Hidden Items.
>> <http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/h
>> tm/rcr_creating_interactive_v1_8bg4.asp>
>> Based on my test, Toggleitem feature seems to work for Matrix after
>> exporting to Excel. However, it does not work properly for table after
>> exporting to Excel. I think it needs to contain all of the data and then
>> provide the ability to toggle but apprarently these data is not included
>> in
>> this situation.
>> Best Regards,
>> Peter Yang
>> MCSE2000/2003, MCSA, MCDBA
>> Microsoft Online Partner Support
>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> =====================================================>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>>
>> --
>> | Thread-Topic: Excel export drill-down problem (sp2)
>> | thread-index: AcWMm3svM+OGxhhzSJqE5HRfXsUjew==>> | X-WBNR-Posting-Host: 156.153.255.243
>> | From: =?Utf-8?B?QmlsbCBNZXJz?= <billmers@.newsgroup.nospam>
>> | Subject: Excel export drill-down problem (sp2)
>> | Date: Tue, 19 Jul 2005 12:53:06 -0700
>> | Lines: 15
>> | Message-ID: <452B550C-8D48-4B08-9805-D213BE226172@.microsoft.com>
>> | MIME-Version: 1.0
>> | Content-Type: text/plain;
>> | charset="Utf-8"
>> | Content-Transfer-Encoding: 7bit
>> | X-Newsreader: Microsoft CDO for Windows 2000
>> | Content-Class: urn:content-classes:message
>> | Importance: normal
>> | Priority: normal
>> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
>> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>> | Xref: TK2MSFTNGXA01.phx.gbl
>> microsoft.public.sqlserver.reportingsvcs:48405
>> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>> |
>> | Hi all,
>> |
>> | I have a relatively straight forward report with a Table and a grouping
>> on
>> | the details group. I have the the ToggleItem property of the details
>> group
>> | set to the first cell of the detail row, and it renders as expected in
>> HTML.
>> | (An expand/collapse graphic appears to the left of the cell and
>> dynamically
>> | shows/hides the child rows when clicked.) However, when I export to
>> Excel
>> | the groupings are lost and I see only the root rows and none of the
>> children.
>> | From my understanding the export should render the child rows using
>> the
>> | Outline feature of Excel, but for the life of me I can't get this to
>> work.
>> |
>> | Any suggestions on what I'm doing wrong here?
>> |
>> | Thanks
>> | Bill
>> |
>>|||Hi Bruce,
Thanks for the confirmation that the Excel outling feature does work with
just a straight table. Somebody on my team was able to get it to work as
well, however we still can't get it working with my particular report. What
I suspect might be making the difference is that my report has both the
grouping and toggleItem set on the same row. The table has only two rows in
it: the header row and the details row, and the first column in the detail
row is the toggle for the whole row. This renders fine in HTML but doesn't
export to Excel correctly.
Anybody have any ideas on how to get this to work? I've opened a trouble
ticket with Microsoft but so far that hasn't solved the issue. Any
alternatives/workarounds would be much appreciated.
Thanks
Bill
"Bruce L-C [MVP]" wrote:
> I have table (not Matrix) where it does use the outlining feature. I created
> a drill down report and everything worked as advertised in Excel. I'm a loss
> at why it isn't for you but it did for me. I only have a single level of
> drill down and haven't tried multiple levels (just trying to think what
> might be different for you). Create a simple report with a single drilldown,
> does it work or not for you?
> Anyway, just thought I would let you know that it does work with tables.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Bill Mers" <billmers@.newsgroup.nospam> wrote in message
> news:E2AA4A4B-09D6-400C-AF2A-657366E71870@.microsoft.com...
> > Hi Peter,
> >
> > I've seen quite a few posts on this newsgroup from other people who have
> > gotten the "Outlining" feature of Excel to work when rendering from
> > Reporting
> > Services. How is this done?
> >
> > If it's only supported through a Matrix report that's ok, however I was
> > unable to get that working either. I saw the same behavior as before,
> > where
> > the Matrix renders with expand/collapse columns in HTML and they disappear
> > in
> > Excel. If I have to write an Excel-specific version of the report that's
> > ok,
> > but I can't get the Outlining feature to work at all.
> >
> > I have a hard (non-negotiable) requirement to get this feature working, so
> > any help would be greatly appreciated!
> >
> > Thanks
> >
> > "Peter Yang [MSFT]" wrote:
> >
> >> Hello Bill,
> >>
> >> If you have drill down reports then you could use show-and-hide toggle
> >> <different from hidden items> and if rendering is done in HTML then it
> >> will
> >> show collapsed items so that users can click on the toggle to view hidden
> >> groups.
> >>
> >> Using other rendering extension like Excel then the drill down effect is
> >> not supported.
> >>
> >> Please see the following topic in Books On-Line for Reporting Services:
> >> Drill Down Reports and Hidden Items.
> >> <http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/h
> >> tm/rcr_creating_interactive_v1_8bg4.asp>
> >>
> >> Based on my test, Toggleitem feature seems to work for Matrix after
> >> exporting to Excel. However, it does not work properly for table after
> >> exporting to Excel. I think it needs to contain all of the data and then
> >> provide the ability to toggle but apprarently these data is not included
> >> in
> >> this situation.
> >>
> >> Best Regards,
> >>
> >> Peter Yang
> >> MCSE2000/2003, MCSA, MCDBA
> >> Microsoft Online Partner Support
> >>
> >> When responding to posts, please "Reply to Group" via your newsreader so
> >> that others may learn and benefit from your issue.
> >>
> >> =====================================================> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >>
> >>
> >> --
> >> | Thread-Topic: Excel export drill-down problem (sp2)
> >> | thread-index: AcWMm3svM+OGxhhzSJqE5HRfXsUjew==> >> | X-WBNR-Posting-Host: 156.153.255.243
> >> | From: =?Utf-8?B?QmlsbCBNZXJz?= <billmers@.newsgroup.nospam>
> >> | Subject: Excel export drill-down problem (sp2)
> >> | Date: Tue, 19 Jul 2005 12:53:06 -0700
> >> | Lines: 15
> >> | Message-ID: <452B550C-8D48-4B08-9805-D213BE226172@.microsoft.com>
> >> | MIME-Version: 1.0
> >> | Content-Type: text/plain;
> >> | charset="Utf-8"
> >> | Content-Transfer-Encoding: 7bit
> >> | X-Newsreader: Microsoft CDO for Windows 2000
> >> | Content-Class: urn:content-classes:message
> >> | Importance: normal
> >> | Priority: normal
> >> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> >> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> >> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> >> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> >> | Xref: TK2MSFTNGXA01.phx.gbl
> >> microsoft.public.sqlserver.reportingsvcs:48405
> >> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> >> |
> >> | Hi all,
> >> |
> >> | I have a relatively straight forward report with a Table and a grouping
> >> on
> >> | the details group. I have the the ToggleItem property of the details
> >> group
> >> | set to the first cell of the detail row, and it renders as expected in
> >> HTML.
> >> | (An expand/collapse graphic appears to the left of the cell and
> >> dynamically
> >> | shows/hides the child rows when clicked.) However, when I export to
> >> Excel
> >> | the groupings are lost and I see only the root rows and none of the
> >> children.
> >> | From my understanding the export should render the child rows using
> >> the
> >> | Outline feature of Excel, but for the life of me I can't get this to
> >> work.
> >> |
> >> | Any suggestions on what I'm doing wrong here?
> >> |
> >> | Thanks
> >> | Bill
> >> |
> >>
> >>
>
>|||Hello Bill,
Based on my further test, I found if I use the following method, I could
export the Excel as expected:
1. In Layout view, click the table so that column and row handles appear
above and next to the table or matrix.
2. Right-click the corner handle of the table or matrix, and then click
Properties.
3. On the Groups tab, select the group to edit, and then click Edit.
4. On the Visibility tab, do the following:
5. For Initial visibility, select Hidden.
6. Select Visibility can be toggled by another report item.
7. In Report item, type or select the name of the text box that users click
to show the selected item. I selected Textbox1.
Note: The value for Report item must be the name of a text box that is
either in the same group as the item that is being hidden or in another
group or item in the same container hierarchy (up to and including the
report body).
By using the following method, I reproduced the issue you encountered:
1. In Layout view, click the table so that column and row handles appear
above and next to the table or matrix.
2. Right-click the detail handle of the table or matrix, and then click
Edit Group
3. On the Visibility tab, do the following:
4. For Initial visibility, select Hidden.
5. Select Visibility can be toggled by another report item.
6. In Report item, type or select the name of the text box that users click
to show the selected item. I selected Textbox1.
Though in HTML rendering, above methods have the same behavior, they are
different in Excel rendering.
By checking the RDL code, I found the differenences between them.
1. For the 1st method, the <visibility> entry is included in <Tablegroup>
item. The data of the table is included in this report even the report is
collapsed.
2. For the 2nd method, the <visibility> entry is in <details> item, the
data that is necessary to toggle is not actaully included in this
situation.
Hope this information is helpful.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Excel export drill-down problem (sp2)
| thread-index: AcWRO/qqj6RePYO2SkSf0MlULM92LQ==| X-WBNR-Posting-Host: 161.114.64.75
| From: =?Utf-8?B?QmlsbCBNZXJz?= <billmers@.newsgroup.nospam>
| References: <452B550C-8D48-4B08-9805-D213BE226172@.microsoft.com>
<V8UcOnQjFHA.3120@.TK2MSFTNGXA01.phx.gbl>
<E2AA4A4B-09D6-400C-AF2A-657366E71870@.microsoft.com>
<OK###2TjFHA.3568@.tk2msftngp13.phx.gbl>
| Subject: Re: Excel export drill-down problem (sp2)
| Date: Mon, 25 Jul 2005 10:12:04 -0700
| Lines: 154
| Message-ID: <3C668BC0-EF6A-4453-AC4E-FB10A1EE5F68@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:48828
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hi Bruce,
|
| Thanks for the confirmation that the Excel outling feature does work with
| just a straight table. Somebody on my team was able to get it to work as
| well, however we still can't get it working with my particular report.
What
| I suspect might be making the difference is that my report has both the
| grouping and toggleItem set on the same row. The table has only two rows
in
| it: the header row and the details row, and the first column in the
detail
| row is the toggle for the whole row. This renders fine in HTML but
doesn't
| export to Excel correctly.
|
| Anybody have any ideas on how to get this to work? I've opened a trouble
| ticket with Microsoft but so far that hasn't solved the issue. Any
| alternatives/workarounds would be much appreciated.
|
| Thanks
| Bill
|
| "Bruce L-C [MVP]" wrote:
|
| > I have table (not Matrix) where it does use the outlining feature. I
created
| > a drill down report and everything worked as advertised in Excel. I'm a
loss
| > at why it isn't for you but it did for me. I only have a single level
of
| > drill down and haven't tried multiple levels (just trying to think what
| > might be different for you). Create a simple report with a single
drilldown,
| > does it work or not for you?
| >
| > Anyway, just thought I would let you know that it does work with tables.
| >
| >
| > --
| > Bruce Loehle-Conger
| > MVP SQL Server Reporting Services
| >
| >
| > "Bill Mers" <billmers@.newsgroup.nospam> wrote in message
| > news:E2AA4A4B-09D6-400C-AF2A-657366E71870@.microsoft.com...
| > > Hi Peter,
| > >
| > > I've seen quite a few posts on this newsgroup from other people who
have
| > > gotten the "Outlining" feature of Excel to work when rendering from
| > > Reporting
| > > Services. How is this done?
| > >
| > > If it's only supported through a Matrix report that's ok, however I
was
| > > unable to get that working either. I saw the same behavior as
before,
| > > where
| > > the Matrix renders with expand/collapse columns in HTML and they
disappear
| > > in
| > > Excel. If I have to write an Excel-specific version of the report
that's
| > > ok,
| > > but I can't get the Outlining feature to work at all.
| > >
| > > I have a hard (non-negotiable) requirement to get this feature
working, so
| > > any help would be greatly appreciated!
| > >
| > > Thanks
| > >
| > > "Peter Yang [MSFT]" wrote:
| > >
| > >> Hello Bill,
| > >>
| > >> If you have drill down reports then you could use show-and-hide
toggle
| > >> <different from hidden items> and if rendering is done in HTML then
it
| > >> will
| > >> show collapsed items so that users can click on the toggle to view
hidden
| > >> groups.
| > >>
| > >> Using other rendering extension like Excel then the drill down
effect is
| > >> not supported.
| > >>
| > >> Please see the following topic in Books On-Line for Reporting
Services:
| > >> Drill Down Reports and Hidden Items.
| > >>
<http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/h
| > >> tm/rcr_creating_interactive_v1_8bg4.asp>
| > >>
| > >> Based on my test, Toggleitem feature seems to work for Matrix after
| > >> exporting to Excel. However, it does not work properly for table
after
| > >> exporting to Excel. I think it needs to contain all of the data and
then
| > >> provide the ability to toggle but apprarently these data is not
included
| > >> in
| > >> this situation.
| > >>
| > >> Best Regards,
| > >>
| > >> Peter Yang
| > >> MCSE2000/2003, MCSA, MCDBA
| > >> Microsoft Online Partner Support
| > >>
| > >> When responding to posts, please "Reply to Group" via your
newsreader so
| > >> that others may learn and benefit from your issue.
| > >>
| > >> =====================================================| > >>
| > >> This posting is provided "AS IS" with no warranties, and confers no
| > >> rights.
| > >>
| > >>
| > >>
| > >>
| > >> --
| > >> | Thread-Topic: Excel export drill-down problem (sp2)
| > >> | thread-index: AcWMm3svM+OGxhhzSJqE5HRfXsUjew==| > >> | X-WBNR-Posting-Host: 156.153.255.243
| > >> | From: =?Utf-8?B?QmlsbCBNZXJz?= <billmers@.newsgroup.nospam>
| > >> | Subject: Excel export drill-down problem (sp2)
| > >> | Date: Tue, 19 Jul 2005 12:53:06 -0700
| > >> | Lines: 15
| > >> | Message-ID: <452B550C-8D48-4B08-9805-D213BE226172@.microsoft.com>
| > >> | MIME-Version: 1.0
| > >> | Content-Type: text/plain;
| > >> | charset="Utf-8"
| > >> | Content-Transfer-Encoding: 7bit
| > >> | X-Newsreader: Microsoft CDO for Windows 2000
| > >> | Content-Class: urn:content-classes:message
| > >> | Importance: normal
| > >> | Priority: normal
| > >> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > >> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > >> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| > >> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > >> | Xref: TK2MSFTNGXA01.phx.gbl
| > >> microsoft.public.sqlserver.reportingsvcs:48405
| > >> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > >> |
| > >> | Hi all,
| > >> |
| > >> | I have a relatively straight forward report with a Table and a
grouping
| > >> on
| > >> | the details group. I have the the ToggleItem property of the
details
| > >> group
| > >> | set to the first cell of the detail row, and it renders as
expected in
| > >> HTML.
| > >> | (An expand/collapse graphic appears to the left of the cell and
| > >> dynamically
| > >> | shows/hides the child rows when clicked.) However, when I export
to
| > >> Excel
| > >> | the groupings are lost and I see only the root rows and none of the
| > >> children.
| > >> | From my understanding the export should render the child rows
using
| > >> the
| > >> | Outline feature of Excel, but for the life of me I can't get this
to
| > >> work.
| > >> |
| > >> | Any suggestions on what I'm doing wrong here?
| > >> |
| > >> | Thanks
| > >> | Bill
| > >> |
| > >>
| > >>
| >
| >
| >
||||Did anyone resolve this? I have rendered a report into Excel but only one
user out of 3 (includes me) gets the Excel doc with expand/collapse auto
format. I can't figure out why only she gets the correct format. Any ideas as
to what I need specifiically to check for in Excel?
There are 8 groups with details below each. When she gets report in Excel,
she sees outline symbols (plus , minus, etc.) and it looks great. When I get
the report in Excel, it shows all info but not in outline format. HELP!
thanks
"Peter Yang [MSFT]" wrote:
> Hello Bill,
> Based on my further test, I found if I use the following method, I could
> export the Excel as expected:
> 1. In Layout view, click the table so that column and row handles appear
> above and next to the table or matrix.
> 2. Right-click the corner handle of the table or matrix, and then click
> Properties.
> 3. On the Groups tab, select the group to edit, and then click Edit.
> 4. On the Visibility tab, do the following:
> 5. For Initial visibility, select Hidden.
> 6. Select Visibility can be toggled by another report item.
> 7. In Report item, type or select the name of the text box that users click
> to show the selected item. I selected Textbox1.
> Note: The value for Report item must be the name of a text box that is
> either in the same group as the item that is being hidden or in another
> group or item in the same container hierarchy (up to and including the
> report body).
> By using the following method, I reproduced the issue you encountered:
> 1. In Layout view, click the table so that column and row handles appear
> above and next to the table or matrix.
> 2. Right-click the detail handle of the table or matrix, and then click
> Edit Group
> 3. On the Visibility tab, do the following:
> 4. For Initial visibility, select Hidden.
> 5. Select Visibility can be toggled by another report item.
> 6. In Report item, type or select the name of the text box that users click
> to show the selected item. I selected Textbox1.
> Though in HTML rendering, above methods have the same behavior, they are
> different in Excel rendering.
> By checking the RDL code, I found the differenences between them.
> 1. For the 1st method, the <visibility> entry is included in <Tablegroup>
> item. The data of the table is included in this report even the report is
> collapsed.
> 2. For the 2nd method, the <visibility> entry is in <details> item, the
> data that is necessary to toggle is not actaully included in this
> situation.
> Hope this information is helpful.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> Business-Critical Phone Support (BCPS) provides you with technical phone
> support at no charge during critical LAN outages or "business down"
> situations. This benefit is available 24 hours a day, 7 days a week to all
> Microsoft technology partners in the United States and Canada.
> This and other support options are available here:
> BCPS:
> https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
> Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
> If you are outside the United States, please visit our International
> Support page:
> http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> --
> | Thread-Topic: Excel export drill-down problem (sp2)
> | thread-index: AcWRO/qqj6RePYO2SkSf0MlULM92LQ==> | X-WBNR-Posting-Host: 161.114.64.75
> | From: =?Utf-8?B?QmlsbCBNZXJz?= <billmers@.newsgroup.nospam>
> | References: <452B550C-8D48-4B08-9805-D213BE226172@.microsoft.com>
> <V8UcOnQjFHA.3120@.TK2MSFTNGXA01.phx.gbl>
> <E2AA4A4B-09D6-400C-AF2A-657366E71870@.microsoft.com>
> <OK###2TjFHA.3568@.tk2msftngp13.phx.gbl>
> | Subject: Re: Excel export drill-down problem (sp2)
> | Date: Mon, 25 Jul 2005 10:12:04 -0700
> | Lines: 154
> | Message-ID: <3C668BC0-EF6A-4453-AC4E-FB10A1EE5F68@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:48828
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Hi Bruce,
> |
> | Thanks for the confirmation that the Excel outling feature does work with
> | just a straight table. Somebody on my team was able to get it to work as
> | well, however we still can't get it working with my particular report.
> What
> | I suspect might be making the difference is that my report has both the
> | grouping and toggleItem set on the same row. The table has only two rows
> in
> | it: the header row and the details row, and the first column in the
> detail
> | row is the toggle for the whole row. This renders fine in HTML but
> doesn't
> | export to Excel correctly.
> |
> | Anybody have any ideas on how to get this to work? I've opened a trouble
> | ticket with Microsoft but so far that hasn't solved the issue. Any
> | alternatives/workarounds would be much appreciated.
> |
> | Thanks
> | Bill
> |
> | "Bruce L-C [MVP]" wrote:
> |
> | > I have table (not Matrix) where it does use the outlining feature. I
> created
> | > a drill down report and everything worked as advertised in Excel. I'm a
> loss
> | > at why it isn't for you but it did for me. I only have a single level
> of
> | > drill down and haven't tried multiple levels (just trying to think what
> | > might be different for you). Create a simple report with a single
> drilldown,
> | > does it work or not for you?
> | >
> | > Anyway, just thought I would let you know that it does work with tables.
> | >
> | >
> | > --
> | > Bruce Loehle-Conger
> | > MVP SQL Server Reporting Services
> | >
> | >
> | > "Bill Mers" <billmers@.newsgroup.nospam> wrote in message
> | > news:E2AA4A4B-09D6-400C-AF2A-657366E71870@.microsoft.com...
> | > > Hi Peter,
> | > >
> | > > I've seen quite a few posts on this newsgroup from other people who
> have
> | > > gotten the "Outlining" feature of Excel to work when rendering from
> | > > Reporting
> | > > Services. How is this done?
> | > >
> | > > If it's only supported through a Matrix report that's ok, however I
> was
> | > > unable to get that working either. I saw the same behavior as
> before,
> | > > where
> | > > the Matrix renders with expand/collapse columns in HTML and they
> disappear
> | > > in
> | > > Excel. If I have to write an Excel-specific version of the report
> that's
> | > > ok,
> | > > but I can't get the Outlining feature to work at all.
> | > >
> | > > I have a hard (non-negotiable) requirement to get this feature
> working, so
> | > > any help would be greatly appreciated!
> | > >
> | > > Thanks
> | > >
> | > > "Peter Yang [MSFT]" wrote:
> | > >
> | > >> Hello Bill,
> | > >>
> | > >> If you have drill down reports then you could use show-and-hide
> toggle
> | > >> <different from hidden items> and if rendering is done in HTML then
> it
> | > >> will
> | > >> show collapsed items so that users can click on the toggle to view
> hidden
> | > >> groups.
> | > >>
> | > >> Using other rendering extension like Excel then the drill down
> effect is
> | > >> not supported.
> | > >>
> | > >> Please see the following topic in Books On-Line for Reporting
> Services:
> | > >> Drill Down Reports and Hidden Items.
> | > >>
> <http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/h
> | > >> tm/rcr_creating_interactive_v1_8bg4.asp>
> | > >>
> | > >> Based on my test, Toggleitem feature seems to work for Matrix after
> | > >> exporting to Excel. However, it does not work properly for table
> after
> | > >> exporting to Excel. I think it needs to contain all of the data and
> then
> | > >> provide the ability to toggle but apprarently these data is not
> included
> | > >> in
> | > >> this situation.
> | > >>
> | > >> Best Regards,
> | > >>
> | > >> Peter Yang
> | > >> MCSE2000/2003, MCSA, MCDBA
> | > >> Microsoft Online Partner Support
> | > >>
> | > >> When responding to posts, please "Reply to Group" via your
> newsreader so
> | > >> that others may learn and benefit from your issue.
> | > >>
> | > >> =====================================================> | > >>
> | > >> This posting is provided "AS IS" with no warranties, and confers no
> | > >> rights.
> | > >>
> | > >>
> | > >>
> | > >>
> | > >> --
> | > >> | Thread-Topic: Excel export drill-down problem (sp2)
> | > >> | thread-index: AcWMm3svM+OGxhhzSJqE5HRfXsUjew==> | > >> | X-WBNR-Posting-Host: 156.153.255.243
> | > >> | From: =?Utf-8?B?QmlsbCBNZXJz?= <billmers@.newsgroup.nospam>
> | > >> | Subject: Excel export drill-down problem (sp2)
> | > >> | Date: Tue, 19 Jul 2005 12:53:06 -0700
> | > >> | Lines: 15
> | > >> | Message-ID: <452B550C-8D48-4B08-9805-D213BE226172@.microsoft.com>
> | > >> | MIME-Version: 1.0
> | > >> | Content-Type: text/plain;
> | > >> | charset="Utf-8"
> | > >> | Content-Transfer-Encoding: 7bit
> | > >> | X-Newsreader: Microsoft CDO for Windows 2000
> | > >> | Content-Class: urn:content-classes:message
> | > >> | Importance: normal
> | > >> | Priority: normal
> | > >> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | > >> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | > >> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | > >> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | > >> | Xref: TK2MSFTNGXA01.phx.gbl
> | > >> microsoft.public.sqlserver.reportingsvcs:48405
> | > >> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> | > >> |
> | > >> | Hi all,
> | > >> |
> | > >> | I have a relatively straight forward report with a Table and a
> grouping
> | > >> on
> | > >> | the details group. I have the the ToggleItem property of the
> details
> | > >> group
> | > >> | set to the first cell of the detail row, and it renders as
> expected in
> | > >> HTML.
> | > >> | (An expand/collapse graphic appears to the left of the cell and
> | > >> dynamically
> | > >> | shows/hides the child rows when clicked.) However, when I export
> to
> | > >> Excel
> | > >> | the groupings are lost and I see only the root rows and none of the
> | > >> children.
> | > >> | From my understanding the export should render the child rows
> using
> | > >> the
> | > >> | Outline feature of Excel, but for the life of me I can't get this
> to
> | > >> work.
> | > >> |
> | > >> | Any suggestions on what I'm doing wrong here?
> | > >> |
> | > >> | Thanks
> | > >> | Bill
> | > >> |
> | > >>
> | > >>
> | >
> | >
> | >
> |
>|||I have a table with one group ('table1_state') and a detail part.
What i made now is a dummy group ('table1_dummy') only for handling the
visibility. This dummy group is a child of the table1_state group and
has no footer and no header. Its visibility is set to hidden and the
toggle item is set to the first textbox of table1_state group (in my
case 'txtState').
Check that no other visibility configurations are set.
<TableGroup>
<Grouping Name="table1_dummy">
<GroupExpressions>
<GroupExpression>=Fields!PrimaryKey.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Visibility>
<ToggleItem>txtState</ToggleItem>
<Hidden>true</Hidden>
</Visibility>
</TableGroup>
</TableGroups>|||Bill,
I have the same problem. What is even stranger is that there is an example
sql report that comes with Northwind called "Northwind Simple report", which
also has a single collapible row. This report will export to excel with the
children data while my report with similar settings looses this data.
I have found no reason for this.
Have you had any luck with working out a solution ?
Showing posts with label group. Show all posts
Showing posts with label group. Show all posts
Tuesday, March 27, 2012
Monday, March 26, 2012
Excel Drill Down not showing all details
In my report, I have one group and details. The group has two rows, with the
2nd row's visibility toggled by one of the textboxes in the first row. The
detail row is also toggled by the texbox in the top group row. (the second
row of the group has the titles above the detail row). Anyways, when this
report is run, all of the details show as expected when you drill down.
However, when you export this report to excel and drill down, only the second
group row appears. None of the detail rows appear in excel. Is there a work
around for this?This one has been driving me nuts as well. It croped up while testing SP1
but I may have figured out a work around. Don't set the visibility on the
innermost detail row. It will remain hidden along with row you have your
titles on. So far on the reports I have had time to test they have exported
as expected. I don't have this issue on my pre SP1 production box but need
to have the ability to view exports on Excel 2000 so it is a catch 22. Hope
this helps.
Mark
"dachrist" wrote:
> In my report, I have one group and details. The group has two rows, with the
> 2nd row's visibility toggled by one of the textboxes in the first row. The
> detail row is also toggled by the texbox in the top group row. (the second
> row of the group has the titles above the detail row). Anyways, when this
> report is run, all of the details show as expected when you drill down.
> However, when you export this report to excel and drill down, only the second
> group row appears. None of the detail rows appear in excel. Is there a work
> around for this?|||This one should be addressed in SP2.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"MMishler" <MMishler@.discussions.microsoft.com> wrote in message
news:724B6C3D-493B-4810-AA2B-3C35728CAC8D@.microsoft.com...
> This one has been driving me nuts as well. It croped up while testing SP1
> but I may have figured out a work around. Don't set the visibility on the
> innermost detail row. It will remain hidden along with row you have your
> titles on. So far on the reports I have had time to test they have
> exported
> as expected. I don't have this issue on my pre SP1 production box but
> need
> to have the ability to view exports on Excel 2000 so it is a catch 22.
> Hope
> this helps.
> Mark
> "dachrist" wrote:
>> In my report, I have one group and details. The group has two rows, with
>> the
>> 2nd row's visibility toggled by one of the textboxes in the first row.
>> The
>> detail row is also toggled by the texbox in the top group row. (the
>> second
>> row of the group has the titles above the detail row). Anyways, when
>> this
>> report is run, all of the details show as expected when you drill down.
>> However, when you export this report to excel and drill down, only the
>> second
>> group row appears. None of the detail rows appear in excel. Is there a
>> work
>> around for this?
2nd row's visibility toggled by one of the textboxes in the first row. The
detail row is also toggled by the texbox in the top group row. (the second
row of the group has the titles above the detail row). Anyways, when this
report is run, all of the details show as expected when you drill down.
However, when you export this report to excel and drill down, only the second
group row appears. None of the detail rows appear in excel. Is there a work
around for this?This one has been driving me nuts as well. It croped up while testing SP1
but I may have figured out a work around. Don't set the visibility on the
innermost detail row. It will remain hidden along with row you have your
titles on. So far on the reports I have had time to test they have exported
as expected. I don't have this issue on my pre SP1 production box but need
to have the ability to view exports on Excel 2000 so it is a catch 22. Hope
this helps.
Mark
"dachrist" wrote:
> In my report, I have one group and details. The group has two rows, with the
> 2nd row's visibility toggled by one of the textboxes in the first row. The
> detail row is also toggled by the texbox in the top group row. (the second
> row of the group has the titles above the detail row). Anyways, when this
> report is run, all of the details show as expected when you drill down.
> However, when you export this report to excel and drill down, only the second
> group row appears. None of the detail rows appear in excel. Is there a work
> around for this?|||This one should be addressed in SP2.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"MMishler" <MMishler@.discussions.microsoft.com> wrote in message
news:724B6C3D-493B-4810-AA2B-3C35728CAC8D@.microsoft.com...
> This one has been driving me nuts as well. It croped up while testing SP1
> but I may have figured out a work around. Don't set the visibility on the
> innermost detail row. It will remain hidden along with row you have your
> titles on. So far on the reports I have had time to test they have
> exported
> as expected. I don't have this issue on my pre SP1 production box but
> need
> to have the ability to view exports on Excel 2000 so it is a catch 22.
> Hope
> this helps.
> Mark
> "dachrist" wrote:
>> In my report, I have one group and details. The group has two rows, with
>> the
>> 2nd row's visibility toggled by one of the textboxes in the first row.
>> The
>> detail row is also toggled by the texbox in the top group row. (the
>> second
>> row of the group has the titles above the detail row). Anyways, when
>> this
>> report is run, all of the details show as expected when you drill down.
>> However, when you export this report to excel and drill down, only the
>> second
>> group row appears. None of the detail rows appear in excel. Is there a
>> work
>> around for this?
Excel Drill Down not showing all details
In my report, I have one group and details. The group has two rows, with the
2nd row's visibility toggled by one of the textboxes in the first row. The
detail row is also toggled by the texbox in the top group row. (the second
row of the group has the titles above the detail row). Anyways, when this
report is run, all of the details show as expected when you drill down.
However, when you export this report to excel and drill down, only the second
group row appears. None of the detail rows appear in excel. Is there a work
around for this?Hi dachrist
Welcome to use MSDN Managed Newsgroup Support.
I have tested on my side with SQL Server 2005 Reporting Services. It works
fine.
Does this appear on all the report?
Could you please post the detail steps here about how to design your report?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||I am seeing this behavior in RS2000 sp2.
"Steven Cheng[MSFT]" wrote:
> Hi dachrist
> Welcome to use MSDN Managed Newsgroup Support.
> I have tested on my side with SQL Server 2005 Reporting Services. It works
> fine.
> Does this appear on all the report?
> Could you please post the detail steps here about how to design your report?
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi dachrist,
I have tested in Reporting Service 2000.
If you drill down in the report and then export to the excel, it works
fine. Please have a try. Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
2nd row's visibility toggled by one of the textboxes in the first row. The
detail row is also toggled by the texbox in the top group row. (the second
row of the group has the titles above the detail row). Anyways, when this
report is run, all of the details show as expected when you drill down.
However, when you export this report to excel and drill down, only the second
group row appears. None of the detail rows appear in excel. Is there a work
around for this?Hi dachrist
Welcome to use MSDN Managed Newsgroup Support.
I have tested on my side with SQL Server 2005 Reporting Services. It works
fine.
Does this appear on all the report?
Could you please post the detail steps here about how to design your report?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||I am seeing this behavior in RS2000 sp2.
"Steven Cheng[MSFT]" wrote:
> Hi dachrist
> Welcome to use MSDN Managed Newsgroup Support.
> I have tested on my side with SQL Server 2005 Reporting Services. It works
> fine.
> Does this appear on all the report?
> Could you please post the detail steps here about how to design your report?
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi dachrist,
I have tested in Reporting Service 2000.
If you drill down in the report and then export to the excel, it works
fine. Please have a try. Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
Friday, March 23, 2012
Excel consuming 100% CPU
Hi,
We are using RS Sp2 andExcel XP on the clients.
One report outputs 5000+ rows and are grouped like this:
account group (25 groups)
account (250 groups)
values (4725 rows)
When exported to Excel the XL-file is 11Mb+ !
All groups are collapsed in XL by default, and when trying to work in the
sheet XL consumes all CPU! If all groups are expanded it is possible to work
with the data and there is no unusual CPU consuming.
If collapsing a group again then the CPU consumtion becomes heavy again.
My question, is this a limitation in XL? If it is, does this work better in
XL 2003?
Is there anything we can do to boost performance, as it is now we cant work
in XL...
Any ideas?
/FredrikAt this point this is just an Excel file. It looks like Excel is not
handling that amount of data and that amount of groups very well. You could
ask in Excel newsgroup if XL 2003 might work better for you.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Fredrik" <Fredrik@.discussions.microsoft.com> wrote in message
news:64659432-7804-4443-83D6-454F665C650A@.microsoft.com...
> Hi,
> We are using RS Sp2 andExcel XP on the clients.
> One report outputs 5000+ rows and are grouped like this:
> account group (25 groups)
> account (250 groups)
> values (4725 rows)
> When exported to Excel the XL-file is 11Mb+ !
> All groups are collapsed in XL by default, and when trying to work in the
> sheet XL consumes all CPU! If all groups are expanded it is possible to
> work
> with the data and there is no unusual CPU consuming.
> If collapsing a group again then the CPU consumtion becomes heavy again.
> My question, is this a limitation in XL? If it is, does this work better
> in
> XL 2003?
> Is there anything we can do to boost performance, as it is now we cant
> work
> in XL...
> Any ideas?
> /Fredrik
>|||Tested 2003 but the same problem occured. I would be very happy to now what
the heck is going on in Excel here...
"Bruce L-C [MVP]" wrote:
> At this point this is just an Excel file. It looks like Excel is not
> handling that amount of data and that amount of groups very well. You could
> ask in Excel newsgroup if XL 2003 might work better for you.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Fredrik" <Fredrik@.discussions.microsoft.com> wrote in message
> news:64659432-7804-4443-83D6-454F665C650A@.microsoft.com...
> > Hi,
> > We are using RS Sp2 andExcel XP on the clients.
> > One report outputs 5000+ rows and are grouped like this:
> >
> > account group (25 groups)
> > account (250 groups)
> > values (4725 rows)
> >
> > When exported to Excel the XL-file is 11Mb+ !
> > All groups are collapsed in XL by default, and when trying to work in the
> > sheet XL consumes all CPU! If all groups are expanded it is possible to
> > work
> > with the data and there is no unusual CPU consuming.
> > If collapsing a group again then the CPU consumtion becomes heavy again.
> >
> > My question, is this a limitation in XL? If it is, does this work better
> > in
> > XL 2003?
> > Is there anything we can do to boost performance, as it is now we cant
> > work
> > in XL...
> >
> > Any ideas?
> >
> > /Fredrik
> >
>
>|||The problem may be merged cells or show/hide regions. Excel reports with
thousands of these elements are slow to load because for each new cell they
need to check to see if it intersects with all of the other merged cells.
If you can, removing some of the show/hide elements or other obvious merged
cells and you should see a speed increase in Excel.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Fredrik" <Fredrik@.discussions.microsoft.com> wrote in message
news:3F5CB660-BFB5-4712-A30C-A0081A888A29@.microsoft.com...
> Tested 2003 but the same problem occured. I would be very happy to now
> what
> the heck is going on in Excel here...
> "Bruce L-C [MVP]" wrote:
>> At this point this is just an Excel file. It looks like Excel is not
>> handling that amount of data and that amount of groups very well. You
>> could
>> ask in Excel newsgroup if XL 2003 might work better for you.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Fredrik" <Fredrik@.discussions.microsoft.com> wrote in message
>> news:64659432-7804-4443-83D6-454F665C650A@.microsoft.com...
>> > Hi,
>> > We are using RS Sp2 andExcel XP on the clients.
>> > One report outputs 5000+ rows and are grouped like this:
>> >
>> > account group (25 groups)
>> > account (250 groups)
>> > values (4725 rows)
>> >
>> > When exported to Excel the XL-file is 11Mb+ !
>> > All groups are collapsed in XL by default, and when trying to work in
>> > the
>> > sheet XL consumes all CPU! If all groups are expanded it is possible to
>> > work
>> > with the data and there is no unusual CPU consuming.
>> > If collapsing a group again then the CPU consumtion becomes heavy
>> > again.
>> >
>> > My question, is this a limitation in XL? If it is, does this work
>> > better
>> > in
>> > XL 2003?
>> > Is there anything we can do to boost performance, as it is now we cant
>> > work
>> > in XL...
>> >
>> > Any ideas?
>> >
>> > /Fredrik
>> >
>>
We are using RS Sp2 andExcel XP on the clients.
One report outputs 5000+ rows and are grouped like this:
account group (25 groups)
account (250 groups)
values (4725 rows)
When exported to Excel the XL-file is 11Mb+ !
All groups are collapsed in XL by default, and when trying to work in the
sheet XL consumes all CPU! If all groups are expanded it is possible to work
with the data and there is no unusual CPU consuming.
If collapsing a group again then the CPU consumtion becomes heavy again.
My question, is this a limitation in XL? If it is, does this work better in
XL 2003?
Is there anything we can do to boost performance, as it is now we cant work
in XL...
Any ideas?
/FredrikAt this point this is just an Excel file. It looks like Excel is not
handling that amount of data and that amount of groups very well. You could
ask in Excel newsgroup if XL 2003 might work better for you.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Fredrik" <Fredrik@.discussions.microsoft.com> wrote in message
news:64659432-7804-4443-83D6-454F665C650A@.microsoft.com...
> Hi,
> We are using RS Sp2 andExcel XP on the clients.
> One report outputs 5000+ rows and are grouped like this:
> account group (25 groups)
> account (250 groups)
> values (4725 rows)
> When exported to Excel the XL-file is 11Mb+ !
> All groups are collapsed in XL by default, and when trying to work in the
> sheet XL consumes all CPU! If all groups are expanded it is possible to
> work
> with the data and there is no unusual CPU consuming.
> If collapsing a group again then the CPU consumtion becomes heavy again.
> My question, is this a limitation in XL? If it is, does this work better
> in
> XL 2003?
> Is there anything we can do to boost performance, as it is now we cant
> work
> in XL...
> Any ideas?
> /Fredrik
>|||Tested 2003 but the same problem occured. I would be very happy to now what
the heck is going on in Excel here...
"Bruce L-C [MVP]" wrote:
> At this point this is just an Excel file. It looks like Excel is not
> handling that amount of data and that amount of groups very well. You could
> ask in Excel newsgroup if XL 2003 might work better for you.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Fredrik" <Fredrik@.discussions.microsoft.com> wrote in message
> news:64659432-7804-4443-83D6-454F665C650A@.microsoft.com...
> > Hi,
> > We are using RS Sp2 andExcel XP on the clients.
> > One report outputs 5000+ rows and are grouped like this:
> >
> > account group (25 groups)
> > account (250 groups)
> > values (4725 rows)
> >
> > When exported to Excel the XL-file is 11Mb+ !
> > All groups are collapsed in XL by default, and when trying to work in the
> > sheet XL consumes all CPU! If all groups are expanded it is possible to
> > work
> > with the data and there is no unusual CPU consuming.
> > If collapsing a group again then the CPU consumtion becomes heavy again.
> >
> > My question, is this a limitation in XL? If it is, does this work better
> > in
> > XL 2003?
> > Is there anything we can do to boost performance, as it is now we cant
> > work
> > in XL...
> >
> > Any ideas?
> >
> > /Fredrik
> >
>
>|||The problem may be merged cells or show/hide regions. Excel reports with
thousands of these elements are slow to load because for each new cell they
need to check to see if it intersects with all of the other merged cells.
If you can, removing some of the show/hide elements or other obvious merged
cells and you should see a speed increase in Excel.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Fredrik" <Fredrik@.discussions.microsoft.com> wrote in message
news:3F5CB660-BFB5-4712-A30C-A0081A888A29@.microsoft.com...
> Tested 2003 but the same problem occured. I would be very happy to now
> what
> the heck is going on in Excel here...
> "Bruce L-C [MVP]" wrote:
>> At this point this is just an Excel file. It looks like Excel is not
>> handling that amount of data and that amount of groups very well. You
>> could
>> ask in Excel newsgroup if XL 2003 might work better for you.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Fredrik" <Fredrik@.discussions.microsoft.com> wrote in message
>> news:64659432-7804-4443-83D6-454F665C650A@.microsoft.com...
>> > Hi,
>> > We are using RS Sp2 andExcel XP on the clients.
>> > One report outputs 5000+ rows and are grouped like this:
>> >
>> > account group (25 groups)
>> > account (250 groups)
>> > values (4725 rows)
>> >
>> > When exported to Excel the XL-file is 11Mb+ !
>> > All groups are collapsed in XL by default, and when trying to work in
>> > the
>> > sheet XL consumes all CPU! If all groups are expanded it is possible to
>> > work
>> > with the data and there is no unusual CPU consuming.
>> > If collapsing a group again then the CPU consumtion becomes heavy
>> > again.
>> >
>> > My question, is this a limitation in XL? If it is, does this work
>> > better
>> > in
>> > XL 2003?
>> > Is there anything we can do to boost performance, as it is now we cant
>> > work
>> > in XL...
>> >
>> > Any ideas?
>> >
>> > /Fredrik
>> >
>>
Excel add-in: invisible measures
I've a cube in Analysis Services 2005 with two measuregroups. Each group contains about 4 measures. Those measures are only used for making some calculated measures. Only the calculated measures have to be visible to the user. Whenever I put the property 'visible' on false for al the normal measures in the two measuregroups, the retrieval of the measures (selecting measures in dimension-tab) in excel-add-in takes too lang (more then one minute). The retrieval of the measures works fine in other front-en tools like proclarity.
Does anyone knows about this problem and knows a solution or a workaround?
Thanks,
ADL
Try to hide the measures you dont like to see using perspectives feature of Analysis Services.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
The excel 2003 add-in for analysis services supports perspectives, but that gives no alternative:
It seems that I can't disable all measuregroups in a perspective. When you uncheck all measuregroups, the excel add-in will still show those measuregroups. The unchecking of just one measuresgroups works fine ?
By further investigation and looking at the profiler I noticed that the retrieval of de measures in Proclarity works fine, but the soapcall is somewhat different :
PROCLARITY : event subclass:MDXSCHEMA_MEASURES
<RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><CATALOG_NAME>Demo Emmaus</CATALOG_NAME><CUBE_NAME>DWH Emmaus</CUBE_NAME></RestrictionList>
<PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><Catalog>Demo Emmaus</Catalog><MdxMissingMemberMode>Error</MdxMissingMemberMode><LocaleIdentifier>2057</LocaleIdentifier><DbpropMsmdMDXCompatibility>2</DbpropMsmdMDXCompatibility></PropertyList>
EXCEL ADD-IN : event subclass:MDXSCHEMA_MEASURES
<RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><CUBE_NAME>DWH Emmaus</CUBE_NAME></RestrictionList>
<PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><Catalog>Demo Emmaus</Catalog><SafetyOptions>2</SafetyOptions><LocaleIdentifier>2057</LocaleIdentifier></PropertyList>
Is this giving anyone a clue of what can cause the long response time of retrieval of measures metadata in excel-add-in whenever the measuresvisibility is set to false?
Excel add-in: invisible measures
I've a cube in Analysis Services 2005 with two measuregroups. Each group contains about 4 measures. Those measures are only used for making some calculated measures. Only the calculated measures have to be visible to the user. Whenever I put the property 'visible' on false for al the normal measures in the two measuregroups, the retrieval of the measures (selecting measures in dimension-tab) in excel-add-in takes too lang (more then one minute). The retrieval of the measures works fine in other front-en tools like proclarity.
Does anyone knows about this problem and knows a solution or a workaround?
Thanks,
ADL
Try to hide the measures you dont like to see using perspectives feature of Analysis Services.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
The excel 2003 add-in for analysis services supports perspectives, but that gives no alternative:
It seems that I can't disable all measuregroups in a perspective. When you uncheck all measuregroups, the excel add-in will still show those measuregroups. The unchecking of just one measuresgroups works fine ?
By further investigation and looking at the profiler I noticed that the retrieval of de measures in Proclarity works fine, but the soapcall is somewhat different :
PROCLARITY : event subclass:MDXSCHEMA_MEASURES
<RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><CATALOG_NAME>Demo Emmaus</CATALOG_NAME><CUBE_NAME>DWH Emmaus</CUBE_NAME></RestrictionList>
<PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><Catalog>Demo Emmaus</Catalog><MdxMissingMemberMode>Error</MdxMissingMemberMode><LocaleIdentifier>2057</LocaleIdentifier><DbpropMsmdMDXCompatibility>2</DbpropMsmdMDXCompatibility></PropertyList>
EXCEL ADD-IN : event subclass:MDXSCHEMA_MEASURES
<RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><CUBE_NAME>DWH Emmaus</CUBE_NAME></RestrictionList>
<PropertyList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><Catalog>Demo Emmaus</Catalog><SafetyOptions>2</SafetyOptions><LocaleIdentifier>2057</LocaleIdentifier></PropertyList>
Is this giving anyone a clue of what can cause the long response time of retrieval of measures metadata in excel-add-in whenever the measuresvisibility is set to false?
Sunday, February 26, 2012
Event Viewer won't display events
I'm not sure if this is the right group. Might not at all be related to the
SQL Server instatllation, but here goes:
I've just installed SQL Server 2000 on a new Windows 2003 Server box.
After a couple of weeks I get an service failed to start error when booting
the system.
When I try to access the event viewer to examine the error, I get the
following message:
"Unable to complete the operation on 'Application'."
"The interface is unknown"
Of all the automatic services that presumably should have started, both the
WMI Service and the Task Scheduler Service has failed to start.
When trying to start the Task Sheduler I get the same error I get from the
Event Viewer.
The WMI Service just reports that a service on which it depends have failed
to start.
When accessing service properties and choosing the dependencies tab I get
the message:
"Win32: The dependency service or group failed to start"
I'm running around in the dark here as I can't access any event messages to
troubleshoot the problem.
Any input is welcome
Do or die..
Hi Jango,
Based on the problem description, it appears that this is a Windows server
related request that would be best addressed in the Windows newsgroups. For
your reference, the Windows newsgroup is located at:
microsoft.public.Windows.server.general
For assistance on this issue, please submit your request at above
newsgroups.
Thanks for your cooperation and understanding.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
SQL Server instatllation, but here goes:
I've just installed SQL Server 2000 on a new Windows 2003 Server box.
After a couple of weeks I get an service failed to start error when booting
the system.
When I try to access the event viewer to examine the error, I get the
following message:
"Unable to complete the operation on 'Application'."
"The interface is unknown"
Of all the automatic services that presumably should have started, both the
WMI Service and the Task Scheduler Service has failed to start.
When trying to start the Task Sheduler I get the same error I get from the
Event Viewer.
The WMI Service just reports that a service on which it depends have failed
to start.
When accessing service properties and choosing the dependencies tab I get
the message:
"Win32: The dependency service or group failed to start"
I'm running around in the dark here as I can't access any event messages to
troubleshoot the problem.
Any input is welcome
Do or die..
Hi Jango,
Based on the problem description, it appears that this is a Windows server
related request that would be best addressed in the Windows newsgroups. For
your reference, the Windows newsgroup is located at:
microsoft.public.Windows.server.general
For assistance on this issue, please submit your request at above
newsgroups.
Thanks for your cooperation and understanding.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
Event Viewer won't display events
I'm not sure if this is the right group. Might not at all be related to the
SQL Server instatllation, but here goes:
I've just installed SQL Server 2000 on a new Windows 2003 Server box.
After a couple of weeks I get an service failed to start error when booting
the system.
When I try to access the event viewer to examine the error, I get the
following message:
"Unable to complete the operation on 'Application'."
"The interface is unknown"
Of all the automatic services that presumably should have started, both the
WMI Service and the Task Scheduler Service has failed to start.
When trying to start the Task Sheduler I get the same error I get from the
Event Viewer.
The WMI Service just reports that a service on which it depends have failed
to start.
When accessing service properties and choosing the dependencies tab I get
the message:
"Win32: The dependency service or group failed to start"
I'm running around in the dark here as I can't access any event messages to
troubleshoot the problem.
Any input is welcome
--
Do or die..Hi Jango,
Based on the problem description, it appears that this is a Windows server
related request that would be best addressed in the Windows newsgroups. For
your reference, the Windows newsgroup is located at:
microsoft.public.Windows.server.general
For assistance on this issue, please submit your request at above
newsgroups.
Thanks for your cooperation and understanding.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
SQL Server instatllation, but here goes:
I've just installed SQL Server 2000 on a new Windows 2003 Server box.
After a couple of weeks I get an service failed to start error when booting
the system.
When I try to access the event viewer to examine the error, I get the
following message:
"Unable to complete the operation on 'Application'."
"The interface is unknown"
Of all the automatic services that presumably should have started, both the
WMI Service and the Task Scheduler Service has failed to start.
When trying to start the Task Sheduler I get the same error I get from the
Event Viewer.
The WMI Service just reports that a service on which it depends have failed
to start.
When accessing service properties and choosing the dependencies tab I get
the message:
"Win32: The dependency service or group failed to start"
I'm running around in the dark here as I can't access any event messages to
troubleshoot the problem.
Any input is welcome
--
Do or die..Hi Jango,
Based on the problem description, it appears that this is a Windows server
related request that would be best addressed in the Windows newsgroups. For
your reference, the Windows newsgroup is located at:
microsoft.public.Windows.server.general
For assistance on this issue, please submit your request at above
newsgroups.
Thanks for your cooperation and understanding.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
Event Viewer won't display events
I'm not sure if this is the right group. Might not at all be related to the
SQL Server instatllation, but here goes:
I've just installed SQL Server 2000 on a new Windows 2003 Server box.
After a couple of weeks I get an service failed to start error when booting
the system.
When I try to access the event viewer to examine the error, I get the
following message:
"Unable to complete the operation on 'Application'."
"The interface is unknown"
Of all the automatic services that presumably should have started, both the
WMI Service and the Task Scheduler Service has failed to start.
When trying to start the Task Sheduler I get the same error I get from the
Event Viewer.
The WMI Service just reports that a service on which it depends have failed
to start.
When accessing service properties and choosing the dependencies tab I get
the message:
"Win32: The dependency service or group failed to start"
I'm running around in the dark here as I can't access any event messages to
troubleshoot the problem.
Any input is welcome
--
Do or die..Hi Jango,
Based on the problem description, it appears that this is a Windows server
related request that would be best addressed in the Windows newsgroups. For
your reference, the Windows newsgroup is located at:
microsoft.public.Windows.server.general
For assistance on this issue, please submit your request at above
newsgroups.
Thanks for your cooperation and understanding.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
SQL Server instatllation, but here goes:
I've just installed SQL Server 2000 on a new Windows 2003 Server box.
After a couple of weeks I get an service failed to start error when booting
the system.
When I try to access the event viewer to examine the error, I get the
following message:
"Unable to complete the operation on 'Application'."
"The interface is unknown"
Of all the automatic services that presumably should have started, both the
WMI Service and the Task Scheduler Service has failed to start.
When trying to start the Task Sheduler I get the same error I get from the
Event Viewer.
The WMI Service just reports that a service on which it depends have failed
to start.
When accessing service properties and choosing the dependencies tab I get
the message:
"Win32: The dependency service or group failed to start"
I'm running around in the dark here as I can't access any event messages to
troubleshoot the problem.
Any input is welcome
--
Do or die..Hi Jango,
Based on the problem description, it appears that this is a Windows server
related request that would be best addressed in the Windows newsgroups. For
your reference, the Windows newsgroup is located at:
microsoft.public.Windows.server.general
For assistance on this issue, please submit your request at above
newsgroups.
Thanks for your cooperation and understanding.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
Sunday, February 19, 2012
Event ID 17055
I posted this over in the sbs2k with no answers I hope someone here can shed
some light on this. Sorry if this is not the right group.
We have a sbs2k doing a nightly full backup using Veritas BE 9.1 the backup
completes successfully with no errors but in the event log I find these
event errors that have been log during the backup. Is there anything I can
do to solve this? There will be 8 of these in the log.
Thanks
Tim
Event Type: Error
Event Source: MSSQL$BKUPEXEC
Event Category: (2)
Event ID: 17055
Date: 3/15/2004
Time: 10:52:29 PM
User: administrator
Computer: SBS001
Description:
18272 :
I/O error on backup or restore restart-checkpoint file 'C:\Program
Files\Microsoft SQL Server\MSSQL$BKUPEXEC\backup\master4IDR.ckp'. Operating
system error 3(The system cannot find the path specified.). The statement is
proceeding but is non-restartable.
Data:
0000: 60 47 00 00 10 00 00 00 `G.....
0008: 10 00 00 00 53 00 42 00 ...S.B.
0010: 53 00 30 00 30 00 31 00 S.0.0.1.
0018: 5c 00 42 00 4b 00 55 00 \.B.K.U.
0020: 50 00 45 00 58 00 45 00 P.E.X.E.
0028: 43 00 00 00 07 00 00 00 C......
0030: 6d 00 61 00 73 00 74 00 m.a.s.t.
0038: 65 00 72 00 00 00 e.r...
To resolve this, create a directory named backup under C:\Program
Files\Microsoft SQL Server\MSSQL$BKUPEXEC\.
some light on this. Sorry if this is not the right group.
We have a sbs2k doing a nightly full backup using Veritas BE 9.1 the backup
completes successfully with no errors but in the event log I find these
event errors that have been log during the backup. Is there anything I can
do to solve this? There will be 8 of these in the log.
Thanks
Tim
Event Type: Error
Event Source: MSSQL$BKUPEXEC
Event Category: (2)
Event ID: 17055
Date: 3/15/2004
Time: 10:52:29 PM
User: administrator
Computer: SBS001
Description:
18272 :
I/O error on backup or restore restart-checkpoint file 'C:\Program
Files\Microsoft SQL Server\MSSQL$BKUPEXEC\backup\master4IDR.ckp'. Operating
system error 3(The system cannot find the path specified.). The statement is
proceeding but is non-restartable.
Data:
0000: 60 47 00 00 10 00 00 00 `G.....
0008: 10 00 00 00 53 00 42 00 ...S.B.
0010: 53 00 30 00 30 00 31 00 S.0.0.1.
0018: 5c 00 42 00 4b 00 55 00 \.B.K.U.
0020: 50 00 45 00 58 00 45 00 P.E.X.E.
0028: 43 00 00 00 07 00 00 00 C......
0030: 6d 00 61 00 73 00 74 00 m.a.s.t.
0038: 65 00 72 00 00 00 e.r...
To resolve this, create a directory named backup under C:\Program
Files\Microsoft SQL Server\MSSQL$BKUPEXEC\.
Event ID 17055
I posted this over in the sbs2k with no answers I hope someone here can shed
some light on this. Sorry if this is not the right group.
We have a sbs2k doing a nightly full backup using Veritas BE 9.1 the backup
completes successfully with no errors but in the event log I find these
event errors that have been log during the backup. Is there anything I can
do to solve this? There will be 8 of these in the log.
Thanks
Tim
Event Type: Error
Event Source: MSSQL$BKUPEXEC
Event Category: (2)
Event ID: 17055
Date: 3/15/2004
Time: 10:52:29 PM
User: administrator
Computer: SBS001
Description:
18272 :
I/O error on backup or restore restart-checkpoint file 'C:\Program
Files\Microsoft SQL Server\MSSQL$BKUPEXEC\backup\master4IDR.ckp'. Operating
system error 3(The system cannot find the path specified.). The statement is
proceeding but is non-restartable.
Data:
0000: 60 47 00 00 10 00 00 00 `G.....
0008: 10 00 00 00 53 00 42 00 ...S.B.
0010: 53 00 30 00 30 00 31 00 S.0.0.1.
0018: 5c 00 42 00 4b 00 55 00 \.B.K.U.
0020: 50 00 45 00 58 00 45 00 P.E.X.E.
0028: 43 00 00 00 07 00 00 00 C......
0030: 6d 00 61 00 73 00 74 00 m.a.s.t.
0038: 65 00 72 00 00 00 e.r...To resolve this, create a directory named backup under C:\Program
Files\Microsoft SQL Server\MSSQL$BKUPEXEC\.
some light on this. Sorry if this is not the right group.
We have a sbs2k doing a nightly full backup using Veritas BE 9.1 the backup
completes successfully with no errors but in the event log I find these
event errors that have been log during the backup. Is there anything I can
do to solve this? There will be 8 of these in the log.
Thanks
Tim
Event Type: Error
Event Source: MSSQL$BKUPEXEC
Event Category: (2)
Event ID: 17055
Date: 3/15/2004
Time: 10:52:29 PM
User: administrator
Computer: SBS001
Description:
18272 :
I/O error on backup or restore restart-checkpoint file 'C:\Program
Files\Microsoft SQL Server\MSSQL$BKUPEXEC\backup\master4IDR.ckp'. Operating
system error 3(The system cannot find the path specified.). The statement is
proceeding but is non-restartable.
Data:
0000: 60 47 00 00 10 00 00 00 `G.....
0008: 10 00 00 00 53 00 42 00 ...S.B.
0010: 53 00 30 00 30 00 31 00 S.0.0.1.
0018: 5c 00 42 00 4b 00 55 00 \.B.K.U.
0020: 50 00 45 00 58 00 45 00 P.E.X.E.
0028: 43 00 00 00 07 00 00 00 C......
0030: 6d 00 61 00 73 00 74 00 m.a.s.t.
0038: 65 00 72 00 00 00 e.r...To resolve this, create a directory named backup under C:\Program
Files\Microsoft SQL Server\MSSQL$BKUPEXEC\.
Friday, February 17, 2012
Event ID 11 SQL 2000
Hi All,
Sorry to cross-post, but after looking through the
subjects, I thought my question belonged more in this
group.
My SQL server keeps logging this error;
Event ID 11 Source KDC: There are multiple accounts with
name MSSQLSvc/servername.domain.com:1433 of type 10
After following the instructions in the following article,
I found the 2 accounts that were suing the same SPN: they
were the "sa" account and the "administrator" account. I
don't think either of these should be deleted so how do
you fix this problem? What harm is caused by letting it go
on?
Thanks.
http://support.microsoft.com/default.aspx?scid=kb;EN-
US;305971Hi joh,
Try to reassign SPN with SETSPN.EXE utility which is available for download
with win2000 resource kit
Regards,
Daniel
"joh" <anonymous@.discussions.microsoft.com> wrote in message
news:14fa01c4e788$ab140140$a301280a@.phx.gbl...
> Hi All,
> Sorry to cross-post, but after looking through the
> subjects, I thought my question belonged more in this
> group.
> My SQL server keeps logging this error;
> Event ID 11 Source KDC: There are multiple accounts with
> name MSSQLSvc/servername.domain.com:1433 of type 10
> After following the instructions in the following article,
> I found the 2 accounts that were suing the same SPN: they
> were the "sa" account and the "administrator" account. I
> don't think either of these should be deleted so how do
> you fix this problem? What harm is caused by letting it go
> on?
> Thanks.
> http://support.microsoft.com/default.aspx?scid=kb;EN-
> US;305971
>|||Thanks Daniel, I will give it a try.
joh
>--Original Message--
>Hi joh,
>Try to reassign SPN with SETSPN.EXE utility which is
available for download
>with win2000 resource kit
>Regards,
>Daniel
>"joh" <anonymous@.discussions.microsoft.com> wrote in
message
>news:14fa01c4e788$ab140140$a301280a@.phx.gbl...
>> Hi All,
>> Sorry to cross-post, but after looking through the
>> subjects, I thought my question belonged more in this
>> group.
>> My SQL server keeps logging this error;
>> Event ID 11 Source KDC: There are multiple accounts with
>> name MSSQLSvc/servername.domain.com:1433 of type 10
>> After following the instructions in the following
article,
>> I found the 2 accounts that were suing the same SPN:
they
>> were the "sa" account and the "administrator" account. I
>> don't think either of these should be deleted so how do
>> you fix this problem? What harm is caused by letting it
go
>> on?
>> Thanks.
>> http://support.microsoft.com/default.aspx?scid=kb;EN-
>> US;305971
>
>.
>
Sorry to cross-post, but after looking through the
subjects, I thought my question belonged more in this
group.
My SQL server keeps logging this error;
Event ID 11 Source KDC: There are multiple accounts with
name MSSQLSvc/servername.domain.com:1433 of type 10
After following the instructions in the following article,
I found the 2 accounts that were suing the same SPN: they
were the "sa" account and the "administrator" account. I
don't think either of these should be deleted so how do
you fix this problem? What harm is caused by letting it go
on?
Thanks.
http://support.microsoft.com/default.aspx?scid=kb;EN-
US;305971Hi joh,
Try to reassign SPN with SETSPN.EXE utility which is available for download
with win2000 resource kit
Regards,
Daniel
"joh" <anonymous@.discussions.microsoft.com> wrote in message
news:14fa01c4e788$ab140140$a301280a@.phx.gbl...
> Hi All,
> Sorry to cross-post, but after looking through the
> subjects, I thought my question belonged more in this
> group.
> My SQL server keeps logging this error;
> Event ID 11 Source KDC: There are multiple accounts with
> name MSSQLSvc/servername.domain.com:1433 of type 10
> After following the instructions in the following article,
> I found the 2 accounts that were suing the same SPN: they
> were the "sa" account and the "administrator" account. I
> don't think either of these should be deleted so how do
> you fix this problem? What harm is caused by letting it go
> on?
> Thanks.
> http://support.microsoft.com/default.aspx?scid=kb;EN-
> US;305971
>|||Thanks Daniel, I will give it a try.
joh
>--Original Message--
>Hi joh,
>Try to reassign SPN with SETSPN.EXE utility which is
available for download
>with win2000 resource kit
>Regards,
>Daniel
>"joh" <anonymous@.discussions.microsoft.com> wrote in
message
>news:14fa01c4e788$ab140140$a301280a@.phx.gbl...
>> Hi All,
>> Sorry to cross-post, but after looking through the
>> subjects, I thought my question belonged more in this
>> group.
>> My SQL server keeps logging this error;
>> Event ID 11 Source KDC: There are multiple accounts with
>> name MSSQLSvc/servername.domain.com:1433 of type 10
>> After following the instructions in the following
article,
>> I found the 2 accounts that were suing the same SPN:
they
>> were the "sa" account and the "administrator" account. I
>> don't think either of these should be deleted so how do
>> you fix this problem? What harm is caused by letting it
go
>> on?
>> Thanks.
>> http://support.microsoft.com/default.aspx?scid=kb;EN-
>> US;305971
>
>.
>
Subscribe to:
Posts (Atom)