Exporting MSDE database from one installation to another

I have two hard drives, one contains a previous installation of MSDE and a
non-bootable OS and there is a database on that installation that I need to
import to my new MSDE instance on the new hard drive. Is there an easy way
to do this?Hi,
Since OS is non bootable , there is no chance to detach or to do a backup
all databases. Only option is:-
1. Copy all .MDF and .LDF files to a new folder (safe location)
2. Install SQL server and same Service packs (as old) in the identical
folder (Same as old installation)
3. Stop the new MSDE
4. Copy the .MDF and .LDF files (took in step 1) to the same folders (Same
as old installation).
5. Start MSDE
Now login to query analyzer or enterprise manager and confirm all the
databases are online.
Thanks
Hari
MCDBA
"Kal525" <Kal525@.discussions.microsoft.com> wrote in message
news:81E57616-2B2F-4426-AD58-4CE39EAA78D1@.microsoft.com...
> I have two hard drives, one contains a previous installation of MSDE and a
> non-bootable OS and there is a database on that installation that I need
to
> import to my new MSDE instance on the new hard drive. Is there an easy
way
> to do this?

Exporting MSDE database from one installation to another

I have two hard drives, one contains a previous installation of MSDE and a
non-bootable OS and there is a database on that installation that I need to
import to my new MSDE instance on the new hard drive. Is there an easy way
to do this?
Hi,
Since OS is non bootable , there is no chance to detach or to do a backup
all databases. Only option is:-
1. Copy all .MDF and .LDF files to a new folder (safe location)
2. Install SQL server and same Service packs (as old) in the identical
folder (Same as old installation)
3. Stop the new MSDE
4. Copy the .MDF and .LDF files (took in step 1) to the same folders (Same
as old installation).
5. Start MSDE
Now login to query analyzer or enterprise manager and confirm all the
databases are online.
Thanks
Hari
MCDBA
"Kal525" <Kal525@.discussions.microsoft.com> wrote in message
news:81E57616-2B2F-4426-AD58-4CE39EAA78D1@.microsoft.com...
> I have two hard drives, one contains a previous installation of MSDE and a
> non-bootable OS and there is a database on that installation that I need
to
> import to my new MSDE instance on the new hard drive. Is there an easy
way
> to do this?
sql

Exporting MSDE database from one installation to another

I have two hard drives, one contains a previous installation of MSDE and a
non-bootable OS and there is a database on that installation that I need to
import to my new MSDE instance on the new hard drive. Is there an easy way
to do this?Hi,
Since OS is non bootable , there is no chance to detach or to do a backup
all databases. Only option is:-
1. Copy all .MDF and .LDF files to a new folder (safe location)
2. Install SQL server and same Service packs (as old) in the identical
folder (Same as old installation)
3. Stop the new MSDE
4. Copy the .MDF and .LDF files (took in step 1) to the same folders (Same
as old installation).
5. Start MSDE
Now login to query analyzer or enterprise manager and confirm all the
databases are online.
Thanks
Hari
MCDBA
"Kal525" <Kal525@.discussions.microsoft.com> wrote in message
news:81E57616-2B2F-4426-AD58-4CE39EAA78D1@.microsoft.com...
> I have two hard drives, one contains a previous installation of MSDE and a
> non-bootable OS and there is a database on that installation that I need
to
> import to my new MSDE instance on the new hard drive. Is there an easy
way
> to do this?

Exporting data from Excel Tables to SQL Server Tables

Hi all,

I have a large Excel file with one large table which contains data, i've built a SQL Server DataBase and i want to fill it with the data from the excel file.

How can it be done?

Thanks, Michael.

If you are using SQL 2000 Standard or better, use DTS.

If you are using SQL2005/8 Standard or better, use SSIS.

If you are using SQL 2005/8 Express, get the Graphical User Interface for it and try that out.

p.s. What version of SQL Server are using?

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 PDF contains Extra Pages

Hi guys!

When displaying report using a ReportViewer, the single page displayed is just fine. An image at the left side, at table of information at the right. However, when exported to pdf, the image and the table is rendered on separate individual pages.

Is there anyway to modify this behaviour?

Thank in advance!

Have you tried to reduce the width of the report's body?

HTH, Best Regards|||

Hi visa,

Haven't done that yet but I would like to ask, why do you think the report's width thats causing this behaviour? I'm still new to Reporting Services... =)

Export to Mulitple Sheets in Excel

Hi,

I want to export data from SQL to Excel using Data Flow Task. But Excel file can only contains max. of 65,536 rows per sheet. How can I transfer data to multiple sheets if SQL table contains more that 650000 rows.

I am also looking for an answer to this. Very good question....

Export To Excel throws Error WrapperReportRenderingException

