Export to CSV without header line

Hi,
Is it possible to export to CSV without header line?
I create report for my user where they can retrieve data in csv(txt) file
for their further use.
I would like to skip generation of header line in CVS rendering if it is
possible.
Thanks
DonThanks for the tip.
But where do you set the device info?
Sissel
"Gastón Pírez" wrote:
> You can do this setting a parameter in the device info
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_soapapi_dev_34fa.asp
> Gaston.-
> "Don" <Don@.discussions.microsoft.com> wrote in message
> news:ECC0D669-97A0-49D4-9914-50ABCD4C3223@.microsoft.com...
> > Hi,
> >
> > Is it possible to export to CSV without header line?
> >
> > I create report for my user where they can retrieve data in csv(txt) file
> > for their further use.
> > I would like to skip generation of header line in CVS rendering if it is
> > possible.
> >
> > Thanks
> > Don
> >
>
>|||Try www.sqlscripter.com to export data to text/csv.
It's free.
"Don" wrote:
> Hi,
> Is it possible to export to CSV without header line?
> I create report for my user where they can retrieve data in csv(txt) file
> for their further use.
> I would like to skip generation of header line in CVS rendering if it is
> possible.
> Thanks
> Don
>|||in sql server 2000 reporting services, can i export csv without header line?
"Thomas" <Thomas@.discussions.microsoft.com> wrote in message
news:CCE0FED9-1AA5-4C0A-8041-A5DE99D66C42@.microsoft.com...
> Try www.sqlscripter.com to export data to text/csv.
> It's free.
>
> "Don" wrote:
>> Hi,
>> Is it possible to export to CSV without header line?
>> I create report for my user where they can retrieve data in csv(txt) file
>> for their further use.
>> I would like to skip generation of header line in CVS rendering if it is
>> possible.
>> Thanks
>> Don|||Good question. I'd like to know how to export csv without header lines in
RS2005. AND can someone tell me how to customer csv render in a data-drive
subscription? Can we do that automatically so that users who retrieve the
report from a designed folder will be able to open the csv file automatically
w/o headers? thanks
"Peter Fuller" wrote:
> in sql server 2000 reporting services, can i export csv without header line?
> "Thomas" <Thomas@.discussions.microsoft.com> wrote in message
> news:CCE0FED9-1AA5-4C0A-8041-A5DE99D66C42@.microsoft.com...
> > Try www.sqlscripter.com to export data to text/csv.
> > It's free.
> >
> >
> > "Don" wrote:
> >
> >> Hi,
> >>
> >> Is it possible to export to CSV without header line?
> >>
> >> I create report for my user where they can retrieve data in csv(txt) file
> >> for their further use.
> >> I would like to skip generation of header line in CVS rendering if it is
> >> possible.
> >>
> >> Thanks
> >> Don
> >>
>
>

Export to Acrobat

We have a sub report in the main report and when the sub report does not retrieve any data and the report is exported to any format it is throwing the Reporting services error and when there is data in the sub report the report is properly appearing.

This is happening only in 'no data' scenarios.

Can any one please tell me why this is happening and some solution for this issue?

This font is really hard to read, so please choose a different one next time ;)

Maybe you set the no-rows property of the subreport to something that throws the error..
Have you looked at the log files?
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles
|||

Thanks for replying...

But can you please tell me where do we find the no rows property for the sub report?

|||

Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 6. is the message displayed in the log

now how do i check the position 6?

Export result to the Excel

Hi,

I am a new in SQL Server.
I have a question.

I create the table called "tbl1"
I create a query called "qry1", this query retrieve the data from the "tbl1".

after running the query, and then convert the result to the Excel.

How can I do that?
Please let me know, thanks a lot. Thanks.Other than copy/paste?

Well, you can use DTS (Data Transformatin Services) to export data. Is this a one-time export, or does it need to be part of a scheduled process?|||or save the column delimited results as a text file and import to excel as fixed width text file|||Is this from withing Access?