Exporting Role Permissions

I need to export the role permissions in a user friendly format for the
auditors and was wondering if there is a way to do this that would
mimic the layout you see within the database role permissions tab in
enterprise manager. Thanks for taking pity on a newbie.
Check books online and look up sp_helprotect.
You could list permissions using something like:
EXEC sp_helprotect NULL, 'YourRole'
-Sue
On 25 Sep 2006 07:29:37 -0700, "skinnker"
<skinnke@.manulife.com> wrote:

>I need to export the role permissions in a user friendly format for the
>auditors and was wondering if there is a way to do this that would
>mimic the layout you see within the database role permissions tab in
>enterprise manager. Thanks for taking pity on a newbie.
sql

Exporting Role Permissions

I need to export the role permissions in a user friendly format for the
auditors and was wondering if there is a way to do this that would
mimic the layout you see within the database role permissions tab in
enterprise manager. Thanks for taking pity on a newbie.Check books online and look up sp_helprotect.
You could list permissions using something like:
EXEC sp_helprotect NULL, 'YourRole'
-Sue
On 25 Sep 2006 07:29:37 -0700, "skinnker"
<skinnke@.manulife.com> wrote:
>I need to export the role permissions in a user friendly format for the
>auditors and was wondering if there is a way to do this that would
>mimic the layout you see within the database role permissions tab in
>enterprise manager. Thanks for taking pity on a newbie.

Exporting Role Permissions

I need to export the role permissions in a user friendly format for the
auditors and was wondering if there is a way to do this that would
mimic the layout you see within the database role permissions tab in
enterprise manager. Thanks for taking pity on a newbie.Check books online and look up sp_helprotect.
You could list permissions using something like:
EXEC sp_helprotect NULL, 'YourRole'
-Sue
On 25 Sep 2006 07:29:37 -0700, "skinnker"
<skinnke@.manulife.com> wrote:

>I need to export the role permissions in a user friendly format for the
>auditors and was wondering if there is a way to do this that would
>mimic the layout you see within the database role permissions tab in
>enterprise manager. Thanks for taking pity on a newbie.

Exporting PDF Problems

i ve used SOAP API in my web application and thus generated the report in
html giving user an opton to export the report to excel or PDF when user
exports the report to excel it works perfectly but when it is exported to PDF
as usual open/save dialogue box appear what so ever is the response acrobate
reader loads but instead of opening the exported report it gives an error
which stats that
file is corrupt cant b corrected and thus cant b open
can anyone tell whats the problem in all that case
i use reponse.addheader and response.write methods to enable user to export
to pdf kindly help it outMuhammad Hammad wrote:
> i ve used SOAP API in my web application and thus generated the
Which PDF-Reader do you use?
You need Adobe-Reader >= Version 6.0!
best regards
Frank
--
www.xax.de|||well frank i m already using acrobate reader 6.0 professional
"Frank Matthiesen" wrote:
> Muhammad Hammad wrote:
> > i ve used SOAP API in my web application and thus generated the
> Which PDF-Reader do you use?
> You need Adobe-Reader >= Version 6.0!
> best regards
> Frank
> --
> www.xax.de
>
>
>|||Going to version 7 is free, and seems to be worth it. Also, do you have
RS SP1 installed? It has some rendering fixes.|||well i m installed with RS sp 1. as far as acrobate reader 7 is concerned i
ll chceck that out and let it b known
"Parker" wrote:
> Going to version 7 is free, and seems to be worth it. Also, do you have
> RS SP1 installed? It has some rendering fixes.
>

exporting from SQL to an Outlook group or Dist List?

I need to export a list of name and email address fields from a SQL
table, in some format so that a user can take the file I generate and
Import it into Outlook and it will keep all the names together in a
Group or Distribution List rather than dumping them into the user's
main address book. Any ideas?

Francesco"Francesco" <francesco@.neurodesign.com> wrote in message
news:8b6199d0.0307310928.73359d1e@.posting.google.c om...
> I need to export a list of name and email address fields from a SQL
> table, in some format so that a user can take the file I generate and
> Import it into Outlook and it will keep all the names together in a
> Group or Distribution List rather than dumping them into the user's
> main address book. Any ideas?
> Francesco

Assuming you have SQL2000, you can use BCP or DTS to create a CSV file, or a
file in some other delimited format. As to how you import that into Outlook,
you will get a better response posting in an Outlook newsgroup - there are
several microsoft.public.outlook.* groups.

Simon

Exporting data with dynamic fields

Hi,

