export trace file to excel?

Hi
I would like to export all the information in my trace file to excel so I
can do a sort. Any suggestions on how to do this? I tried the standard copy
and paste method but the data didnt group correctly. Thanks.You can load the data from the trace file to a table using the
fn_trace_gettable system function and then pull the table into Excel.
Normally best done using SELECT INTO for minimal logging. BOL has good
examples for fn_trace_gettable.
HTH,
Plamen Ratchev
http://www.SQLStudio.com|||Theresa,
One possible approach:
1. Save the trace to a table in the database.
2. Use the export wizard to export the table to an Excel spreadsheet.
-- Bill
"Theresa" <Theresa@.discussions.microsoft.com> wrote in message
news:B835165F-8769-4BAB-9EFC-A0C68FF093BF@.microsoft.com...
> Hi
> I would like to export all the information in my trace file to excel so I
> can do a sort. Any suggestions on how to do this? I tried the standard
> copy
> and paste method but the data didnt group correctly. Thanks.|||Hi Theresa
Why don't you load the trace into a SQL Server table? You can sort a table
very easily.
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Theresa" <Theresa@.discussions.microsoft.com> wrote in message
news:B835165F-8769-4BAB-9EFC-A0C68FF093BF@.microsoft.com...
> Hi
> I would like to export all the information in my trace file to excel so I
> can do a sort. Any suggestions on how to do this? I tried the standard
> copy
> and paste method but the data didnt group correctly. Thanks.|||Thank you!! That works great!
"Plamen Ratchev" wrote:

> You can load the data from the trace file to a table using the
> fn_trace_gettable system function and then pull the table into Excel.
> Normally best done using SELECT INTO for minimal logging. BOL has good
> examples for fn_trace_gettable.
> HTH,
> Plamen Ratchev
> http://www.SQLStudio.com
>
>

export trace file to excel?

Hi
I would like to export all the information in my trace file to excel so I
can do a sort. Any suggestions on how to do this? I tried the standard copy
and paste method but the data didnt group correctly. Thanks.
You can load the data from the trace file to a table using the
fn_trace_gettable system function and then pull the table into Excel.
Normally best done using SELECT INTO for minimal logging. BOL has good
examples for fn_trace_gettable.
HTH,
Plamen Ratchev
http://www.SQLStudio.com
|||Theresa,
One possible approach:
1. Save the trace to a table in the database.
2. Use the export wizard to export the table to an Excel spreadsheet.
-- Bill
"Theresa" <Theresa@.discussions.microsoft.com> wrote in message
news:B835165F-8769-4BAB-9EFC-A0C68FF093BF@.microsoft.com...
> Hi
> I would like to export all the information in my trace file to excel so I
> can do a sort. Any suggestions on how to do this? I tried the standard
> copy
> and paste method but the data didnt group correctly. Thanks.
|||Hi Theresa
Why don't you load the trace into a SQL Server table? You can sort a table
very easily.
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Theresa" <Theresa@.discussions.microsoft.com> wrote in message
news:B835165F-8769-4BAB-9EFC-A0C68FF093BF@.microsoft.com...
> Hi
> I would like to export all the information in my trace file to excel so I
> can do a sort. Any suggestions on how to do this? I tried the standard
> copy
> and paste method but the data didnt group correctly. Thanks.
|||Thank you!! That works great!
"Plamen Ratchev" wrote:

> You can load the data from the trace file to a table using the
> fn_trace_gettable system function and then pull the table into Excel.
> Normally best done using SELECT INTO for minimal logging. BOL has good
> examples for fn_trace_gettable.
> HTH,
> Plamen Ratchev
> http://www.SQLStudio.com
>
>

export trace file to excel?

