Wednesday, March 21, 2012

error when exporting to excel

Hi,
When I export my resport to excel in reprot manager.
It always results in an error: index is out of bounds.
How can I do that?A few questions:
Are you using SQL Server 2000 Reporting Services 2000 SP1?
What is the exact error you are receiving?
Are you using an image in a page header?
Can you reproduce the problem using a sample database? If so could you post
an RDL the demonstrates the problem?
If you cannot not reproduce the problem with sample data is it possible for
you to send, directly to me, your RDL and RDL.Data file? RDL.Data are part
of SP1
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:usFscHKlEHA.324@.TK2MSFTNGP11.phx.gbl...
> Hi,
> When I export my resport to excel in reprot manager.
> It always results in an error: index is out of bounds.
> How can I do that?
>|||Thank Sir,
1. Yes, I have upgrade to SP1.
2. I am using Trandition Chinese version. The error is about index out of
bound or below zero.
3. Yes, I have two images in the page header.
4. I use Office xp. Is the problem is related to the version of Excel?
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
:OaAljVTlEHA.324@.TK2MSFTNGP11.phx.gbl...
> A few questions:
> Are you using SQL Server 2000 Reporting Services 2000 SP1?
> What is the exact error you are receiving?
> Are you using an image in a page header?
> Can you reproduce the problem using a sample database? If so could you
post
> an RDL the demonstrates the problem?
> If you cannot not reproduce the problem with sample data is it possible
for
> you to send, directly to me, your RDL and RDL.Data file? RDL.Data are part
> of SP1
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> news:usFscHKlEHA.324@.TK2MSFTNGP11.phx.gbl...
> > Hi,
> > When I export my resport to excel in reprot manager.
> > It always results in an error: index is out of bounds.
> > How can I do that?
> >
> >
>|||An "index was out of range" error will occur under the following conditions:
* SP1 is being used
* A page header contains an image
* The report is exported to excel.
The full error is "Index was out of range. Must be non-negative and less
than the size of the collection. Parameter name: index".
There are two workarounds for this issue:
* Increase the size of the page header so it is greater than the image
height.
* Set the image sizing property to "Fit"
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:%23hThRKWlEHA.1936@.TK2MSFTNGP12.phx.gbl...
> Thank Sir,
> 1. Yes, I have upgrade to SP1.
> 2. I am using Trandition Chinese version. The error is about index out of
> bound or below zero.
> 3. Yes, I have two images in the page header.
> 4. I use Office xp. Is the problem is related to the version of Excel?
>
>
> "Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
> :OaAljVTlEHA.324@.TK2MSFTNGP11.phx.gbl...
> > A few questions:
> >
> > Are you using SQL Server 2000 Reporting Services 2000 SP1?
> > What is the exact error you are receiving?
> > Are you using an image in a page header?
> > Can you reproduce the problem using a sample database? If so could you
> post
> > an RDL the demonstrates the problem?
> > If you cannot not reproduce the problem with sample data is it possible
> for
> > you to send, directly to me, your RDL and RDL.Data file? RDL.Data are
part
> > of SP1
> >
> > --
> > Bruce Johnson [MSFT]
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> > news:usFscHKlEHA.324@.TK2MSFTNGP11.phx.gbl...
> > > Hi,
> > > When I export my resport to excel in reprot manager.
> > > It always results in an error: index is out of bounds.
> > > How can I do that?
> > >
> > >
> >
> >
>|||Thank's Sir
Your answer is excellent!
After I increased the size of the page header, it's OK
Thank a lot
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
:e8oJ3PclEHA.3988@.tk2msftngp13.phx.gbl...
> An "index was out of range" error will occur under the following
conditions:
> * SP1 is being used
> * A page header contains an image
> * The report is exported to excel.
> The full error is "Index was out of range. Must be non-negative and less
> than the size of the collection. Parameter name: index".
> There are two workarounds for this issue:
> * Increase the size of the page header so it is greater than the image
> height.
> * Set the image sizing property to "Fit"
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> news:%23hThRKWlEHA.1936@.TK2MSFTNGP12.phx.gbl...
> > Thank Sir,
> > 1. Yes, I have upgrade to SP1.
> > 2. I am using Trandition Chinese version. The error is about index out
of
> > bound or below zero.
> > 3. Yes, I have two images in the page header.
> > 4. I use Office xp. Is the problem is related to the version of Excel?
> >
> >
> >
> >
> >
> > "Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
> > :OaAljVTlEHA.324@.TK2MSFTNGP11.phx.gbl...
> > > A few questions:
> > >
> > > Are you using SQL Server 2000 Reporting Services 2000 SP1?
> > > What is the exact error you are receiving?
> > > Are you using an image in a page header?
> > > Can you reproduce the problem using a sample database? If so could you
> > post
> > > an RDL the demonstrates the problem?
> > > If you cannot not reproduce the problem with sample data is it
possible
> > for
> > > you to send, directly to me, your RDL and RDL.Data file? RDL.Data are
> part
> > > of SP1
> > >
> > > --
> > > Bruce Johnson [MSFT]
> > > Microsoft SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > >
> > > "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> > > news:usFscHKlEHA.324@.TK2MSFTNGP11.phx.gbl...
> > > > Hi,
> > > > When I export my resport to excel in reprot manager.
> > > > It always results in an error: index is out of bounds.
> > > > How can I do that?
> > > >
> > > >
> > >
> > >
> >
> >
>sql

No comments:

Post a Comment