I have one Query Builder application where user creates queries and generates output with required fields.Then user can export the same to excel (Using farPointSpread properties)
But if no. of records goes beyond 10K it goes too slow or even user machine hangs up. I want to give proper export facility. Can it be given using DTS?

I tried DTS (.vbs) file. but for random field selection it did not work.DTS package asks for new Transactions to be built for every change in Source table structure. It first creates the table in the destination databse and then exports the data.
If I try modify the VB code generated by the package to match with new Source table it does'nt work.

Can anyone tell me what should I do for export the data dynamically i.e. export the tables with differrent structres?

Thanx in advance.|||You should do a helluvalotta programming. DTS sucks, and I don't believe most people on this forum use it for much more than directly transfering defined recordsets.

Exported PDF Security

Hi All
I am using SQL Reporting Services. I looked into the properties of the
generated .pdf file and it allows user to edit the file contents using a
full version Adobe Acrobat.
Is it possible to make the exported PDF file uneditable ? Any help on this
will be hisghly appreciated
Thanks
Vaibhav SharmaIf anyone says yes, well theyre wrong.
The issue here is not Reporting Services but rather the PDF Spec,
Using tools I will NOT mention here , I can edit any PDF , from any
source "AT-WILL"
The funny part is the tools I use are the same tools "I" use for allpdf
work and I have had developers/designers choke on their words many a
times over this exact issue.
I go by the xiom of , "If a client can read it, so can I" (client being
client tool, webbrowser, pdfviewer etc) but you can always take that a
step further and say "If I can read it I can change it"
NOW All that said is there a way to "Lock" a PDF Against edit for the
other 99% of people, yes, but I am unsure if RS has it implemented, I
have not seen it anywhere in the docs.|||RS does not support any type of locking of the PDF. You could write your own
extension to do this.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"WertmanTheMad" <cwertman@.webchamps.com> wrote in message
news:1104179054.142883.151010@.f14g2000cwb.googlegroups.com...
> If anyone says yes, well theyre wrong.
> The issue here is not Reporting Services but rather the PDF Spec,
> Using tools I will NOT mention here , I can edit any PDF , from any
> source "AT-WILL"
> The funny part is the tools I use are the same tools "I" use for allpdf
> work and I have had developers/designers choke on their words many a
> times over this exact issue.
> I go by the xiom of , "If a client can read it, so can I" (client being
> client tool, webbrowser, pdfviewer etc) but you can always take that a
> step further and say "If I can read it I can change it"
> NOW All that said is there a way to "Lock" a PDF Against edit for the
> other 99% of people, yes, but I am unsure if RS has it implemented, I
> have not seen it anywhere in the docs.
>|||Any pointers on how to do that? I mean how to go about writing an extension.
TIA
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OZBq3bF7EHA.1260@.TK2MSFTNGP12.phx.gbl...
> RS does not support any type of locking of the PDF. You could write your
> own
> extension to do this.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "WertmanTheMad" <cwertman@.webchamps.com> wrote in message
> news:1104179054.142883.151010@.f14g2000cwb.googlegroups.com...
>> If anyone says yes, well theyre wrong.
>> The issue here is not Reporting Services but rather the PDF Spec,
>> Using tools I will NOT mention here , I can edit any PDF , from any
>> source "AT-WILL"
>> The funny part is the tools I use are the same tools "I" use for allpdf
>> work and I have had developers/designers choke on their words many a
>> times over this exact issue.
>> I go by the xiom of , "If a client can read it, so can I" (client being
>> client tool, webbrowser, pdfviewer etc) but you can always take that a
>> step further and say "If I can read it I can change it"
>> NOW All that said is there a way to "Lock" a PDF Against edit for the
>> other 99% of people, yes, but I am unsure if RS has it implemented, I
>> have not seen it anywhere in the docs.
>|||I know it is possible because 3rd parties have come up with additional
rendering extensions but looking at it another way (and definitely easier)
you could have a delivery extension (if you are sending this via
subscriptions). Your delivery extension could save the report as a pdf file,
then run it through whatever utility that locks the pdf and then you send it
on via the email. Look in the help on delivery extension.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Vaibhav" <consultvaibhav@.yahoo.com> wrote in message
news:eC7tX7F7EHA.2196@.TK2MSFTNGP14.phx.gbl...
> Any pointers on how to do that? I mean how to go about writing an
extension.
> TIA
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OZBq3bF7EHA.1260@.TK2MSFTNGP12.phx.gbl...
> > RS does not support any type of locking of the PDF. You could write your
> > own
> > extension to do this.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "WertmanTheMad" <cwertman@.webchamps.com> wrote in message
> > news:1104179054.142883.151010@.f14g2000cwb.googlegroups.com...
> >> If anyone says yes, well theyre wrong.
> >>
> >> The issue here is not Reporting Services but rather the PDF Spec,
> >>
> >> Using tools I will NOT mention here , I can edit any PDF , from any
> >> source "AT-WILL"
> >>
> >> The funny part is the tools I use are the same tools "I" use for allpdf
> >> work and I have had developers/designers choke on their words many a
> >> times over this exact issue.
> >>
> >> I go by the xiom of , "If a client can read it, so can I" (client being
> >> client tool, webbrowser, pdfviewer etc) but you can always take that a
> >> step further and say "If I can read it I can change it"
> >>
> >> NOW All that said is there a way to "Lock" a PDF Against edit for the
> >> other 99% of people, yes, but I am unsure if RS has it implemented, I
> >> have not seen it anywhere in the docs.
> >>
> >
> >
>|||Thanks very much.
But in my case i am not sending file by susbscription, i am displaying
report as link and generating it on demand like an invoice pdf file.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:ebWjTnG7EHA.2608@.TK2MSFTNGP10.phx.gbl...
>I know it is possible because 3rd parties have come up with additional
> rendering extensions but looking at it another way (and definitely easier)
> you could have a delivery extension (if you are sending this via
> subscriptions). Your delivery extension could save the report as a pdf
> file,
> then run it through whatever utility that locks the pdf and then you send
> it
> on via the email. Look in the help on delivery extension.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Vaibhav" <consultvaibhav@.yahoo.com> wrote in message
> news:eC7tX7F7EHA.2196@.TK2MSFTNGP14.phx.gbl...
>> Any pointers on how to do that? I mean how to go about writing an
> extension.
>> TIA
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:OZBq3bF7EHA.1260@.TK2MSFTNGP12.phx.gbl...
>> > RS does not support any type of locking of the PDF. You could write
>> > your
>> > own
>> > extension to do this.
>> >
>> > --
>> > Bruce Loehle-Conger
>> > MVP SQL Server Reporting Services
>> >
>> > "WertmanTheMad" <cwertman@.webchamps.com> wrote in message
>> > news:1104179054.142883.151010@.f14g2000cwb.googlegroups.com...
>> >> If anyone says yes, well theyre wrong.
>> >>
>> >> The issue here is not Reporting Services but rather the PDF Spec,
>> >>
>> >> Using tools I will NOT mention here , I can edit any PDF , from any
>> >> source "AT-WILL"
>> >>
>> >> The funny part is the tools I use are the same tools "I" use for
>> >> allpdf
>> >> work and I have had developers/designers choke on their words many a
>> >> times over this exact issue.
>> >>
>> >> I go by the xiom of , "If a client can read it, so can I" (client
>> >> being
>> >> client tool, webbrowser, pdfviewer etc) but you can always take that a
>> >> step further and say "If I can read it I can change it"
>> >>
>> >> NOW All that said is there a way to "Lock" a PDF Against edit for the
>> >> other 99% of people, yes, but I am unsure if RS has it implemented, I
>> >> have not seen it anywhere in the docs.
>> >>
>> >
>> >
>>
>|||If you have your own UI (i.e. not using Report Manager but using your own
ASP.net application) then you could use the same technique by using web
services to first render PDF on your server, run the untility and then send
the resultant protected PDF to the user. If you want to use Report Manager
portal then there is not an easy solution that I can think of.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Vaibhav" <consultvaibhav@.yahoo.com> wrote in message
news:Of5HKMP7EHA.3908@.TK2MSFTNGP12.phx.gbl...
> Thanks very much.
> But in my case i am not sending file by susbscription, i am displaying
> report as link and generating it on demand like an invoice pdf file.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:ebWjTnG7EHA.2608@.TK2MSFTNGP10.phx.gbl...
> >I know it is possible because 3rd parties have come up with additional
> > rendering extensions but looking at it another way (and definitely
easier)
> > you could have a delivery extension (if you are sending this via
> > subscriptions). Your delivery extension could save the report as a pdf
> > file,
> > then run it through whatever utility that locks the pdf and then you
send
> > it
> > on via the email. Look in the help on delivery extension.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Vaibhav" <consultvaibhav@.yahoo.com> wrote in message
> > news:eC7tX7F7EHA.2196@.TK2MSFTNGP14.phx.gbl...
> >> Any pointers on how to do that? I mean how to go about writing an
> > extension.
> >>
> >> TIA
> >>
> >>
> >> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> >> news:OZBq3bF7EHA.1260@.TK2MSFTNGP12.phx.gbl...
> >> > RS does not support any type of locking of the PDF. You could write
> >> > your
> >> > own
> >> > extension to do this.
> >> >
> >> > --
> >> > Bruce Loehle-Conger
> >> > MVP SQL Server Reporting Services
> >> >
> >> > "WertmanTheMad" <cwertman@.webchamps.com> wrote in message
> >> > news:1104179054.142883.151010@.f14g2000cwb.googlegroups.com...
> >> >> If anyone says yes, well theyre wrong.
> >> >>
> >> >> The issue here is not Reporting Services but rather the PDF Spec,
> >> >>
> >> >> Using tools I will NOT mention here , I can edit any PDF , from any
> >> >> source "AT-WILL"
> >> >>
> >> >> The funny part is the tools I use are the same tools "I" use for
> >> >> allpdf
> >> >> work and I have had developers/designers choke on their words many a
> >> >> times over this exact issue.
> >> >>
> >> >> I go by the xiom of , "If a client can read it, so can I" (client
> >> >> being
> >> >> client tool, webbrowser, pdfviewer etc) but you can always take that
a
> >> >> step further and say "If I can read it I can change it"
> >> >>
> >> >> NOW All that said is there a way to "Lock" a PDF Against edit for
the
> >> >> other 99% of people, yes, but I am unsure if RS has it implemented,
I
> >> >> have not seen it anywhere in the docs.
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>

Export to PDF stopped working after XP SP2 is installed on client's machine

Hi All
We are having a problem after XP SP2 is installed on the user's machine, the
export to PDF no longer works as instead on opening the report in PDF format
inside the browser it actually tries to save the .aspx page, I think it is
something to do with MIME types.
Has anyone noticed this issue and is there a work around.
Please help
Rahulmake sure your adobe reader is installed properly. we had this problem
to, and it turned out that adobe installation had not been completed.
This was only a problem with the new adobe 6.2, 6.0 was fine.
"Rahul Agarwal" <agarwal_rahul@.hotmail.com> wrote in message news:<#R7F9aOpEHA.324@.TK2MSFTNGP11.phx.gbl>...
> Hi All
> We are having a problem after XP SP2 is installed on the user's machine, the
> export to PDF no longer works as instead on opening the report in PDF format
> inside the browser it actually tries to save the .aspx page, I think it is
> something to do with MIME types.
> Has anyone noticed this issue and is there a work around.
> Please help
> Rahul

Export to PDF only showing 1 Page

Hello,
I have a simple report (rdl available but the ms browser wont let me upload
it) that runs and displays fine on screen; when a user does an export to pdf
they only get the first page. On screen we are seeing 18 pages in total in
IE.
When we export to PDF we only get the first page; exporting to excel is
showing all the information correctly...
The server is windows 2003, sql 2000 sp4 the clients are windows 2000/ ie6
and either windows xp / ie6 / ie7 and the same is happening for all users.
We are accessing the reports from inside an iframe generally; calling the
report with the required parameters. Though when we try it using the URL the
same export happens.
There are about 40 reports on the server and only this one is affected.
Thanks
ChrisIt might be that some of the report elements are sitting on top of each
other.
Try opening the report in your designer, and move all the elements so that
you make sure none are covering the others. Then upload and see if this
solves it.
Kaisa M. Lindahl Lervik
"Chris Hoare" <choare@.nospam.nospam> wrote in message
news:0004CD40-F271-4AC9-9875-3276DC0B5558@.microsoft.com...
> Hello,
> I have a simple report (rdl available but the ms browser wont let me
> upload
> it) that runs and displays fine on screen; when a user does an export to
> pdf
> they only get the first page. On screen we are seeing 18 pages in total in
> IE.
> When we export to PDF we only get the first page; exporting to excel is
> showing all the information correctly...
> The server is windows 2003, sql 2000 sp4 the clients are windows 2000/ ie6
> and either windows xp / ie6 / ie7 and the same is happening for all users.
> We are accessing the reports from inside an iframe generally; calling the
> report with the required parameters. Though when we try it using the URL
> the
> same export happens.
> There are about 40 reports on the server and only this one is affected.
> Thanks
> Chris
>
>|||No there are no hidden overlapping The only expressions in the report handle
some color formatting on the numbers on the report to highlight exceptions.
We managed to get it to export on a pc running XP SP2 / Office 2003 last
night; but we havent had any luck with other reports.
Also tried deleting it out from reporting services manager, changing the
report history to store 1 copy of the report.|||Hi choare,
Thank you for the post.
Would you pleae send the report file to me? You may send to me directly. I
understand the information may be sensitive to you, my direct email address
is weilu@.ONLINE.microsoft.com (Please remove the ONLINE when you send the
mail), you may send the file to me directly and I will keep secure.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Export to Excel--customizing the save option

