Hidding rows disappearing in Excel export

I have a report that looks fine in Report Server, but when I export to
Excel, I lose data.
I have a group that I am repeating the group footer 3 times. The
original footer is the toggle. when I hit the + in Rep Services, it
expands with no problem, showing all of my hidden rows.
when I export it to excel and hit the toggle, it only shows the first
hidden row and loses the other two.
Any ideas?What version of Report Server and Office do you have?
daw
"M@." wrote:
> I have a report that looks fine in Report Server, but when I export to
> Excel, I lose data.
> I have a group that I am repeating the group footer 3 times. The
> original footer is the toggle. when I hit the + in Rep Services, it
> expands with no problem, showing all of my hidden rows.
> when I export it to excel and hit the toggle, it only shows the first
> hidden row and loses the other two.
> Any ideas?
>|||Microsoft SQL Server Reporting Services Version 8.00.1038.00
Excel 2003
thx,
M@.
On Mar 21, 3:52 pm, daw <d...@.discussions.microsoft.com> wrote:
> What version of Report Server and Office do you have?
> daw
> "M@." wrote:
> > I have a report that looks fine in Report Server, but when I export to
> > Excel, I lose data.
> > I have a group that I am repeating the group footer 3 times. The
> > original footer is the toggle. when I hit the + in Rep Services, it
> > expands with no problem, showing all of my hidden rows.
> > when I export it to excel and hit the toggle, it only shows the first
> > hidden row and loses the other two.
> > Any ideas?|||Are you sure that the rows are not just hidden rows in Excel? Are the row
numbers consecutive?
"M@." wrote:
> Microsoft SQL Server Reporting Services Version 8.00.1038.00
> Excel 2003
> thx,
> M@.
> On Mar 21, 3:52 pm, daw <d...@.discussions.microsoft.com> wrote:
> > What version of Report Server and Office do you have?
> >
> > daw
> >
> > "M@." wrote:
> > > I have a report that looks fine in Report Server, but when I export to
> > > Excel, I lose data.
> >
> > > I have a group that I am repeating the group footer 3 times. The
> > > original footer is the toggle. when I hit the + in Rep Services, it
> > > expands with no problem, showing all of my hidden rows.
> >
> > > when I export it to excel and hit the toggle, it only shows the first
> > > hidden row and loses the other two.
> >
> > > Any ideas?
>
>|||I have a group footer (group1) that I repeat. The first line is the
toggle, lines 2-5 are details. I'm using running values. Row 1 is
the sum. Row2 is a sum when a field = PRV, Row3 is a sum when a field
= MCD and so on.
It looks fine in Reporting Services, but if I export it to excel and
hit the toggle, only the first hidden row pops in.
Yeah, the row numbers are consecutive.
On Mar 21, 4:32 pm, daw <d...@.discussions.microsoft.com> wrote:
> Are you sure that the rows are not just hidden rows in Excel? Are the row
> numbers consecutive?
>
> "M@." wrote:
> > Microsoft SQL Server Reporting Services Version 8.00.1038.00
> > Excel 2003
> > thx,
> > M@.
> > On Mar 21, 3:52 pm, daw <d...@.discussions.microsoft.com> wrote:
> > > What version of Report Server and Office do you have?
> > > daw
> > > "M@." wrote:
> > > > I have a report that looks fine in Report Server, but when I export to
> > > > Excel, I lose data.
> > > > I have a group that I am repeating the group footer 3 times. The
> > > > original footer is the toggle. when I hit the + in Rep Services, it
> > > > expands with no problem, showing all of my hidden rows.
> > > > when I export it to excel and hit the toggle, it only shows the first
> > > > hidden row and loses the other two.
> > > > Any ideas... Hide quoted text -
> - Show quoted text -