Hi
I would like to export all the information in my trace file to excel so I
can do a sort. Any suggestions on how to do this? I tried the standard copy
and paste method but the data didnt group correctly. Thanks.You can load the data from the trace file to a table using the
fn_trace_gettable system function and then pull the table into Excel.
Normally best done using SELECT INTO for minimal logging. BOL has good
examples for fn_trace_gettable.
HTH,
Plamen Ratchev
http://www.SQLStudio.com|||Theresa,
One possible approach:
1. Save the trace to a table in the database.
2. Use the export wizard to export the table to an Excel spreadsheet.
-- Bill
"Theresa" <Theresa@.discussions.microsoft.com> wrote in message
news:B835165F-8769-4BAB-9EFC-A0C68FF093BF@.microsoft.com...
> Hi
> I would like to export all the information in my trace file to excel so I
> can do a sort. Any suggestions on how to do this? I tried the standard
> copy
> and paste method but the data didnt group correctly. Thanks.|||Hi Theresa
Why don't you load the trace into a SQL Server table? You can sort a table
very easily.
--
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Theresa" <Theresa@.discussions.microsoft.com> wrote in message
news:B835165F-8769-4BAB-9EFC-A0C68FF093BF@.microsoft.com...
> Hi
> I would like to export all the information in my trace file to excel so I
> can do a sort. Any suggestions on how to do this? I tried the standard
> copy
> and paste method but the data didnt group correctly. Thanks.|||Thank you!! That works great!
"Plamen Ratchev" wrote:
> You can load the data from the trace file to a table using the
> fn_trace_gettable system function and then pull the table into Excel.
> Normally best done using SELECT INTO for minimal logging. BOL has good
> examples for fn_trace_gettable.
> HTH,
> Plamen Ratchev
> http://www.SQLStudio.com
>
>

Export to Excel problem in RS (updated)

Hello there,

Does anyone have a solution to the following export to excel problem i am experiencing in RS 2005 Standard Ed.

When exporting a matrix report in VS2005 (or in Report Manager) I get the following export error displayed in VS :

An error occurred during local report processing.

An error occurred during rendering of the report

Operation is not valid due to the current state of the object.

This is only a problem where exporting data into multiple worksheets - such as dept by dept on different wsheets.

Export to excel with 1 dept works fine.

I have managed to pinpoint the situation where this happens :

Matrix report with page break for the grouping.

I think there might be a fault with the export function.

Anyone like to confirm on this ?

|||

Did you ever find out if this was a bug?

I also have a problem with page breaks in matrix groupings where by I get blank pages when Print Previewing in Excel. However I am using RS 2000 with SP2.

Thanks

Scott

Export to Excel problem in RS (updated - some progress !!)

Hello there,

Does anyone have a solution to the following export to excel problem i am experiencing in RS 2005 Standard Ed.

When exporting a matrix report in VS2005 (or in Report Manager) I get the following export error displayed in VS :

An error occurred during local report processing.

An error occurred during rendering of the report

Operation is not valid due to the current state of the object.

This is only a problem where exporting data into multiple worksheets - such as dept by dept on different wsheets.

Export to excel with 1 dept works fine.

I have managed to pinpoint the situation where this happens :

Matrix report with page break for the grouping.

I think there might be a fault with the export function.

Anyone like to confirm on this ?

|||

Did you ever find out if this was a bug?

I also have a problem with page breaks in matrix groupings where by I get blank pages when Print Previewing in Excel. However I am using RS 2000 with SP2.

Thanks

Scott

Export to Excel problem in RS (updated - some progress !!)

Hello there,

Does anyone have a solution to the following export to excel problem i am experiencing in RS 2005 Standard Ed.

When exporting a matrix report in VS2005 (or in Report Manager) I get the following export error displayed in VS :

An error occurred during local report processing.

An error occurred during rendering of the report

Operation is not valid due to the current state of the object.

This is only a problem where exporting data into multiple worksheets - such as dept by dept on different wsheets.

Export to excel with 1 dept works fine.

I have managed to pinpoint the situation where this happens :

Matrix report with page break for the grouping.

I think there might be a fault with the export function.

Anyone like to confirm on this ?

|||

Did you ever find out if this was a bug?

I also have a problem with page breaks in matrix groupings where by I get blank pages when Print Previewing in Excel. However I am using RS 2000 with SP2.

Thanks

Scott