I posted this message last week, but I've been out of town for a few days
and can not find any responses.
I have a report that has a single table with a 2 row header, a single row
detail and a single row footer. The report works fine and exports to Excel
fine. However, when I try to export to CSV I am seeing some strange
results. My 2nd row header (which includes only an expression calculating
report date range), and my report footer (which is includes summations of
the detail rows) are included in EVERY row of my exported CSV file.
This may help:
report format:
header1
header2
header3
dataa datab datac
footer1a footer1b footer1c
results in:
header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
Any ideas as to why this is happening? Has anyone else experienced the same
issue?
Thanks
TerrellYou're looking for the DataElementOutput property.
--
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"troark" <t.roark.n0spam@.excite.com> wrote in message
news:uK9f5xOaEHA.3704@.TK2MSFTNGP09.phx.gbl...
> I posted this message last week, but I've been out of town for a few days
> and can not find any responses.
> I have a report that has a single table with a 2 row header, a single row
> detail and a single row footer. The report works fine and exports to
Excel
> fine. However, when I try to export to CSV I am seeing some strange
> results. My 2nd row header (which includes only an expression calculating
> report date range), and my report footer (which is includes summations of
> the detail rows) are included in EVERY row of my exported CSV file.
> This may help:
> report format:
> header1
> header2
> header3
> dataa datab datac
> footer1a footer1b footer1c
> results in:
> header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
> header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
> header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
> header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
> header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
> header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
>
> Any ideas as to why this is happening? Has anyone else experienced the
same
> issue?
> Thanks
> Terrell
>
>|||Thanks Chris! That was it.
"Chris Hays [MSFT]" <chays@.online.microsoft.com> wrote in message
news:ePjDoITaEHA.4068@.TK2MSFTNGP10.phx.gbl...
> You're looking for the DataElementOutput property.
> --
> My employer's lawyers require me to say:
> "This posting is provided 'AS IS' with no warranties, and confers no
> rights."
> "troark" <t.roark.n0spam@.excite.com> wrote in message
> news:uK9f5xOaEHA.3704@.TK2MSFTNGP09.phx.gbl...
> > I posted this message last week, but I've been out of town for a few
days
> > and can not find any responses.
> >
> > I have a report that has a single table with a 2 row header, a single
row
> > detail and a single row footer. The report works fine and exports to
> Excel
> > fine. However, when I try to export to CSV I am seeing some strange
> > results. My 2nd row header (which includes only an expression
calculating
> > report date range), and my report footer (which is includes summations
of
> > the detail rows) are included in EVERY row of my exported CSV file.
> >
> > This may help:
> >
> > report format:
> > header1
> > header2
> > header3
> > dataa datab datac
> > footer1a footer1b footer1c
> >
> > results in:
> > header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
> > header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
> > header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
> > header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
> > header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
> > header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
> >
> >
> > Any ideas as to why this is happening? Has anyone else experienced the
> same
> > issue?
> >
> > Thanks
> > Terrell
> >
> >
> >
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment