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 reports into EXCEL format

Hi,

My organization is currently migrating from reporting services 2000 to reporting services 2005. We are having an issue with exporting reports into EXCEL format. Basically we have a table with five grouping hierarchy. The parent groupings toggle the visibility of the corresponding sub groupings. It works as expected when deployed to the report server, however when exported into Excel it expands to level 4 even though level 3 was not actually exploded.
Note that the same report exports correctly to Excel in the previous version of Reporting Services but in the 2005 version it skips one level of grouping.

Is this a bug in reporting services 2005? I saw some other people posting similar issues.

Any help would be much appreciated!

Thanks,
Radu

Hello,

In RS2000, excel renderer didn't include toggled items if we couldn't generate the outline and they current state was collapsed.

We changed this behavior in RS2005 based on customer input - the toggled items will be included in excel output regardless of thery collapse/expand state. Every time is possible we will generate the outline accordinglly.

I suspect you don't have an excel outline for level 4. Is this correct?

Thank you,

Nico

|||

Hi Nico,

Thanks a lot for your timely response!

We actually get an Excel outline for level 4. However, we miss level 3 information completely after the export to Excel. Our current process creates the report exploded up to level 3. Some users need to export it to Excel at exactly the same level of detail (and they do not need the data at the more detailed levels).

Also, the export to Excel takes much longer (and creates a much bigger file) in the new version (2005), probably because of exporting to the most detailed level. It also explodes to level 4 instead of level 3.

Could this be caused by the fact that the RDL file was originally created in RS2000 and subsequently migrated to RS2005? I still have the migration logs and got no errors or warnings there. I can provide the RDL file if necessary.

Is there a way to control what levels are exported to Excel and how they get exploded there? In this particular case we don't even need to export data for the most detailed levels (from level 4 and up).

Thanks in advance,

Radu

|||

Hi Radu,

In RS2005 all the levels will be included in the excel output and it is a behavior change from RS2000. You cannot control individual levels.

Can you send us the rdl, please? I would like to investigate the missing information (for level 3) part.

Thanks,

Nico

|||

Hi Nico,

Thanks for the clarification! Very good to know!

Nevertheless, it would have been nice to have the ability to select the depth (up to which level of grouping) for the export to Excel.

I would gladly send the RDL file but please advise me how to proceed: can I simply embed the code in my message (the RDL file is about 150 kB) or is there a way to attach the file?

Regards,

Radu

sql

Exporting in XML format

Is there a way of exporting data in XML format from SQL Server 2000, there is a wizard for exporting to a html file but I can't seem to find one to export into an XML file?A week and no replies?

All I want to do is create an XML document from sql server 2000 and have it written to a shared drive so I can read it from our webserver!

I know to produce on the fly such as SELECT * FROM VW_Web_Curr_Projs1 FOR XML AUTO, but how to write this result to an xml document
Or am I going about this the wrong way, any help please?|||

Take a look here

http://www.perfectxml.com/articles/XML/ExportSQLXML.asp

sql

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 Dates to Excel as date format

Hi,

I'm currently having problems exporting formatted dates from reporting services 2005 to excel.

Basically what I require is a way to format a date in reporting services so that it only shows the date without the time (preferably british format) and when it is exported to excel it is still formatted as a date.

This is so the user can sort the data file via date, I appreciate it is easy to select the column and format the cells but i would prefer to have a 'cleaner' solution to this problem which avoids the need for users to be formatting exported reports.

Originally I was formatting the dates as convert(varchar,@.date,103) in the SP which converts it to a character string and excel picks this up as a character as would be expected. So I changed this to a date and set about trying to format the date in Reporting Services, so far i've been unsuccesfull using cdate (brings back the time) and format as it again converts it to a character string.

Any help or advice would be greatly appreciated,

R

i had the same problem before,

i inserted a space before the mm/yyyy when after converted it into char.

it should work

sql

Exporting Data/1st three lines NOT CSV..

I have a specific format that I need to export data to. The first three lines of the document MUST be in the form of:

ascii
,
klg, Eastern Daylight Time,1,1
PineGrove,0,2005/10/01,00:00,1,1.75,192
PineGrove,0,2005/10/01,00:05,1,1.75,192
Pinegrove,0,2005/10/01,00:10,1,1.75,192

If I set this up in DTS and do an export, it puts commas after ascii - which I cannot have.

I've also tried using two data sources and exporting twice (hoping to append), however, one just overwrites the other.

Anyone have any ideas?? :o

Thanks in advance,
KristaIs this from a table?

Read the sticky at the top|||A couple of ideas...

You can create two text files, one with the headers. Then use the dos copy command to make one file.

copy file1+file2 file3

Another option is to create a temporary staging table. It can have one large varchar column that contains the data. Then export from this table. This option requires a little work.

Bill|||A couple of ideas...

You can create two text files, one with the headers. Then use the dos copy command to make one file.

copy file1+file2 file3 [B][I]

Bill

YOU'RE AWESOME!! I WAS TRYING TO REMEMBER HOW TO DO THIS EARLIER TODAY!! THANKS SO MUCH!!!!!!! :D|||You're welcome.

Check your PM.|||What's PM?|||Private Messagesql

Exporting Data from Database to a csv file

Hi,

How do I export data from my database table into a Comma separated value file format.

I am using SQL Server 2005 with vb.net

Thanks

you can try bcp.exe.|||It would use the SQL Server Import / Export wizard , it is more comfortable than the BCP command, although in some cases like automatic commandline export thats the only choice. Right click the database and choose the Export... command. You will be guided though a wizard for exporting.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

HI baroo,

Now I have the same task but I can't find out how to do it...I also have to transfer csv to SQL,although I did it but I don't know how to export data from SQL to a csv file...

Did you solve it?If so coúld you also explain me how to do it?

Thanks,

Can

|||Try bcp.exe or import/export wizard, as mentioned above.|||

Hi Greg,

Thank you for the reply,I am writing a program in VB Express (SQL server express 2005) and I have to do it through coding...I tried data reader writer.writeline but it didn't work out...

Do you have an idea how can I do it using ADO or BCP but through coding....

Thanks&regards,

Can

|||

Reference SQL 2005 Books Online topic "Overview of Bulk Import and Bulk Export" for more information.

Exporting Data from Database to a csv file

Hi,

How do I export data from my database table into a Comma separated value file format.

I am using SQL Server 2005 with vb.net

Thanks

you can try bcp.exe.|||It would use the SQL Server Import / Export wizard , it is more comfortable than the BCP command, although in some cases like automatic commandline export thats the only choice. Right click the database and choose the Export... command. You will be guided though a wizard for exporting.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

HI baroo,

Now I have the same task but I can't find out how to do it...I also have to transfer csv to SQL,although I did it but I don't know how to export data from SQL to a csv file...

Did you solve it?If so coúld you also explain me how to do it?

Thanks,

Can

|||Try bcp.exe or import/export wizard, as mentioned above.|||

Hi Greg,

Thank you for the reply,I am writing a program in VB Express (SQL server express 2005) and I have to do it through coding...I tried data reader writer.writeline but it didn't work out...

Do you have an idea how can I do it using ADO or BCP but through coding....

Thanks&regards,

Can

|||

Reference SQL 2005 Books Online topic "Overview of Bulk Import and Bulk Export" for more information.

exporting crystal report to text format

Hi there! Can anyone help me with this: what dll's do i need in order to export a crystal report to text format during runtime.

When i run my program in visual basic 6, the exporting is done successfully. but when im using it in .exe, errors are generated.

i already used U2FTXT.DLL

what could be the problem?

pls help me... thanks a lot!Look at this thread, you might need one more dll:

http://www.dev-archive.com/forum/showthread.php?t=287692&highlight=export+text

JeffB

Exporting Crystal Report To Excel

Hi,
I am having a problem while exporting Crystal Report to Excel Format. It is giving an error saying 'Missing Parameter Current Value' even after passing the parameters. Can any one help.
Thanks
MohithHi,

I try to export crystal report to excel format and its works fine.
but i don't know which version u used for crystal reports and excel

-Yags|||Try looking up the error message in Google or some other search engine.

Crystal Reports Online Tech Support:
http://support.businessobjects.com/search/advsearch.asp

Crystal Reports Forum:
http://support.businessobjects.com/forums/default.asp

exporting a crystal report to pdf format using vb application

hai
how to export a crystal report to pdf format using vb application
please help me
thank u
rachamalluUnless you provide more information, it will be rather difficult to help you. What version of Crystal Reports are you using? What method are you using to display your reports? etc...

Try to do a search on Crystal's Website:

http://support.businessobjects.com/search/advsearch.asp|||i am using crystal report 6.0 and vb 6.0

i am using crystalreport1.printreport to display the report|||I had read somewhere that exporting to pdf through code isn't available in versions previous to 8.5, but I'm not positive. If you can upgrade to 8.5, I can tell you how to do it using RDC (Report Designer Component) as that's what I use for Exporting.

Unless you're referring to exporting based on pressing the export button on the report itself. If thats the case, then you just need to have the correct dlls installed on the machine you're using.|||hai

how to export a crystal report to pdf format using vb application

please help me

thank u

Shahla|||The following code uses RDC to export to PDF

Dim mCrApp As New CRAXDRT.Application
Dim mCrrep As CRAXDRT.Report

mCrrep.ExportOptions.DiskFileName = OutputFileName
mCrrep.ExportOptions.DestinationType = crEDTDiskFile
mCrrep.ExportOptions.FormatType = OutputFileType

'In case u want to export the complete report, use the following code

mCrrep.ExportOptions.PDFExportAllPages = True

In case u want to export a page range from the report, use the following code

mCrrep.ExportOptions.PDFExportAllPages = False
mCrrep.ExportOptions.PDFFirstPageNumber = StartPage
mCrrep.ExportOptions.PDFLastPageNumber = EndPage

mCrrep.Export False

Exportin to Excel Format Issue

I have a report that contains a matrix control on it. The problem I'm having
is when I export the report to Excel some of the data is not recognized a
numeric and I get the green triangle in the corner of the cell. I believe
this is due to the matrix having some blank columns along with numeric data.
If I fill the report with a 0â's instead of "", the report becomes very hard
to read and is not acceptable by the client.
I have tried setting the textbox visibility to false, but then that also
removes the grid lines around the cell.
I have tried to create a custom format based on the data type and that did
not work.
Does anyone know how I can format just the numeric fields to a number and
the still leave the blank cells as blank when I export to Excel? Thanks...
I have provided a basic example below.
Row1 - 45 - 55 - - 60
Row2 - 50 - - 45 - 45We are having a similiar problem. The only way we have found is the copy,
paste special, values in a new worksheet. You loose all formating in that
case.
"cws" wrote:
> I have a report that contains a matrix control on it. The problem I'm having
> is when I export the report to Excel some of the data is not recognized a
> numeric and I get the green triangle in the corner of the cell. I believe
> this is due to the matrix having some blank columns along with numeric data.
> If I fill the report with a 0â's instead of "", the report becomes very hard
> to read and is not acceptable by the client.
> I have tried setting the textbox visibility to false, but then that also
> removes the grid lines around the cell.
> I have tried to create a custom format based on the data type and that did
> not work.
> Does anyone know how I can format just the numeric fields to a number and
> the still leave the blank cells as blank when I export to Excel? Thanks...
> I have provided a basic example below.
> Row1 - 45 - 55 - - 60
> Row2 - 50 - - 45 - 45
>sql

Exported Excel file is too big, any idea? Thanks!

