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.