Hi,
Am creating reports using Sql Reporting services. Suppose am creating a
report for all the users and the file name is "User Report" and am passing
the "username" by parametervalue. while exporting it to excel, a dialogue box
appears which gives an option of 'open','save','cancel' with "user
Report.xls". but what if i have to save it specific to the paramvalue i.e-- "
<username> UserReport.xls"'I dont think you can do that just from the report Manager.
You will have to write your own application to display the
reports and the provide a export to excel option and then
render the report in excel format(using the Web Services
Render method) and save the excel file from code with the
desired filename.
>--Original Message--
>Hi,
>Am creating reports using Sql Reporting services. Suppose
am creating a
>report for all the users and the file name is "User
Report" and am passing
>the "username" by parametervalue. while exporting it to
excel, a dialogue box
>appears which gives an option of 'open','save','cancel'
with "user
>Report.xls". but what if i have to save it specific to
the paramvalue i.e-- "
><username> UserReport.xls"'
>
>.
>

export to excel, file not found

With sp1 installed, when a user exports a chart to excel via url
(ReportServerUrl/MyReport&rs:Command=Render&rs:Format=EXCEL ... I set this up
as a link on the report) everything works when the user has office xp
installed, but with office 2000, the user can only use the save as feature,
and then open the excel rendered chart. If the user selects "open" from the
dialog prompt, they get an error:
C:\Documents and Settings\User\Local Settings\Temporary Internet
Files\Content.IE5\KJYHDDL\Chart[1].xls Could not be found. Check the
spelling of the name ...
Is this the result of a browser setting, or server security on my end?
Thanks for any help.Have you installed Reporting Services SP1 on the server? This is required
for Office 2000 support.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JeffW" <JeffW@.discussions.microsoft.com> wrote in message
news:396BF27F-0526-43BC-BB78-D59DDE5B6058@.microsoft.com...
> With sp1 installed, when a user exports a chart to excel via url
> (ReportServerUrl/MyReport&rs:Command=Render&rs:Format=EXCEL ... I set this
> up
> as a link on the report) everything works when the user has office xp
> installed, but with office 2000, the user can only use the save as
> feature,
> and then open the excel rendered chart. If the user selects "open" from
> the
> dialog prompt, they get an error:
> C:\Documents and Settings\User\Local Settings\Temporary Internet
> Files\Content.IE5\KJYHDDL\Chart[1].xls Could not be found. Check the
> spelling of the name ...
> Is this the result of a browser setting, or server security on my end?
> Thanks for any help.|||Brian,
Thanks for your reply.
I have installed sp1 on the server, and verified that both my dev
environment and server are running version 8.00.878.00. Also, the excel
export does work, when the user chooses to save the file and then open it
(office 2000). It only fails when they try to open the exported chart
directly from the dialog that says "You are downloading the file ... Would
you like to open the file or save it to your computer ...". And it only
happens when to office 2000 or less users.
After installing sp1 on the server, I did not reboot or anything, but
confirmed that the version matched my dev environment that also has sp1.
Should I create the report from scratch or are there files/timestamps I
should be looking for on the server related to the renderer/exporter?
Thanks,
JeffW
"Brian Welcker [MSFT]" wrote:
> Have you installed Reporting Services SP1 on the server? This is required
> for Office 2000 support.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "JeffW" <JeffW@.discussions.microsoft.com> wrote in message
> news:396BF27F-0526-43BC-BB78-D59DDE5B6058@.microsoft.com...
> > With sp1 installed, when a user exports a chart to excel via url
> > (ReportServerUrl/MyReport&rs:Command=Render&rs:Format=EXCEL ... I set this
> > up
> > as a link on the report) everything works when the user has office xp
> > installed, but with office 2000, the user can only use the save as
> > feature,
> > and then open the excel rendered chart. If the user selects "open" from
> > the
> > dialog prompt, they get an error:
> >
> > C:\Documents and Settings\User\Local Settings\Temporary Internet
> > Files\Content.IE5\KJYHDDL\Chart[1].xls Could not be found. Check the
> > spelling of the name ...
> >
> > Is this the result of a browser setting, or server security on my end?
> >
> > Thanks for any help.
>
>

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
> >>
>
>