Export CSV headings incorrect

Using SQL 2000, reporting services w/sp2.
When any of our reports are exported in CSV, the first row contains the
headers. The problem is two-fold. First any hidden columns, while not being
in the data portion of the export, are included in the headers. Second, the
headers are the design time header names (e.g Text4) rather than the printed
headers (e.g. "Student ID").
Does anyone know if this is a known bug? If so, dcan you supply any links to
description/MS listing of it. If not, is there a setting to print the correct
headers?
Thanks
--
KenI haven't done this for awhile but I don't think they are the name of the
header textbox but the name of the field textbox. Change the name of the
field textbox to the name you want it exported as.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ken" <Ken@.discussions.microsoft.com> wrote in message
news:55E41B73-D1DA-4E34-A6A3-B35D87566F3E@.microsoft.com...
> Using SQL 2000, reporting services w/sp2.
> When any of our reports are exported in CSV, the first row contains the
> headers. The problem is two-fold. First any hidden columns, while not
> being
> in the data portion of the export, are included in the headers. Second,
> the
> headers are the design time header names (e.g Text4) rather than the
> printed
> headers (e.g. "Student ID").
> Does anyone know if this is a known bug? If so, dcan you supply any links
> to
> description/MS listing of it. If not, is there a setting to print the
> correct
> headers?
> Thanks
> --
> Ken|||I appreciate you answering, but 2 things. One, I already thought of that
work-around. It won't work in my situation, and I'm not asking for a
work-around. I am trying to find out if this is a known bug and/or is there a
setting (besides NOHEADER) which controls what get output, when the headers
are being output in CSV. If there is no work-around I wnat to be able to tell
my clients it is a known MS bug, and I will write a CSV export to take care
of the problem.
Thanks
--
Ken
"Bruce L-C [MVP]" wrote:
> I haven't done this for awhile but I don't think they are the name of the
> header textbox but the name of the field textbox. Change the name of the
> field textbox to the name you want it exported as.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Ken" <Ken@.discussions.microsoft.com> wrote in message
> news:55E41B73-D1DA-4E34-A6A3-B35D87566F3E@.microsoft.com...
> > Using SQL 2000, reporting services w/sp2.
> >
> > When any of our reports are exported in CSV, the first row contains the
> > headers. The problem is two-fold. First any hidden columns, while not
> > being
> > in the data portion of the export, are included in the headers. Second,
> > the
> > headers are the design time header names (e.g Text4) rather than the
> > printed
> > headers (e.g. "Student ID").
> >
> > Does anyone know if this is a known bug? If so, dcan you supply any links
> > to
> > description/MS listing of it. If not, is there a setting to print the
> > correct
> > headers?
> >
> > Thanks
> > --
> > Ken
>
>|||You asked two questions. I had an answer for one of them (being incorrectly
labeled) but not the other (preventing output).
As far as preventing a column from being output I don't have an answer for
you.
Preventing a column from outputting is not something I would consider a bug,
more of a feature you would like that isn't there (assuming it isn't there,
I might just not know an answer).
So, I might be wrong but from my perspective I thought I told you how to
have the csv be correctly labeled (i.e. not showing textbox1 etc).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ken" <Ken@.discussions.microsoft.com> wrote in message
news:852387C9-6C14-455E-BFB8-42E301E3A67A@.microsoft.com...
>I appreciate you answering, but 2 things. One, I already thought of that
> work-around. It won't work in my situation, and I'm not asking for a
> work-around. I am trying to find out if this is a known bug and/or is
> there a
> setting (besides NOHEADER) which controls what get output, when the
> headers
> are being output in CSV. If there is no work-around I wnat to be able to
> tell
> my clients it is a known MS bug, and I will write a CSV export to take
> care
> of the problem.
> Thanks
> --
> Ken
>
> "Bruce L-C [MVP]" wrote:
>> I haven't done this for awhile but I don't think they are the name of the
>> header textbox but the name of the field textbox. Change the name of the
>> field textbox to the name you want it exported as.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Ken" <Ken@.discussions.microsoft.com> wrote in message
>> news:55E41B73-D1DA-4E34-A6A3-B35D87566F3E@.microsoft.com...
>> > Using SQL 2000, reporting services w/sp2.
>> >
>> > When any of our reports are exported in CSV, the first row contains the
>> > headers. The problem is two-fold. First any hidden columns, while not
>> > being
>> > in the data portion of the export, are included in the headers. Second,
>> > the
>> > headers are the design time header names (e.g Text4) rather than the
>> > printed
>> > headers (e.g. "Student ID").
>> >
>> > Does anyone know if this is a known bug? If so, dcan you supply any
>> > links
>> > to
>> > description/MS listing of it. If not, is there a setting to print the
>> > correct
>> > headers?
>> >
>> > Thanks
>> > --
>> > Ken
>>