We have a report that we want to have it in Excel format, we need export it
from sql report and load in Excel and add some other elements like dropdown.
The problem is the 100 pages report is 12M when I export it from sql report.
After I load it into Excel and save it again, it is only 700k. Is there
anyway I can make the process more efficient? it is simple too
time-consuming to save a 12M file and process it.
Thanks!
--
David WENGLook here, this isn´t the binary format for excel, that the cause of being
that big.
http://groups.google.de/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/f030cce8c804755/1d99a5cbbf5cff80?q=excel+%22reporting+services%22+size&rnum=5&hl=de#1d99a5cbbf5cff80
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"davidw" <davidw@.affinisys.com> schrieb im Newsbeitrag
news:eNjKukkWFHA.3240@.TK2MSFTNGP10.phx.gbl...
> We have a report that we want to have it in Excel format, we need export
> it
> from sql report and load in Excel and add some other elements like
> dropdown.
> The problem is the 100 pages report is 12M when I export it from sql
> report.
> After I load it into Excel and save it again, it is only 700k. Is there
> anyway I can make the process more efficient? it is simple too
> time-consuming to save a 12M file and process it.
>
> Thanks!
> --
> David WENG
>
>|||SP1/SP2 will use binary format instead of XML format for rendering Excel.
You might also want to consider using jump to URL and render as CSV and
ASCII (note that the export to CSV from toolbar does Unicode which Excel
does not recognize, when rendering CSV and ASCII it will be very fast). 100
pages will take quite awhile for RS to render (my guess is between 2 and 5
minutes) and will really put a load on the server. Going to CSV in ASCII
format will take seconds.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"davidw" <davidw@.affinisys.com> wrote in message
news:eNjKukkWFHA.3240@.TK2MSFTNGP10.phx.gbl...
> We have a report that we want to have it in Excel format, we need export
> it
> from sql report and load in Excel and add some other elements like
> dropdown.
> The problem is the 100 pages report is 12M when I export it from sql
> report.
> After I load it into Excel and save it again, it is only 700k. Is there
> anyway I can make the process more efficient? it is simple too
> time-consuming to save a 12M file and process it.
>
> Thanks!
> --
> David WENG
>
>

ExportData

Hi All ...
I am looking for simple T-SQL syntax for using ExportData method with
Bulkcopy object to export one table in tab delimited, text file format to
C:\TableName.txt. First row of text file should be column headers.
Anybody know offhand?
[TableName].ExportData ?
Thanks for your help ...When you refer to the BulkCopy object and ExportData method, you must be
speaking of Data Management Objects (DMO), which isn't easily called from
T-SQL. The best and most prevalent method of exporting data to a text file
would be to create a DTS package.
"bill_morgan" <billmorgan@.discussions.microsoft.com> wrote in message
news:FD5558FE-CB29-44A6-ADA8-24DD306527CE@.microsoft.com...
> Hi All ...
> I am looking for simple T-SQL syntax for using ExportData method with
> Bulkcopy object to export one table in tab delimited, text file format to
> C:\TableName.txt. First row of text file should be column headers.
> Anybody know offhand?
> [TableName].ExportData ?
> Thanks for your help ...
>
>|||I like to use T-sql script wherever possible, but sounds like this is one of
those times when it's best not to. Thanks for your help.
"JT" wrote:

> When you refer to the BulkCopy object and ExportData method, you must be
> speaking of Data Management Objects (DMO), which isn't easily called from
> T-SQL. The best and most prevalent method of exporting data to a text file
> would be to create a DTS package.
> "bill_morgan" <billmorgan@.discussions.microsoft.com> wrote in message
> news:FD5558FE-CB29-44A6-ADA8-24DD306527CE@.microsoft.com...
>
>

Export wizard trouble exporting columns names to ragged file.

I’m using the Import\Export wizard to export the top 5 lines from a MS Sql table into a fixed format (“ragged”) file.But I want the first record to contain the column names of the exported fields so I selected the “Column names in the first data row” option of the “Choose a Destination” box. When I run the Package I get:

>>>

· Information 0x402090dc: Data Flow Task: The processing of file "C:\barkingdog\ExportWithheader.txt" has started (SQL Server Import and Export Wizard)

· Error 0xc0202095: Data Flow Task: Failed to write out column name for column "CustomerID".
(SQL Server Import and Export Wizard)

Error 0xc004701a: Data Flow Task: component "Destination - ExportWithheader_txt" (49) failed the pre-execute phase and returned error code 0xC0202095.
(SQL Server Import and Export Wizard)

>>>

When I de-select the “Column names” option, the package works fine.Other than manually, how can I et the column names in output file?

TIA,

Barkingdog

That's very strange. I'm racking my brains as to what might be the problem but I can't think of anything!

Is there any other clue as to what is the problem?

-Jamie

|||

The problem here is that when you include column names in the first data row, then you might need to modify the column width (for a ragged right file). For example, if you have a column CustomerID which is of type DT_STR(5), it will fail trying to write "CustomerID" in that space, which takes 10 characters. Use the Edit Transform button on configure Flat File Destination page of the Import Export Wizard to adjust the length specified for each fixed width column.

hope that helps.

|||

Ranjetta,

I thought that that could be the case but I haven't had a chance to test it.

I also have to test if the "Import" wizard, with "column names in first row", has the same issue. My impression is no and perhaps the Export wizard is not as forgiving as the Import one. I will check.

Barkingdog

export with a webservice

Hi,
I have created an application with VIsual Studio.NET in C#. I used a
webservice in order to view my reports.
I want export my report in format that I want with this application.
How can I do? What is the solution?I've done this by putting into a dropdownlist the available export formats
for a particular report. then when i go to render the report i have the
following code:
try
{
report =rs.Render(reportPath,format,historyID,devInfo,parameters,credentials,showHideToggle,out
encoding, out mimeType, out optionalParams, out optionalWarnings, out
streamIDs);
switch(format)
{
case "PDF":
Response.ClearContent();
Response.AppendHeader("content-length", report.Length.ToString());
Response.ContentType = "application/pdf";
Response.BinaryWrite(report);
Response.Flush();
Response.Close();
break;
case "CSV":
Response.ClearContent();
Response.AppendHeader("content-length", report.Length.ToString());
Response.ContentType = "application/vnd.ms-excel";
Response.BinaryWrite(report);
Response.Flush();
Response.Close();
break;
case "EXCEL":
Response.ClearContent();
Response.AppendHeader("content-length", report.Length.ToString());
Response.ContentType = "application/vnd.ms-excel";
Response.BinaryWrite(report);
Response.Flush();
Response.Close();
break;
default:
Label1.Text = System.Text.Encoding.Default.GetString(report);
break;
}
}
catch (SoapException se)
{
Console.WriteLine(se.Detail.OuterXml);
}
"r388042" wrote:
> Hi,
> I have created an application with VIsual Studio.NET in C#. I used a
> webservice in order to view my reports.
> I want export my report in format that I want with this application.
> How can I do? What is the solution?|||Thanks you!!!
It's run very good!!!
Do you know how we can do in order to export in XML or TIFF?

Export to Word or RTF in SQL Reporting services

does any know if SQL server reporting services will be offering a RTF format
export or Word export' I need this function - it force me to use crystal
reports (ARRGH!!)
Or does anyone know of a provider that made one?I know SoftArtisans (www.softartisans.com) is working on something in this
area. The feature did not make it on the list for SQL 2005.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chicago Dave" <Chicago Dave@.discussions.microsoft.com> wrote in message
news:767BAA7C-EE40-4858-BF0E-2CA3F22C032C@.microsoft.com...
> does any know if SQL server reporting services will be offering a RTF
> format
> export or Word export' I need this function - it force me to use crystal
> reports (ARRGH!!)
> Or does anyone know of a provider that made one?
>

Export to word or rtf format

I would like to know if it is possible to export a report created with reporting
service
in Microsoft Word or RTF format.
Thank's in advance
Giorgio ParmeggianiNot out of the box. I don't know if there are 3rd party renderers or not.
You can do Excel and PDF which might fit your needs. And, of course, HTML.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Giorgio Parmeggiani" <gipasoft@.newsgroups.nospam> wrote in message
news:ddf4e4a662b78c7c7182df905e2@.msnews.microsoft.com...
> I would like to know if it is possible to export a report created with
> reporting service in Microsoft Word or RTF format.
> Thank's in advance
> Giorgio Parmeggiani
>|||Hi Giorgio,
Welcome to use MSDN Managed Newsgroup!
We do not support render Word (RTF) format in the SQL Server Reporting
Services 2000/2005. You may try third party solution in the link below
Design Reports Using Microsoft Word
http://officewriter.softartisans.com/officewriter-296.aspx
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner 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.