I have a report contains few tables.
The report runs without any problem (Url access) and export to other format
also without any problem.
Only when I export the same report to Excel, the following error occurs in
the reportserver log and its throws an error on screen.
This error only happens if I run the report with certain parameters. If I
select difference parameters, the report can export to excel successfully.
I have found out it is down to a table group - the group on expression, it
is using one of the dataset field which is a bigInt.
If I pick another field within the same dataset in the 'group on' expression
with the smae parameters, its works.
This bigInt field can be any value greater than 0 (usually a 9 characters
number) and could be a special defined value -1.
I hope there is enough information for anyone out there to help me....
Thanks
------
w3wp!reportrendering!e!11/29/2007-10:47:19:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
An error occurred during rendering of the report., ;
Info:
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
An error occurred during rendering of the report. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException: An
error occurred during rendering of the report. -->
System.InvalidOperationException: Operation is not valid due to the current
state of the object.
at
Microsoft.ReportingServices.ReportRendering.TableGroupCollection.get_Item(Int32
index)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetReferenceInTable(TableHeaderFooterRows
header, TableHeaderFooterRows footer, TableGroupCollection tableGroups,
TableRowsCollection detailRows, IntList indexPath, Int32 startIndex)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetReference(ReportItem
dataRegion, IntList indexPath, Int32 startIndex)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetReference(ReportItem
dataRegion, IntList indexPath, Int32 startIndex)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetReference(ReportItem
dataRegion, IntList indexPath, Int32 startIndex)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.CollectHiddenReportItems(IntList
indexPath, PageReportItems& pageRI)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreScanPage(ReportItem
parentDataRegion, Boolean isPageNeedsEvaluation, PageLayout& pageLayout,
PageReportItems& pageRIItems, Stack& dynamicLayoutStack, Hashtable&
rowHeightStateList, OutlineRenderStates[]& verticalOutlineStates,
OutlineRenderStates[]& horizontalOutlineStates)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderStaticPage(ReportItem
parentDataRegion, PageLayout pageLayout, Hashtable formulaRIMap, Int32
currentPageNumber, PageReportItems& pageRIItems, Stack& dynamicLayoutStack)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageLayout(PageLayout
pageLayout, Int32& currentPageNumber, Stack& stack)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageCollection(PageCollection
pageCollection, Int32& currentPageNumber, Stack& stack, PageLayout&
lastPageLayout)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderOrCountDynamicPage(Stack&
renderDynamicStack, Int32& currentPageNumber, Int32 stackTop, PageLayout&
lastPageLayout, Action action)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPageCollection(PageCollection
pageCollection, Int32& currentPageNumber, Stack& stack, PageLayout&
lastPageLayout)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateWorkSheets()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateMainSheet()
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderExcelWorkBook(CreateAndRegisterStream
createAndRegisterStream)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessReport(CreateAndRegisterStream
createAndRegisterStream)
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(IRenderingExtension
renderer, CreateReportChunk createChunkCallback, RenderingContext rc,
GetResource getResourceCallback)
-- End of inner exception stack trace --
w3wp!library!e!11/29/2007-10:47:19:: Unhandled exception was caught:
Microsoft.Reporting.WebForms.ReportServerException: An error occurred during
rendering of the report. (rrRenderingError) -->
Microsoft.Reporting.WebForms.ReportServerException: For more information
about this error navigate to the report server on the local server machine,
or enable remote errors
-- End of inner exception stack trace --
at Microsoft.Reporting.WebForms.ServerReport.InternalRender(String
format, String deviceInfo, String& extension, String& mimeType, String&
encoding, String[]& streams, Warning[]& warnings)
at Microsoft.Reporting.WebForms.ServerReport.Render(String format, String
deviceInfo, NameValueCollection additionalParams, String& mimeType, String&
extension)
at
Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String
format, String deviceInfo, NameValueCollection additionalParams, String&
mimeType, String& fileExtension)
at
Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection
urlQuery, HttpResponse response)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext
context)
at
System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously)
w3wp!library!c!11/29/2007-10:47:22:: i INFO: Call to RenderFirst(
'ProblemReports' )
------When you say another field works, do you mean with the same data type?
Try running your query in SQL management studio with the results
outputting to an excel file . What version of excel are you using ?
Cheers
Shai
On Dec 6, 12:56 am, <chrisexen...@.newsgroups.nospam> wrote:
> I have a report contains few tables.
> The report runs without any problem (Url access) and export to other format
> also without any problem.
> Only when I export the same report to Excel, the following error occurs in
> the reportserver log and its throws an error on screen.
> This error only happens if I run the report with certain parameters. If I
> select difference parameters, the report can export to excel successfully.
> I have found out it is down to a table group - the group on expression, it
> is using one of the dataset field which is a bigInt.
> If I pick another field within the same dataset in the 'group on' expression
> with the smae parameters, its works.
> This bigInt field can be any value greater than 0 (usually a 9 characters
> number) and could be a special defined value -1.
> I hope there is enough information for anyone out there to help me....
> Thanks
> ------
> w3wp!reportrendering!e!11/29/2007-10:47:19:: e ERROR: Throwing
> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingExceptio-n:
> An error occurred during rendering of the report., ;
> Info:
> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingExceptio-n:
> An error occurred during rendering of the report. -->
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException: An
> error occurred during rendering of the report. -->
> System.InvalidOperationException: Operation is not valid due to the current
> state of the object.
> at
> Microsoft.ReportingServices.ReportRendering.TableGroupCollection.get_Item(I-nt32
> index)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetRefere-nceInTable(TableHeaderFooterRows
> header, TableHeaderFooterRows footer, TableGroupCollection tableGroups,
> TableRowsCollection detailRows, IntList indexPath, Int32 startIndex)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetRefere-nce(ReportItem
> dataRegion, IntList indexPath, Int32 startIndex)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetRefere-nce(ReportItem
> dataRegion, IntList indexPath, Int32 startIndex)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GetRefere-nce(ReportItem
> dataRegion, IntList indexPath, Int32 startIndex)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.CollectHi-ddenReportItems(IntList
> indexPath, PageReportItems& pageRI)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.PreScanPa-ge(ReportItem
> parentDataRegion, Boolean isPageNeedsEvaluation, PageLayout& pageLayout,
> PageReportItems& pageRIItems, Stack& dynamicLayoutStack, Hashtable&
> rowHeightStateList, OutlineRenderStates[]& verticalOutlineStates,
> OutlineRenderStates[]& horizontalOutlineStates)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderSta-ticPage(ReportItem
> parentDataRegion, PageLayout pageLayout, Hashtable formulaRIMap, Int32
> currentPageNumber, PageReportItems& pageRIItems, Stack& dynamicLayoutStack)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPag-eLayout(PageLayout
> pageLayout, Int32& currentPageNumber, Stack& stack)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPag-eCollection(PageCollection
> pageCollection, Int32& currentPageNumber, Stack& stack, PageLayout&
> lastPageLayout)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderOrC-ountDynamicPage(Stack&
> renderDynamicStack, Int32& currentPageNumber, Int32 stackTop, PageLayout&
> lastPageLayout, Action action)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderPag-eCollection(PageCollection
> pageCollection, Int32& currentPageNumber, Stack& stack, PageLayout&
> lastPageLayout)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateW-orkSheets()
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.GenerateM-ainSheet()
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderExc-elWorkBook(CreateAndRegisterStream
> createAndRegisterStream)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.ProcessRe-port(CreateAndRegisterStream
> createAndRegisterStream)
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Re-port
> report, NameValueCollection reportServerParameters, NameValueCollection
> deviceInfo, NameValueCollection clientCapabilities,
> EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> CreateAndRegisterStream createAndRegisterStream)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.Render(Re-port
> report, NameValueCollection reportServerParameters, NameValueCollection
> deviceInfo, NameValueCollection clientCapabilities,
> EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> CreateAndRegisterStream createAndRegisterStream)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapsho-t(IRenderingExtension
> renderer, CreateReportChunk createChunkCallback, RenderingContext rc,
> GetResource getResourceCallback)
> -- End of inner exception stack trace --
> w3wp!library!e!11/29/2007-10:47:19:: Unhandled exception was caught:
> Microsoft.Reporting.WebForms.ReportServerException: An error occurred during
> rendering of the report. (rrRenderingError) -->
> Microsoft.Reporting.WebForms.ReportServerException: For more information
> about this error navigate to the report server on the local server machine,
> or enable remote errors
> -- End of inner exception stack trace --
> at Microsoft.Reporting.WebForms.ServerReport.InternalRender(String
> format, String deviceInfo, String& extension, String& mimeType, String&
> encoding, String[]& streams, Warning[]& warnings)
> at Microsoft.Reporting.WebForms.ServerReport.Render(String format, String
> deviceInfo, NameValueCollection additionalParams, String& mimeType, String&
> extension)
> at
> Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String
> format, String deviceInfo, NameValueCollection additionalParams, String&
> mimeType, String& fileExtension)
> at
> Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueColl-ection
> urlQuery, HttpResponse response)
> at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext
> context)
> at
> System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplicat-ion.IExecutionStep.Execute()
> at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> completedSynchronously)
> w3wp!library!c!11/29/2007-10:47:22:: i INFO: Call to RenderFirst(
> 'ProblemReports' )
> ------|||Hello Chris,
I would like to know whether you have applied the latest service pack of
SQL Server.
Please apply the service pack and let me know whether this issue resolved.
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.|||Hi Wei and Shai
Thanks you for the replies.....
We do already have the latest service pack on.
Because the reporting services and SQL server are installed on two
serperated servers, I have checked both file versions.
The SQL Server version is :
Product Version is 9.00.3054.00
Product Level is SP2
Edition is Standard Edition (64-bit)
slqservr.exe (64-bit) File version is 2005.90.3054.0 - from HotFixbuild 3159
ReportingServicesService.exe (32-bit) File version is 9.0.3054.0
To answer Shai questions,
Unfotunately the dataset returned by the stored procedure do not have two
column with the same data type (BigInt) that I used for the table grouping.
I only tried another column with data type Int that returned the similar
data.
We have tried to run and export the report on two client machines, one has
Excel 2003 and one has Excel 2007.
And I am trying to figuring it out how to output the results from SQL
management studio to an excel file. :)
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:xPpOT%238NIHA.5204@.TK2MSFTNGHUB02.phx.gbl...
> Hello Chris,
> I would like to know whether you have applied the latest service pack of
> SQL Server.
> Please apply the service pack and let me know whether this issue resolved.
> 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.
>|||<chrisexentra@.newsgroups.nospam> wrote in message
news:JaidnVK4m4PXn8XanZ2dnUVZ8tignZ2d@.pipex.net...
> Hi Wei and Shai
> Thanks you for the replies.....
> We do already have the latest service pack on.
> Because the reporting services and SQL server are installed on two
> serperated servers, I have checked both file versions.
> The SQL Server version is :
> Product Version is 9.00.3054.00
> Product Level is SP2
> Edition is Standard Edition (64-bit)
> slqservr.exe (64-bit) File version is 2005.90.3054.0 - from HotFixbuild
> 3159
> ReportingServicesService.exe (32-bit) File version is 9.0.3054.0
>
> To answer Shai questions,
> Unfotunately the dataset returned by the stored procedure do not have two
> column with the same data type (BigInt) that I used for the table
> grouping.
> I only tried another column with data type Int that returned the similar
> data.
> We have tried to run and export the report on two client machines, one has
> Excel 2003 and one has Excel 2007.
> And I am trying to figuring it out how to output the results from SQL
> management studio to an excel file. :)
>
>
> "Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
> news:xPpOT%238NIHA.5204@.TK2MSFTNGHUB02.phx.gbl...
>> Hello Chris,
>> I would like to know whether you have applied the latest service pack of
>> SQL Server.
>> Please apply the service pack and let me know whether this issue
>> resolved.
>> 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.
>|||Hi,
To export your query results in excel, in management studio, check
this option under query-> results to -> results to file. Then run your
query and itll ask you for a location , specify it as an excel file
and it will create a file if the file does not exist. Run your query ,
also run a dummy query by declaring a bigint variable and doing a
select . If you have updated service packs, then it has to be RS,
SQL , Excel or some rogue data. Try elimination to determine the cause
and then maybe we can look at why the crash happens.
Cheers
Shai
On Dec 6, 11:07 pm, <chrisexen...@.newsgroups.nospam> wrote:
> Hi Wei and Shai
> Thanks you for the replies.....
> We do already have the latest service pack on.
> Because the reporting services and SQL server are installed on two
> serperated servers, I have checked both file versions.
> The SQL Server version is :
> Product Version is 9.00.3054.00
> Product Level is SP2
> Edition is Standard Edition (64-bit)
> slqservr.exe (64-bit) File version is 2005.90.3054.0 - from HotFixbuild 3159
> ReportingServicesService.exe (32-bit) File version is 9.0.3054.0
> To answer Shai questions,
> Unfotunately the dataset returned by the stored procedure do not have two
> column with the same data type (BigInt) that I used for the table grouping.
> I only tried another column with data type Int that returned the similar
> data.
> We have tried to run and export the report on two client machines, one has
> Excel 2003 and one has Excel 2007.
> And I am trying to figuring it out how to output the results from SQL
> management studio to an excel file. :)
> "Wei Lu [MSFT]" <we...@.online.microsoft.com> wrote in messagenews:xPpOT%238NIHA.5204@.TK2MSFTNGHUB02.phx.gbl...
>
> > Hello Chris,
> > I would like to know whether you have applied the latest service pack of
> > SQL Server.
> > Please apply the service pack and let me know whether this issue resolved.
> > 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.- Hide quoted text -
> - Show quoted text -|||Hi Shai,
I have set the results to file in the management studio. But when I execute
the stored procedure,
the save resoults dialog does not have Excel file type for me to select in
the 'save as type'.
It only has 'Report files (*.rpt)' type!
And I think we have all the latest service pack installed for SQL server and
RS.
We have a server running 64-bit sql server 2005, another server running
32-bit 2005 reporting services along with out web application.
On the RS server machine, we do not have Excel installed, or do we needed
to?
I run and export the report on my machine which has Excel 2007 installed.
I am currently run out of options Please, please help !
<shaikat.das@.gmail.com> wrote in message
news:b3eaf170-0e92-4224-b34b-363d92811c7b@.d21g2000prf.googlegroups.com...
> Hi,
> To export your query results in excel, in management studio, check
> this option under query-> results to -> results to file. Then run your
> query and itll ask you for a location , specify it as an excel file
> and it will create a file if the file does not exist. Run your query ,
> also run a dummy query by declaring a bigint variable and doing a
> select . If you have updated service packs, then it has to be RS,
> SQL , Excel or some rogue data. Try elimination to determine the cause
> and then maybe we can look at why the crash happens.
>
> Cheers
> Shai
> On Dec 6, 11:07 pm, <chrisexen...@.newsgroups.nospam> wrote:
>> Hi Wei and Shai
>> Thanks you for the replies.....
>> We do already have the latest service pack on.
>> Because the reporting services and SQL server are installed on two
>> serperated servers, I have checked both file versions.
>> The SQL Server version is :
>> Product Version is 9.00.3054.00
>> Product Level is SP2
>> Edition is Standard Edition (64-bit)
>> slqservr.exe (64-bit) File version is 2005.90.3054.0 - from HotFixbuild
>> 3159
>> ReportingServicesService.exe (32-bit) File version is 9.0.3054.0
>> To answer Shai questions,
>> Unfotunately the dataset returned by the stored procedure do not have two
>> column with the same data type (BigInt) that I used for the table
>> grouping.
>> I only tried another column with data type Int that returned the similar
>> data.
>> We have tried to run and export the report on two client machines, one
>> has
>> Excel 2003 and one has Excel 2007.
>> And I am trying to figuring it out how to output the results from SQL
>> management studio to an excel file. :)
>> "Wei Lu [MSFT]" <we...@.online.microsoft.com> wrote in
>> messagenews:xPpOT%238NIHA.5204@.TK2MSFTNGHUB02.phx.gbl...
>>
>> > Hello Chris,
>> > I would like to know whether you have applied the latest service pack
>> > of
>> > SQL Server.
>> > Please apply the service pack and let me know whether this issue
>> > resolved.
>> > 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.- Hide quoted text -
>> - Show quoted text -
>|||Hello,
Have you tried to export the result to csv and open it in Excel?
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.|||Hi Wei,
I have tried to export to csv and open it in Excel without any problem.
From what I found so far, it may be something to do with the grouping on the
table.
Please find three dataset csv files named :
FailedDataSet1.csv - with Paul1 and Brent1 and Malcolm1 data
FailedDataSet2.csv - with Paul1 and Brent1 data
SuccessDataSet.csv - with Brent1 and Malcolm1 data
These datasets contain three people's working data.
The rdl report has a list with 'details group' of the YEAR, WEEK_NO, ENUM
and NAME fields which gives the dataset saved above.
These ensure each report page has only one person per week of each year.
Within the list, there is a table. This table display all the data from the
dataset.
This table is group on the WorkingPeriodID field. (group on the WorkingDate
will not be correct)
Take the SuccessDataSet file as an example, the table will be something
likes:
(Page 1)
Working Date Name WorkingPeriodID
CNum ENum
19 / 11 Brent1 121897285
13150434 100992
20 / 11 Brent1 121897286
13035532 100992
21 / 11 Brent1 121897287
13035533 100992
Brent1 121897288
13150433 100992
<-- The table group should apply here which group on the WorkingPeriodId
field, and gives a total of the CNum -->
22 / 11 Brent1 121897289
13035534 100992
23 / 11 Brent1 121897290
13035535 100992
24 / 11 Brent1 121897291
1 100992
25 / 11 Brent1 121897292
1 100992
(Page 2)
Working Date Name WorkingPeriodID
CNum ENum
19 / 11 Malcolm1 121498129
13150283 100993
20 / 11 Malcolm1 121498130
13150282 100993
21 / 11 Malcolm1 121498131
13150281 100993
22 / 11 Malcolm1 121498132
13150280 100993
23 / 11 Malcolm1 121498133
13150279 100993
24 / 11 Malcolm1 121498134
1 100993
25 / 11 Malcolm1 121498135
1 100993
In normal situration, the workingPeriodId should be the same on each
workingdate.
This will gives a table row with of the total of the CNum field.
But in the above dataset, on 21 / 11, Brent1 have two rows with the
difference WorkingPeriodID.
Therefore the table group does not shows the total of the CNum row. (which
is corrected.)
Everything is fine with all three datasets, report can be rendered correctly
with RS and export to pdf correctly.
But if I try to export the FailedSataSet1 and DailedDataSet2 data to Excel,
Its gives the reporting Services error.
Only the data from the SuccessDataSet can be export to Excel successfully.
If I changed the WorkingPeriodId in the dataset to be the same on the 21 /
11 for Brent1. Everything works...
I hope these information will help and Thank you for taking time to help.
(if possible)
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:BPFLmUvOIHA.360@.TK2MSFTNGHUB02.phx.gbl...
> Hello,
> Have you tried to export the result to csv and open it in Excel?
>
> 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.
>
begin 666 SuccessDataSet.csv
M5P!%`$4`2P!?`$X`3P`L`%D`10!!`%(`+ !7`$\`4@.!+`$D`3@.!'`% `10!2
M`$D`3P!$`$D`1 `L`%<`3P!2`$L`20!.`$<`1 !!`%0`10`L`$,`3@.!5`$T`
M+ !%`$X`50!-`"P`3@.!!`$T`10`-``H`- `W`"P`,@.`P`# `-P`L`#$`,@.`Q
M`#@.`.0`W`#(`. `U`"P`,@.`P`# `-P`M`#$`,0`M`#$`.0`@.`# `, `Z`# `
M, `Z`# `, `N`# `, `P`"P`,0`S`#$`-0`P`#0`,P`T`"P`,0`P`# `.0`Y
M`#(`+ !"`'(`90!N`'0`,0`-``H`- `W`"P`,@.`P`# `-P`L`#$`,@.`Q`#@.`
M.0`W`#(`. `V`"P`,@.`P`# `-P`M`#$`,0`M`#(`, `@.`# `, `Z`# `, `Z
M`# `, `N`# `, `P`"P`,0`S`# `,P`U`#4`,P`R`"P`,0`P`# `.0`Y`#(`
M+ !"`'(`90!N`'0`,0`-``H`- `W`"P`,@.`P`# `-P`L`#$`,@.`Q`#@.`.0`W
M`#(`. `W`"P`,@.`P`# `-P`M`#$`,0`M`#(`,0`@.`# `, `Z`# `, `Z`# `
M, `N`# `, `P`"P`,0`S`# `,P`U`#4`,P`S`"P`,0`P`# `.0`Y`#(`+ !"
M`'(`90!N`'0`,0`-``H`- `W`"P`,@.`P`# `-P`L`#$`,@.`Q`#@.`.0`W`#(`
M. `X`"P`,@.`P`# `-P`M`#$`,0`M`#(`,0`@.`# `, `Z`# `, `Z`# `, `N
M`# `, `P`"P`,0`S`#$`-0`P`#0`,P`S`"P`,0`P`# `.0`Y`#(`+ !"`'(`
M90!N`'0`,0`-``H`- `W`"P`,@.`P`# `-P`L`#$`,@.`Q`#@.`.0`W`#(`. `Y
M`"P`,@.`P`# `-P`M`#$`,0`M`#(`,@.`@.`# `, `Z`# `, `Z`# `, `N`# `
M, `P`"P`,0`S`# `,P`U`#4`,P`T`"P`,0`P`# `.0`Y`#(`+ !"`'(`90!N
M`'0`,0`-``H`- `W`"P`,@.`P`# `-P`L`#$`,@.`Q`#@.`.0`W`#(`.0`P`"P`
M,@.`P`# `-P`M`#$`,0`M`#(`,P`@.`# `, `Z`# `, `Z`# `, `N`# `, `P
M`"P`,0`S`# `,P`U`#4`,P`U`"P`,0`P`# `.0`Y`#(`+ !"`'(`90!N`'0`
M,0`-``H`- `W`"P`,@.`P`# `-P`L`#$`,@.`Q`#@.`.0`W`#(`.0`Q`"P`,@.`P
M`# `-P`M`#$`,0`M`#(`- `@.`# `, `Z`# `, `Z`# `, `N`# `, `P`"P`
M,0`L`#$`, `P`#D`.0`R`"P`0@.!R`&4`;@.!T`#$`#0`*`#0`-P`L`#(`, `P
M`#<`+ `Q`#(`,0`X`#D`-P`R`#D`,@.`L`#(`, `P`#<`+0`Q`#$`+0`R`#4`
M( `P`# `.@.`P`# `.@.`P`# `+@.`P`# `, `L`#$`+ `Q`# `, `Y`#D`,@.`L
M`$(`<@.!E`&X`= `Q``T`"@.`T`#<`+ `R`# `, `W`"P`,0`R`#$`- `Y`#@.`
M,0`R`#D`+ `R`# `, `W`"T`,0`Q`"T`,0`Y`" `, `P`#H`, `P`#H`, `P
M`"X`, `P`# `+ `Q`#,`,0`U`# `,@.`X`#,`+ `Q`# `, `Y`#D`,P`L`$T`
M80!L`&,`;P!L`&T`,0`-``H`- `W`"P`,@.`P`# `-P`L`#$`,@.`Q`#0`.0`X
M`#$`,P`P`"P`,@.`P`# `-P`M`#$`,0`M`#(`, `@.`# `, `Z`# `, `Z`# `
M, `N`# `, `P`"P`,0`S`#$`-0`P`#(`. `R`"P`,0`P`# `.0`Y`#,`+ !-
M`&$`; !C`&\`; !M`#$`#0`*`#0`-P`L`#(`, `P`#<`+ `Q`#(`,0`T`#D`
M. `Q`#,`,0`L`#(`, `P`#<`+0`Q`#$`+0`R`#$`( `P`# `.@.`P`# `.@.`P
M`# `+@.`P`# `, `L`#$`,P`Q`#4`, `R`#@.`,0`L`#$`, `P`#D`.0`S`"P`
M30!A`&P`8P!O`&P`;0`Q``T`"@.`T`#<`+ `R`# `, `W`"P`,0`R`#$`- `Y
M`#@.`,0`S`#(`+ `R`# `, `W`"T`,0`Q`"T`,@.`R`" `, `P`#H`, `P`#H`
M, `P`"X`, `P`# `+ `Q`#,`,0`U`# `,@.`X`# `+ `Q`# `, `Y`#D`,P`L
M`$T`80!L`&,`;P!L`&T`,0`-``H`- `W`"P`,@.`P`# `-P`L`#$`,@.`Q`#0`
M.0`X`#$`,P`S`"P`,@.`P`# `-P`M`#$`,0`M`#(`,P`@.`# `, `Z`# `, `Z
M`# `, `N`# `, `P`"P`,0`S`#$`-0`P`#(`-P`Y`"P`,0`P`# `.0`Y`#,`
M+ !-`&$`; !C`&\`; !M`#$`#0`*`#0`-P`L`#(`, `P`#<`+ `Q`#(`,0`T
M`#D`. `Q`#,`- `L`#(`, `P`#<`+0`Q`#$`+0`R`#0`( `P`# `.@.`P`# `
M.@.`P`# `+@.`P`# `, `L`#$`+ `Q`# `, `Y`#D`,P`L`$T`80!L`&,`;P!L
M`&T`,0`-``H`- `W`"P`,@.`P`# `-P`L`#$`,@.`Q`#0`.0`X`#$`,P`U`"P`
M,@.`P`# `-P`M`#$`,0`M`#(`-0`@.`# `, `Z`# `, `Z`# `, `N`# `, `P
I`"P`,0`L`#$`, `P`#D`.0`S`"P`30!A`&P`8P!O`&P`;0`Q``T`"@.``
`
end
begin 666 FailedDataSet1.csv
M5P!%`$4`2P!?`$X`3P`L`%D`10!!`%(`+ !7`$\`4@.!+`$D`3@.!'`% `10!2
M`$D`3P!$`$D`1 `L`%<`3P!2`$L`20!.`$<`1 !!`%0`10`L`$,`3@.!5`$T`
M+ !%`$X`50!-`"P`3@.!!`$T`10`-``H`- `W`"P`,@.`P`# `-P`L`#$`,@.`Q
M`#0`.0`X`#$`, `Q`"P`,@.`P`# `-P`M`#$`,0`M`#$`.0`@.`# `, `Z`# `
M, `Z`# `, `N`# `, `P`"P`,0`S`#$`-0`P`#0`,P`U`"P`,0`P`# `.0`Y
M`#$`+ !0`&$`=0!L`#$`#0`*`#0`-P`L`#(`, `P`#<`+ `Q`#(`,0`T`#D`
M. `Q`# `,@.`L`#(`, `P`#<`+0`Q`#$`+0`R`# `( `P`# `.@.`P`# `.@.`P
M`# `+@.`P`# `, `L`#$`,P`Q`#4`, `T`#,`-@.`L`#$`, `P`#D`.0`Q`"P`
M4 !A`'4`; `Q``T`"@.`T`#<`+ `R`# `, `W`"P`,0`R`#$`- `Y`#@.`,0`P
M`#,`+ `R`# `, `W`"T`,0`Q`"T`,@.`Q`" `, `P`#H`, `P`#H`, `P`"X`
M, `P`# `+ `Q`#,`,0`U`# `- `S`#<`+ `Q`# `, `Y`#D`,0`L`% `80!U
M`&P`,0`-``H`- `W`"P`,@.`P`# `-P`L`#$`,@.`Q`#0`.0`X`#$`, `T`"P`
M,@.`P`# `-P`M`#$`,0`M`#(`,@.`@.`# `, `Z`# `, `Z`# `, `N`# `, `P
M`"P`,0`S`#$`-0`P`#0`,P`X`"P`,0`P`# `.0`Y`#$`+ !0`&$`=0!L`#$`
M#0`*`#0`-P`L`#(`, `P`#<`+ `Q`#(`,0`T`#D`. `Q`# `-0`L`#(`, `P
M`#<`+0`Q`#$`+0`R`#,`( `P`# `.@.`P`# `.@.`P`# `+@.`P`# `, `L`#$`
M,P`Q`#4`, `T`#,`.0`L`#$`, `P`#D`.0`Q`"P`4 !A`'4`; `Q``T`"@.`T
M`#<`+ `R`# `, `W`"P`,0`R`#$`- `Y`#@.`,0`P`#8`+ `R`# `, `W`"T`
M,0`Q`"T`,@.`T`" `, `P`#H`, `P`#H`, `P`"X`, `P`# `+ `Q`"P`,0`P
M`# `.0`Y`#$`+ !0`&$`=0!L`#$`#0`*`#0`-P`L`#(`, `P`#<`+ `Q`#(`
M,0`T`#D`. `Q`# `-P`L`#(`, `P`#<`+0`Q`#$`+0`R`#4`( `P`# `.@.`P
M`# `.@.`P`# `+@.`P`# `, `L`#$`+ `Q`# `, `Y`#D`,0`L`% `80!U`&P`
M,0`-``H`- `W`"P`,@.`P`# `-P`L`#$`,@.`Q`#@.`.0`W`#(`. `U`"P`,@.`P
M`# `-P`M`#$`,0`M`#$`.0`@.`# `, `Z`# `, `Z`# `, `N`# `, `P`"P`
M,0`S`#$`-0`P`#0`,P`T`"P`,0`P`# `.0`Y`#(`+ !"`'(`90!N`'0`,0`-
M``H`- `W`"P`,@.`P`# `-P`L`#$`,@.`Q`#@.`.0`W`#(`. `V`"P`,@.`P`# `
M-P`M`#$`,0`M`#(`, `@.`# `, `Z`# `, `Z`# `, `N`# `, `P`"P`,0`S
M`# `,P`U`#4`,P`R`"P`,0`P`# `.0`Y`#(`+ !"`'(`90!N`'0`,0`-``H`
M- `W`"P`,@.`P`# `-P`L`#$`,@.`Q`#@.`.0`W`#(`. `W`"P`,@.`P`# `-P`M
M`#$`,0`M`#(`,0`@.`# `, `Z`# `, `Z`# `, `N`# `, `P`"P`,0`S`# `
M,P`U`#4`,P`S`"P`,0`P`# `.0`Y`#(`+ !"`'(`90!N`'0`,0`-``H`- `W
M`"P`,@.`P`# `-P`L`#$`,@.`Q`#@.`.0`W`#(`. `X`"P`,@.`P`# `-P`M`#$`
M,0`M`#(`,0`@.`# `, `Z`# `, `Z`# `, `N`# `, `P`"P`,0`S`#$`-0`P
M`#0`,P`S`"P`,0`P`# `.0`Y`#(`+ !"`'(`90!N`'0`,0`-``H`- `W`"P`
M,@.`P`# `-P`L`#$`,@.`Q`#@.`.0`W`#(`. `Y`"P`,@.`P`# `-P`M`#$`,0`M
M`#(`,@.`@.`# `, `Z`# `, `Z`# `, `N`# `, `P`"P`,0`S`# `,P`U`#4`
M,P`T`"P`,0`P`# `.0`Y`#(`+ !"`'(`90!N`'0`,0`-``H`- `W`"P`,@.`P
M`# `-P`L`#$`,@.`Q`#@.`.0`W`#(`.0`P`"P`,@.`P`# `-P`M`#$`,0`M`#(`
M,P`@.`# `, `Z`# `, `Z`# `, `N`# `, `P`"P`,0`S`# `,P`U`#4`,P`U
M`"P`,0`P`# `.0`Y`#(`+ !"`'(`90!N`'0`,0`-``H`- `W`"P`,@.`P`# `
M-P`L`#$`,@.`Q`#@.`.0`W`#(`.0`Q`"P`,@.`P`# `-P`M`#$`,0`M`#(`- `@.
M`# `, `Z`# `, `Z`# `, `N`# `, `P`"P`,0`L`#$`, `P`#D`.0`R`"P`
M0@.!R`&4`;@.!T`#$`#0`*`#0`-P`L`#(`, `P`#<`+ `Q`#(`,0`X`#D`-P`R
M`#D`,@.`L`#(`, `P`#<`+0`Q`#$`+0`R`#4`( `P`# `.@.`P`# `.@.`P`# `
M+@.`P`# `, `L`#$`+ `Q`# `, `Y`#D`,@.`L`$(`<@.!E`&X`= `Q``T`"@.`T
M`#<`+ `R`# `, `W`"P`,0`R`#$`- `Y`#@.`,0`R`#D`+ `R`# `, `W`"T`
M,0`Q`"T`,0`Y`" `, `P`#H`, `P`#H`, `P`"X`, `P`# `+ `Q`#,`,0`U
M`# `,@.`X`#,`+ `Q`# `, `Y`#D`,P`L`$T`80!L`&,`;P!L`&T`,0`-``H`
M- `W`"P`,@.`P`# `-P`L`#$`,@.`Q`#0`.0`X`#$`,P`P`"P`,@.`P`# `-P`M
M`#$`,0`M`#(`, `@.`# `, `Z`# `, `Z`# `, `N`# `, `P`"P`,0`S`#$`
M-0`P`#(`. `R`"P`,0`P`# `.0`Y`#,`+ !-`&$`; !C`&\`; !M`#$`#0`*
M`#0`-P`L`#(`, `P`#<`+ `Q`#(`,0`T`#D`. `Q`#,`,0`L`#(`, `P`#<`
M+0`Q`#$`+0`R`#$`( `P`# `.@.`P`# `.@.`P`# `+@.`P`# `, `L`#$`,P`Q
M`#4`, `R`#@.`,0`L`#$`, `P`#D`.0`S`"P`30!A`&P`8P!O`&P`;0`Q``T`
M"@.`T`#<`+ `R`# `, `W`"P`,0`R`#$`- `Y`#@.`,0`S`#(`+ `R`# `, `W
M`"T`,0`Q`"T`,@.`R`" `, `P`#H`, `P`#H`, `P`"X`, `P`# `+ `Q`#,`
M,0`U`# `,@.`X`# `+ `Q`# `, `Y`#D`,P`L`$T`80!L`&,`;P!L`&T`,0`-
M``H`- `W`"P`,@.`P`# `-P`L`#$`,@.`Q`#0`.0`X`#$`,P`S`"P`,@.`P`# `
M-P`M`#$`,0`M`#(`,P`@.`# `, `Z`# `, `Z`# `, `N`# `, `P`"P`,0`S
M`#$`-0`P`#(`-P`Y`"P`,0`P`# `.0`Y`#,`+ !-`&$`; !C`&\`; !M`#$`
M#0`*`#0`-P`L`#(`, `P`#<`+ `Q`#(`,0`T`#D`. `Q`#,`- `L`#(`, `P
M`#<`+0`Q`#$`+0`R`#0`( `P`# `.@.`P`# `.@.`P`# `+@.`P`# `, `L`#$`
M+ `Q`# `, `Y`#D`,P`L`$T`80!L`&,`;P!L`&T`,0`-``H`- `W`"P`,@.`P
M`# `-P`L`#$`,@.`Q`#0`.0`X`#$`,P`U`"P`,@.`P`# `-P`M`#$`,0`M`#(`
M-0`@.`# `, `Z`# `, `Z`# `, `N`# `, `P`"P`,0`L`#$`, `P`#D`.0`S
7`"P`30!A`&P`8P!O`&P`;0`Q``T`"@.``
`
end
begin 666 FailedDataSet2.csv
M5P!%`$4`2P!?`$X`3P`L`%D`10!!`%(`+ !7`$\`4@.!+`$D`3@.!'`% `10!2
M`$D`3P!$`$D`1 `L`%<`3P!2`$L`20!.`$<`1 !!`%0`10`L`$,`3@.!5`$T`
M+ !%`$X`50!-`"P`3@.!!`$T`10`-``H`- `W`"P`,@.`P`# `-P`L`#$`,@.`Q
M`#0`.0`X`#$`, `Q`"P`,@.`P`# `-P`M`#$`,0`M`#$`.0`@.`# `, `Z`# `
M, `Z`# `, `N`# `, `P`"P`,0`S`#$`-0`P`#0`,P`U`"P`,0`P`# `.0`Y
M`#$`+ !0`&$`=0!L`#$`#0`*`#0`-P`L`#(`, `P`#<`+ `Q`#(`,0`T`#D`
M. `Q`# `,@.`L`#(`, `P`#<`+0`Q`#$`+0`R`# `( `P`# `.@.`P`# `.@.`P
M`# `+@.`P`# `, `L`#$`,P`Q`#4`, `T`#,`-@.`L`#$`, `P`#D`.0`Q`"P`
M4 !A`'4`; `Q``T`"@.`T`#<`+ `R`# `, `W`"P`,0`R`#$`- `Y`#@.`,0`P
M`#,`+ `R`# `, `W`"T`,0`Q`"T`,@.`Q`" `, `P`#H`, `P`#H`, `P`"X`
M, `P`# `+ `Q`#,`,0`U`# `- `S`#<`+ `Q`# `, `Y`#D`,0`L`% `80!U
M`&P`,0`-``H`- `W`"P`,@.`P`# `-P`L`#$`,@.`Q`#0`.0`X`#$`, `T`"P`
M,@.`P`# `-P`M`#$`,0`M`#(`,@.`@.`# `, `Z`# `, `Z`# `, `N`# `, `P
M`"P`,0`S`#$`-0`P`#0`,P`X`"P`,0`P`# `.0`Y`#$`+ !0`&$`=0!L`#$`
M#0`*`#0`-P`L`#(`, `P`#<`+ `Q`#(`,0`T`#D`. `Q`# `-0`L`#(`, `P
M`#<`+0`Q`#$`+0`R`#,`( `P`# `.@.`P`# `.@.`P`# `+@.`P`# `, `L`#$`
M,P`Q`#4`, `T`#,`.0`L`#$`, `P`#D`.0`Q`"P`4 !A`'4`; `Q``T`"@.`T
M`#<`+ `R`# `, `W`"P`,0`R`#$`- `Y`#@.`,0`P`#8`+ `R`# `, `W`"T`
M,0`Q`"T`,@.`T`" `, `P`#H`, `P`#H`, `P`"X`, `P`# `+ `Q`"P`,0`P
M`# `.0`Y`#$`+ !0`&$`=0!L`#$`#0`*`#0`-P`L`#(`, `P`#<`+ `Q`#(`
M,0`T`#D`. `Q`# `-P`L`#(`, `P`#<`+0`Q`#$`+0`R`#4`( `P`# `.@.`P
M`# `.@.`P`# `+@.`P`# `, `L`#$`+ `Q`# `, `Y`#D`,0`L`% `80!U`&P`
M,0`-``H`- `W`"P`,@.`P`# `-P`L`#$`,@.`Q`#@.`.0`W`#(`. `U`"P`,@.`P
M`# `-P`M`#$`,0`M`#$`.0`@.`# `, `Z`# `, `Z`# `, `N`# `, `P`"P`
M,0`S`#$`-0`P`#0`,P`T`"P`,0`P`# `.0`Y`#(`+ !"`'(`90!N`'0`,0`-
M``H`- `W`"P`,@.`P`# `-P`L`#$`,@.`Q`#@.`.0`W`#(`. `V`"P`,@.`P`# `
M-P`M`#$`,0`M`#(`, `@.`# `, `Z`# `, `Z`# `, `N`# `, `P`"P`,0`S
M`# `,P`U`#4`,P`R`"P`,0`P`# `.0`Y`#(`+ !"`'(`90!N`'0`,0`-``H`
M- `W`"P`,@.`P`# `-P`L`#$`,@.`Q`#@.`.0`W`#(`. `W`"P`,@.`P`# `-P`M
M`#$`,0`M`#(`,0`@.`# `, `Z`# `, `Z`# `, `N`# `, `P`"P`,0`S`# `
M,P`U`#4`,P`S`"P`,0`P`# `.0`Y`#(`+ !"`'(`90!N`'0`,0`-``H`- `W
M`"P`,@.`P`# `-P`L`#$`,@.`Q`#@.`.0`W`#(`. `X`"P`,@.`P`# `-P`M`#$`
M,0`M`#(`,0`@.`# `, `Z`# `, `Z`# `, `N`# `, `P`"P`,0`S`#$`-0`P
M`#0`,P`S`"P`,0`P`# `.0`Y`#(`+ !"`'(`90!N`'0`,0`-``H`- `W`"P`
M,@.`P`# `-P`L`#$`,@.`Q`#@.`.0`W`#(`. `Y`"P`,@.`P`# `-P`M`#$`,0`M
M`#(`,@.`@.`# `, `Z`# `, `Z`# `, `N`# `, `P`"P`,0`S`# `,P`U`#4`
M,P`T`"P`,0`P`# `.0`Y`#(`+ !"`'(`90!N`'0`,0`-``H`- `W`"P`,@.`P
M`# `-P`L`#$`,@.`Q`#@.`.0`W`#(`.0`P`"P`,@.`P`# `-P`M`#$`,0`M`#(`
M,P`@.`# `, `Z`# `, `Z`# `, `N`# `, `P`"P`,0`S`# `,P`U`#4`,P`U
M`"P`,0`P`# `.0`Y`#(`+ !"`'(`90!N`'0`,0`-``H`- `W`"P`,@.`P`# `
M-P`L`#$`,@.`Q`#@.`.0`W`#(`.0`Q`"P`,@.`P`# `-P`M`#$`,0`M`#(`- `@.
M`# `, `Z`# `, `Z`# `, `N`# `, `P`"P`,0`L`#$`, `P`#D`.0`R`"P`
M0@.!R`&4`;@.!T`#$`#0`*`#0`-P`L`#(`, `P`#<`+ `Q`#(`,0`X`#D`-P`R
M`#D`,@.`L`#(`, `P`#<`+0`Q`#$`+0`R`#4`( `P`# `.@.`P`# `.@.`P`# `
L+@.`P`# `, `L`#$`+ `Q`# `, `Y`#D`,@.`L`$(`<@.!E`&X`= `Q``T`"@.``
`
end|||Chris,
In the dialog box that opens , select "Allfiles", then type in the
file name with the extension , viz. Test.xls and that will create the
file for you.
Cheers
Shai
On Dec 10, 5:23 pm, we...@.online.microsoft.com (Wei Lu [MSFT]) wrote:
> Hello,
> Have you tried to export the result to csv and open it in Excel?
> 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.|||Hello,
I would like to get the report definition so that I can go for further
assistance.
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.|||Hi Shai,
Thanks for the input and it works. I can export the dataset to Excel without
any problem.
Please have a look at my reply to Wei eariler with more information.
Thank you again for the help...
<shaikat.das@.gmail.com> wrote in message
news:c31b3356-cc38-4f95-905f-c7c2ede4e7ff@.t1g2000pra.googlegroups.com...
> Chris,
> In the dialog box that opens , select "Allfiles", then type in the
> file name with the extension , viz. Test.xls and that will create the
> file for you.
>
> Cheers
> Shai
> On Dec 10, 5:23 pm, we...@.online.microsoft.com (Wei Lu [MSFT]) wrote:
>> Hello,
>> Have you tried to export the result to csv and open it in Excel?
>> 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.
>|||Hi
So its not Excel and its not SQL . Oook, now lets consider the
report , I suspect that the grouping on the big int field is causing
excel to crash. Depends on how many unique big ints you have in your
data set , but the next thing I would do is to try and isolate if any
one of the big int values is causing the crash. The easiest way to do
this would be to limit the big int in your data set to one of each
unique value and exporting the report to excel. But if you have a very
high number of big ints then it can be a long process. Whatever the
data , excel should not crash . Having said that , if the grouping is
too complicated, I would also suggest trying sub reports to simplify
the process.
Cheers
Shai|||Hi Wei,
This is just a test to see whether I am able to reply to this post.
I have tried to reply your post for number of time without any success.
I was thinking may be the attached files caused it so this reply is just a
test.
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:9oAE027OIHA.5204@.TK2MSFTNGHUB02.phx.gbl...
> Hello,
> I would like to get the report definition so that I can go for further
> assistance.
> 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.
>|||Hello Chris,
I could see your post, but I could not see other posts.
You may send the rdl file to me directly. To get me email address, please
remove the ONLINE in my display email address.
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 fails - ASPNET_WP.EXE consumes 60% RAM

I'm trying to export a report to Excel that contains 60,000 rows (but not
more than Excels 65,000 limit) and I get an "internal server error".
When I check the event log on the server it states that aspnet_wp.exe
terminated the report process because it had consumed more than 60% of the
servers availible RAM (1Gb total).
PDF and CSV work fine. Does anyone know anything about this'
--
Cheers
NickExporting to Excel is quite intensive on resources. The problem is that MS
is trying for very high fidelity on what the data looks like. For instance
if you have drill down it creates a spreadsheet with drilldown. For that
amount of data I suggest that you use CSV in ASCII format (the default is
Unicode). Excel doesn't recognize Unicode CSV and puts it all in one column.
With ASCII format Excel properly puts them in the correct columns. Another
tip, for your table in the report, click on each field of the detail and
make sure it has the name that you want on Export. The CSV export uses this
name. To get CSV in ASCII you need to use a jump to URL and include ASCII in
the deviceinfo (or something like that, doing this from memory from home).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Nick Prudhoe" <NickPrudhoe@.discussions.microsoft.com> wrote in message
news:3F7F032F-9416-462B-89BC-F6C90E64FA5A@.microsoft.com...
> I'm trying to export a report to Excel that contains 60,000 rows (but not
> more than Excels 65,000 limit) and I get an "internal server error".
> When I check the event log on the server it states that aspnet_wp.exe
> terminated the report process because it had consumed more than 60% of the
> servers availible RAM (1Gb total).
> PDF and CSV work fine. Does anyone know anything about this'
> --
> Cheers
> Nick|||Thanks. I have already managed to get the same report to export to CSV. I'm
trying to prove reporting services out before my company goes down that
track. The performance on exports to Excel is disapointing, i would have
hoped it was better than PDF as it's an MS technology.
--
Cheers
Nick
"Bruce L-C [MVP]" wrote:
> Exporting to Excel is quite intensive on resources. The problem is that MS
> is trying for very high fidelity on what the data looks like. For instance
> if you have drill down it creates a spreadsheet with drilldown. For that
> amount of data I suggest that you use CSV in ASCII format (the default is
> Unicode). Excel doesn't recognize Unicode CSV and puts it all in one column.
> With ASCII format Excel properly puts them in the correct columns. Another
> tip, for your table in the report, click on each field of the detail and
> make sure it has the name that you want on Export. The CSV export uses this
> name. To get CSV in ASCII you need to use a jump to URL and include ASCII in
> the deviceinfo (or something like that, doing this from memory from home).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Nick Prudhoe" <NickPrudhoe@.discussions.microsoft.com> wrote in message
> news:3F7F032F-9416-462B-89BC-F6C90E64FA5A@.microsoft.com...
> > I'm trying to export a report to Excel that contains 60,000 rows (but not
> > more than Excels 65,000 limit) and I get an "internal server error".
> >
> > When I check the event log on the server it states that aspnet_wp.exe
> > terminated the report process because it had consumed more than 60% of the
> > servers availible RAM (1Gb total).
> >
> > PDF and CSV work fine. Does anyone know anything about this'
> > --
> > Cheers
> > Nick
>
>|||Yeah...one would think...although I have seen a significant performance
improvement in service pack 2.
Nick Prudhoe wrote:
> Thanks. I have already managed to get the same report to export to CSV. I'm
> trying to prove reporting services out before my company goes down that
> track. The performance on exports to Excel is disapointing, i would have
> hoped it was better than PDF as it's an MS technology.
>

Export to Excel - "Convert from Number to text" to Number

Hi all,

I was trying to export a report which contains a number format. When I do that, all the numbers will have a green small tag beside it saying "Convert from Number to Text". Which in turn restricts the user, to allow any calculations on the cells. Is there anyway that I can change the format to number when I export it to excel so that I can allow users to do any calculations after they export it to excel?

The details for the above problem are below:

I am using Sql Server 2000 SP4, Reporting services. and I am giving an example below, in case if my problem description is not clear.

Say I have a report which has three columns called Name, Sales, Cost, whose data types are set to - Default, N0, C(Currency). When I export this report to Excel, I get the green tag beside both the Sales and Cost column cells. when I hover over the "!" which comes beside the selected cell , it has a note saying "The number in this cell is formatted as text or preceeded by an apostrophe.". The first line when I click on ^ button shows "Convert from Number to Text."

Any help on this problem is greatly appreciated,

Thanks,

-Shireesha

I have the exact same issue and it's quite problematic (for me as well as others, I assume) since the whole value of being able to export to Excel is that users will be able to play with the data. If the data is formatted as text, then the user can't perform calculations or create charts based on the data. I'm new to Reporting Services and Visual Web Developer and I don't know how to approach this problem. Is there anyone who has ideas on how to designate the format of the cells when exporting to Excel?

To see the result of the problem, create a report on this page: http://epdc.org/GuidedSearch.aspx, and export it to Excel. Witness the angry green corners.

Export to Excel - "Convert from Number to text" to Number

Hi all,

I was trying to export a report which contains a number format. When I do that, all the numbers will have a green small tag beside it saying "Convert from Number to Text". Which in turn restricts the user, to allow any calculations on the cells. Is there anyway that I can change the format to number when I export it to excel so that I can allow users to do any calculations after they export it to excel?

The details for the above problem are below:

I am using Sql Server 2000 SP4, Reporting services. and I am giving an example below, in case if my problem description is not clear.

Say I have a report which has three columns called Name, Sales, Cost, whose data types are set to - Default, N0, C(Currency). When I export this report to Excel, I get the green tag beside both the Sales and Cost column cells. when I hover over the "!" which comes beside the selected cell , it has a note saying "The number in this cell is formatted as text or preceeded by an apostrophe.". The first line when I click on ^ button shows "Convert from Number to Text."

Any help on this problem is greatly appreciated,

Thanks,

-Shireesha

I have the exact same issue and it's quite problematic (for me as well as others, I assume) since the whole value of being able to export to Excel is that users will be able to play with the data. If the data is formatted as text, then the user can't perform calculations or create charts based on the data. I'm new to Reporting Services and Visual Web Developer and I don't know how to approach this problem. Is there anyone who has ideas on how to designate the format of the cells when exporting to Excel?

To see the result of the problem, create a report on this page: http://epdc.org/GuidedSearch.aspx, and export it to Excel. Witness the angry green corners.

Export table containing BIT data

I'm trying to export a table that contains a bit field into a text file to be used for a bulk insert into another database.

when i export the data from SQL enterprise manager, the bit field is exported as the text TRUE or FALSE ?!!!

this data then cant be bulk inserted as its not a BIT anymore.

how can bit fields be properly exported as 1 or 0 ?Are you doing this in a DTS Package? Use CAST or CONVERT on the BIT field and change the output to an INTEGER or CHAR(1). They are basically the same thing but in this scenario either or is fine; since BIT transformation are not explicit and generally require no intervention to get the value of 1 or 0, however if I'm not mistaken, using a Text ODBC driver causes BITs to be converted to TRUE/FALSE. That's why I asked if you are using DTS, it's ODBC driven. If you are using DTS, you will need to write a query in the Source tab using one of the functions below.

Using CAST

CAST(bYourBit AS INTEGER) AS bYourBit

Using CONVERT

CONVERT(CHAR(1),bYourBit) AS bYourBit