Is it possible Reporting data to MS Access.
As such it is possible to export data from Report Manager to MS Excel,
PDF, HTML etc. Now I have a situation in my project to export data from
Report Manager to MS Access. Is this possible programmatically or in
any manner?The best would be to export it as CSV. Access can handle that. But, no,
there is no direct support for Access.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<kishore.lakkimsetty@.wipro.com> wrote in message
news:1139381808.546186.62460@.f14g2000cwb.googlegroups.com...
> Is it possible Reporting data to MS Access.
> As such it is possible to export data from Report Manager to MS Excel,
> PDF, HTML etc. Now I have a situation in my project to export data from
> Report Manager to MS Access. Is this possible programmatically or in
> any manner?
>
Showing posts with label access. Show all posts
Showing posts with label access. Show all posts
Thursday, March 29, 2012
Exporting Primary Keys Into Access
Hi There
I have an SQL database which I need to export into Access, I know how to this however the Primary Key's does not transfer over and more importantly once exported I cannot set the primary key to auto number as their is already information in the table.
I know I can just set up the table, with a primary key set to an autonumber and import the other fields but as the primary key's are foreign keys in other tables I need the rows in the access table to have the same ID number as in the SQL database.
Hope the above makes sense to someone and any help would be greatly appreciated.you should be able to import key values into an access autonumber column with no problem
i've tested it sucessfully, and it works
what error did you get?|||Thanks for the feedback, it works fine now. I was advised wrongly elsewhere that it couldn't be done.
Very simple in the end!|||you gotta be careful with stuff you find on the internet, eh
I have an SQL database which I need to export into Access, I know how to this however the Primary Key's does not transfer over and more importantly once exported I cannot set the primary key to auto number as their is already information in the table.
I know I can just set up the table, with a primary key set to an autonumber and import the other fields but as the primary key's are foreign keys in other tables I need the rows in the access table to have the same ID number as in the SQL database.
Hope the above makes sense to someone and any help would be greatly appreciated.you should be able to import key values into an access autonumber column with no problem
i've tested it sucessfully, and it works
what error did you get?|||Thanks for the feedback, it works fine now. I was advised wrongly elsewhere that it couldn't be done.
Very simple in the end!|||you gotta be careful with stuff you find on the internet, eh
Tuesday, March 27, 2012
Exporting MS Access to SQL Server
hi,
how can export an Access Data bank to sql Server with all definition (the
relationship between the tables)
You can use the Access Upsizing wizard (available on MS web site). But most
people prefer to use DTS and do things manually..THe upsizing wizard makes
some assumptions which must be manually handled anyway..Look at DTS with
Access as a data source.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Zaid" <Zaid@.discussions.microsoft.com> wrote in message
news:6D71D63A-FE51-4066-9171-60DC7A1A7A11@.microsoft.com...
> hi,
> how can export an Access Data bank to sql Server with all definition (the
> relationship between the tables)
>
how can export an Access Data bank to sql Server with all definition (the
relationship between the tables)
You can use the Access Upsizing wizard (available on MS web site). But most
people prefer to use DTS and do things manually..THe upsizing wizard makes
some assumptions which must be manually handled anyway..Look at DTS with
Access as a data source.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Zaid" <Zaid@.discussions.microsoft.com> wrote in message
news:6D71D63A-FE51-4066-9171-60DC7A1A7A11@.microsoft.com...
> hi,
> how can export an Access Data bank to sql Server with all definition (the
> relationship between the tables)
>
Exporting MS Access to SQL Server
hi,
how can export an Access Data bank to sql Server with all definition (the
relationship between the tables)You can use the Access Upsizing wizard (available on MS web site). But most
people prefer to use DTS and do things manually..THe upsizing wizard makes
some assumptions which must be manually handled anyway..Look at DTS with
Access as a data source.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Zaid" <Zaid@.discussions.microsoft.com> wrote in message
news:6D71D63A-FE51-4066-9171-60DC7A1A7A11@.microsoft.com...
> hi,
> how can export an Access Data bank to sql Server with all definition (the
> relationship between the tables)
>
how can export an Access Data bank to sql Server with all definition (the
relationship between the tables)You can use the Access Upsizing wizard (available on MS web site). But most
people prefer to use DTS and do things manually..THe upsizing wizard makes
some assumptions which must be manually handled anyway..Look at DTS with
Access as a data source.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Zaid" <Zaid@.discussions.microsoft.com> wrote in message
news:6D71D63A-FE51-4066-9171-60DC7A1A7A11@.microsoft.com...
> hi,
> how can export an Access Data bank to sql Server with all definition (the
> relationship between the tables)
>
Exporting From SQL Server To MSACCESS
Hi,
I Need to make a script or task that programmatically export data from SQL Server to Access File , and how to call the script from the .NET?
Create SSIS package using Import/Export Wizard, you can then run this package from any .NET application either by running DTEXEC or using SSIS object model - see SQL Books Online for sample syntax of both.Sunday, March 25, 2012
Exporting DataSets from multiple datasources
Is their away to have reporting services call a dataset from an access
database and export it into a sql server table through automation in a
project with 2 datasources. One datasource from access and the other from
sql server. I can do this with a DTS, but could I do it another way to work
around a DTS.
RandyUrghh, i don´t think that the way reporting services should be used. If you
really really really wanna do this, set up an linked server on sql server to
point to access and write a procedure in which you do your importing stuff.
Return from the procedure some kind of return code to display this in your
report.
But (BTW) is a really nasty way to use RS :(
HTH (either), Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Randy" <Randy@.discussions.microsoft.com> schrieb im Newsbeitrag
news:5218EBE9-A92E-4528-B381-9E835A72A978@.microsoft.com...
> Is their away to have reporting services call a dataset from an access
> database and export it into a sql server table through automation in a
> project with 2 datasources. One datasource from access and the other from
> sql server. I can do this with a DTS, but could I do it another way to
> work
> around a DTS.
> Randy|||Let me add my voice to what Jens is saying. This is definitely NOT a good
idea.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:ebfg4dERFHA.904@.tk2msftngp13.phx.gbl...
> Urghh, i don´t think that the way reporting services should be used. If
you
> really really really wanna do this, set up an linked server on sql server
to
> point to access and write a procedure in which you do your importing
stuff.
> Return from the procedure some kind of return code to display this in your
> report.
> But (BTW) is a really nasty way to use RS :(
> HTH (either), Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Randy" <Randy@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:5218EBE9-A92E-4528-B381-9E835A72A978@.microsoft.com...
> > Is their away to have reporting services call a dataset from an access
> > database and export it into a sql server table through automation in a
> > project with 2 datasources. One datasource from access and the other
from
> > sql server. I can do this with a DTS, but could I do it another way to
> > work
> > around a DTS.
> >
> > Randy
>
database and export it into a sql server table through automation in a
project with 2 datasources. One datasource from access and the other from
sql server. I can do this with a DTS, but could I do it another way to work
around a DTS.
RandyUrghh, i don´t think that the way reporting services should be used. If you
really really really wanna do this, set up an linked server on sql server to
point to access and write a procedure in which you do your importing stuff.
Return from the procedure some kind of return code to display this in your
report.
But (BTW) is a really nasty way to use RS :(
HTH (either), Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Randy" <Randy@.discussions.microsoft.com> schrieb im Newsbeitrag
news:5218EBE9-A92E-4528-B381-9E835A72A978@.microsoft.com...
> Is their away to have reporting services call a dataset from an access
> database and export it into a sql server table through automation in a
> project with 2 datasources. One datasource from access and the other from
> sql server. I can do this with a DTS, but could I do it another way to
> work
> around a DTS.
> Randy|||Let me add my voice to what Jens is saying. This is definitely NOT a good
idea.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:ebfg4dERFHA.904@.tk2msftngp13.phx.gbl...
> Urghh, i don´t think that the way reporting services should be used. If
you
> really really really wanna do this, set up an linked server on sql server
to
> point to access and write a procedure in which you do your importing
stuff.
> Return from the procedure some kind of return code to display this in your
> report.
> But (BTW) is a really nasty way to use RS :(
> HTH (either), Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Randy" <Randy@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:5218EBE9-A92E-4528-B381-9E835A72A978@.microsoft.com...
> > Is their away to have reporting services call a dataset from an access
> > database and export it into a sql server table through automation in a
> > project with 2 datasources. One datasource from access and the other
from
> > sql server. I can do this with a DTS, but could I do it another way to
> > work
> > around a DTS.
> >
> > Randy
>
Exporting Data+Structure
Hello E'body,
I have to export a SQL Server Table (Structure+Data) to an access mdb file at run time. How can i do it? please help.
Lax.You can use DTS wizard in SQL Server to accomplish the task.
For information review topics available in SQL books online.
ONce you've designed the package, can schedule it to run as a job at run time.
I have to export a SQL Server Table (Structure+Data) to an access mdb file at run time. How can i do it? please help.
Lax.You can use DTS wizard in SQL Server to accomplish the task.
For information review topics available in SQL books online.
ONce you've designed the package, can schedule it to run as a job at run time.
Exporting data to access
I am looking for a way to export my information out of SQL 2000 to access.
I would like to have an exact replica of my SQL databases but in dbf format.
Is there a way to do a backup in SQL in DBF format? Is there a utility to
convert a SQL Backup to DBF.
Thank-you
If you want your database in access, why do you want it in
dbf format? Access uses mdb files.
You can't backup a SQL Server database to other database
platform formats. You can export the data to Access using
DTS. Another option is replication as Access can be a
subscriber to SQL Server publications. You can find more
info in books online under the topic Access Subscribers.
-Sue
On Tue, 24 Aug 2004 09:20:17 -0300, "kmd" <kmd@.hotmail.com>
wrote:
>I am looking for a way to export my information out of SQL 2000 to access.
>I would like to have an exact replica of my SQL databases but in dbf format.
>Is there a way to do a backup in SQL in DBF format? Is there a utility to
>convert a SQL Backup to DBF.
>Thank-you
>
I would like to have an exact replica of my SQL databases but in dbf format.
Is there a way to do a backup in SQL in DBF format? Is there a utility to
convert a SQL Backup to DBF.
Thank-you
If you want your database in access, why do you want it in
dbf format? Access uses mdb files.
You can't backup a SQL Server database to other database
platform formats. You can export the data to Access using
DTS. Another option is replication as Access can be a
subscriber to SQL Server publications. You can find more
info in books online under the topic Access Subscribers.
-Sue
On Tue, 24 Aug 2004 09:20:17 -0300, "kmd" <kmd@.hotmail.com>
wrote:
>I am looking for a way to export my information out of SQL 2000 to access.
>I would like to have an exact replica of my SQL databases but in dbf format.
>Is there a way to do a backup in SQL in DBF format? Is there a utility to
>convert a SQL Backup to DBF.
>Thank-you
>
Monday, March 19, 2012
Export Wizard disturb the order of data while exporting Data to Acess 2003 from SQL server 2005
I am using the following query to export data from sql server to ms access in export data wizard:
SELECT * FROM myView where myID = 123
Order by varcharColumnName1,varcharColumnName2 ,intColumnName3
This query will fetch about 7, 00,000 records.
SQL server 2005 shows the correct order, but Data in access table shows Incorrect data.
Please give me the solutions.
If the only diffrence in the tables is the order of the rows I would not call it incorrect data. If you need the data to be shown in a especific order you need to use Order By clause in your query
|||i am using order by in my query . Data is correct in Access but order is not correct.|||Dear All,
Thankyou for your replies.
I have found a temperory solution. After exporting data to access file. Open table in design view,Right click on tble and select properties. A dialog box will open. Set the order by property like COL1,COL2 etc. CLose the dialog box. Open table, now data is sorted.
Thankx again for your replies. However if you find any better solution please inform me at zeeshanahmedskt@.hotmail.com or post here.
Export Wizard disturb the order of data while exporting Data to Acess 2003 from SQL server 2005
I am using the following query to export data from sql server to ms access in export data wizard:
SELECT * FROM myView where myID = 123
Order by varcharColumnName1,varcharColumnName2 ,intColumnName3
This query will fetch about 7, 00,000 records.
SQL server 2005 shows the correct order, but Data in access table shows Incorrect data.
Please give me the solutions.
If the only diffrence in the tables is the order of the rows I would not call it incorrect data. If you need the data to be shown in a especific order you need to use Order By clause in your query
|||i am using order by in my query . Data is correct in Access but order is not correct.|||Dear All,
Thankyou for your replies.
I have found a temperory solution. After exporting data to access file. Open table in design view,Right click on tble and select properties. A dialog box will open. Set the order by property like COL1,COL2 etc. CLose the dialog box. Open table, now data is sorted.
Thankx again for your replies. However if you find any better solution please inform me at zeeshanahmedskt@.hotmail.com or post here.
Export Wizard disturb the order of data while exporting Data to Acess 2003 from SQL server 2005
I am using the following query to export data from sql server to ms access in export data wizard:
SELECT * FROM myView where myID = 123
Order by varcharColumnName1,varcharColumnName2 ,intColumnName3
This query will fetch about 7, 00,000 records.
SQL server 2005 shows the correct order, but Data in access table shows Incorrect data.
Please give me the solutions.
If the only diffrence in the tables is the order of the rows I would not call it incorrect data. If you need the data to be shown in a especific order you need to use Order By clause in your query
|||i am using order by in my query . Data is correct in Access but order is not correct.|||Dear All,
Thankyou for your replies.
I have found a temperory solution. After exporting data to access file. Open table in design view,Right click on tble and select properties. A dialog box will open. Set the order by property like COL1,COL2 etc. CLose the dialog box. Open table, now data is sorted.
Thankx again for your replies. However if you find any better solution please inform me at zeeshanahmedskt@.hotmail.com or post here.
Export Wizard disturb order of data during exporting Data to Acess 2003 from SQL server 2005
I am using the following query to export data from sql server to ms access in export data wizard:
SELECT * FROM myView where myID = 123
Order by varcharColumnName1,varcharColumnName2 ,intColumnName3
This query will fetch about 7, 00,000 records.
SQL server 2005 shows the correct order, but Data in access table shows Incorrect order of data.
Please give me the solutions.
Speaking logically, sets and tables don’t have order. Order can be specified in a SELECT. Order can be the result of a clustered index but typically there is no guarantee of order without an explicit ORDER BY.
This is generally true of all Relational Databases.
Did you try placing an index on the Access table?
|||True, I believe this more a call from Access 2003 settings to see how data is displayed.
Also check the code in Access about getting this data display.
|||Dear All,
I have found a temperory solution. After exporting data to access file. Open table in design view,Right click on tble and select properties. A dialog box will open. Set the order by property like COL1,COL2 etc. CLose the dialog box. Open table, now data is sorted.
Thank you all of you for your replies.
However if you find any better solution please inform me at zeeshanahmedskt@.hotmail.com or post here.
Export Wizard disturb order of data during exporting Data to Acess 2003 from SQL server 2005
I am using the following query to export data from sql server to ms access in export data wizard:
SELECT * FROM myView where myID = 123
Order by varcharColumnName1,varcharColumnName2 ,intColumnName3
This query will fetch about 7, 00,000 records.
SQL server 2005 shows the correct order, but Data in access table shows Incorrect order of data.
Please give me the solutions.
Speaking logically, sets and tables don’t have order. Order can be specified in a SELECT. Order can be the result of a clustered index but typically there is no guarantee of order without an explicit ORDER BY.
This is generally true of all Relational Databases.
Did you try placing an index on the Access table?
|||True, I believe this more a call from Access 2003 settings to see how data is displayed.
Also check the code in Access about getting this data display.
|||Dear All,
I have found a temperory solution. After exporting data to access file. Open table in design view,Right click on tble and select properties. A dialog box will open. Set the order by property like COL1,COL2 etc. CLose the dialog box. Open table, now data is sorted.
Thank you all of you for your replies.
However if you find any better solution please inform me at zeeshanahmedskt@.hotmail.com or post here.
Export Wizard disturb order of data during exporting Data to Acess 2003 from SQL server 2005
I am using the following query to export data from sql server to ms access in export data wizard:
SELECT * FROM myView where myID = 123
Order by varcharColumnName1,varcharColumnName2 ,intColumnName3
This query will fetch about 7, 00,000 records.
SQL server 2005 shows the correct order, but Data in access table shows Incorrect order of data.
Please give me the solutions.
Speaking logically, sets and tables don’t have order. Order can be specified in a SELECT. Order can be the result of a clustered index but typically there is no guarantee of order without an explicit ORDER BY.
This is generally true of all Relational Databases.
Did you try placing an index on the Access table?
|||True, I believe this more a call from Access 2003 settings to see how data is displayed.
Also check the code in Access about getting this data display.
|||Dear All,
I have found a temperory solution. After exporting data to access file. Open table in design view,Right click on tble and select properties. A dialog box will open. Set the order by property like COL1,COL2 etc. CLose the dialog box. Open table, now data is sorted.
Thank you all of you for your replies.
However if you find any better solution please inform me at zeeshanahmedskt@.hotmail.com or post here.
Export users to other database
Dear All,
I have created users that able to access database A, now i want those
users able to access database B in same server.
How to export users from one database to other databases in the same server?
Thanks
Robert LieRobert
What is about logins? Do you have to move them as well?
Lookup at microsoft web site for two stored procedures that move logins with
their original SID.
"How to Move Logins in SQL Server"
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:uM6CTLWdFHA.892@.tk2msftngp13.phx.gbl...
> Dear All,
> I have created users that able to access database A, now i want those
> users able to access database B in same server.
> How to export users from one database to other databases in the same
server?
> Thanks
> Robert Lie
I have created users that able to access database A, now i want those
users able to access database B in same server.
How to export users from one database to other databases in the same server?
Thanks
Robert LieRobert
What is about logins? Do you have to move them as well?
Lookup at microsoft web site for two stored procedures that move logins with
their original SID.
"How to Move Logins in SQL Server"
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:uM6CTLWdFHA.892@.tk2msftngp13.phx.gbl...
> Dear All,
> I have created users that able to access database A, now i want those
> users able to access database B in same server.
> How to export users from one database to other databases in the same
server?
> Thanks
> Robert Lie
Export users to other database
Dear All,
I have created users that able to access database A, now i want those
users able to access database B in same server.
How to export users from one database to other databases in the same server?
Thanks
Robert Lie
Robert
What is about logins? Do you have to move them as well?
Lookup at microsoft web site for two stored procedures that move logins with
their original SID.
"How to Move Logins in SQL Server"
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:uM6CTLWdFHA.892@.tk2msftngp13.phx.gbl...
> Dear All,
> I have created users that able to access database A, now i want those
> users able to access database B in same server.
> How to export users from one database to other databases in the same
server?
> Thanks
> Robert Lie
I have created users that able to access database A, now i want those
users able to access database B in same server.
How to export users from one database to other databases in the same server?
Thanks
Robert Lie
Robert
What is about logins? Do you have to move them as well?
Lookup at microsoft web site for two stored procedures that move logins with
their original SID.
"How to Move Logins in SQL Server"
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:uM6CTLWdFHA.892@.tk2msftngp13.phx.gbl...
> Dear All,
> I have created users that able to access database A, now i want those
> users able to access database B in same server.
> How to export users from one database to other databases in the same
server?
> Thanks
> Robert Lie
Export users to other database
Dear All,
I have created users that able to access database A, now i want those
users able to access database B in same server.
How to export users from one database to other databases in the same server?
Thanks
Robert LieRobert
What is about logins? Do you have to move them as well?
Lookup at microsoft web site for two stored procedures that move logins with
their original SID.
"How to Move Logins in SQL Server"
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:uM6CTLWdFHA.892@.tk2msftngp13.phx.gbl...
> Dear All,
> I have created users that able to access database A, now i want those
> users able to access database B in same server.
> How to export users from one database to other databases in the same
server?
> Thanks
> Robert Lie
I have created users that able to access database A, now i want those
users able to access database B in same server.
How to export users from one database to other databases in the same server?
Thanks
Robert LieRobert
What is about logins? Do you have to move them as well?
Lookup at microsoft web site for two stored procedures that move logins with
their original SID.
"How to Move Logins in SQL Server"
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:uM6CTLWdFHA.892@.tk2msftngp13.phx.gbl...
> Dear All,
> I have created users that able to access database A, now i want those
> users able to access database B in same server.
> How to export users from one database to other databases in the same
server?
> Thanks
> Robert Lie
Wednesday, March 7, 2012
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.
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 throw WrapperReportRenderingException
I knows I have post this before, but no solution found yet.
Could anyone help please..... ?
A 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.
I have found out it is down to a table grouping on a data field.
I have created a cut down version of RDL file together with the RDL.data
file if anyone interested to take a look.
The report conatins a list and the list has a details group, which grouping
the data by week.
A table is sit inside the list to report the data.
Within the table, there is a group list which is grouped by a field from the
dataset.
Also a header and footer together with the table of cause is repeated on
every page.
The header in the cut down version of RDL file contains only a static
textbox.
The footer contains a static textbox and a textbox that has value ="Page " &
Globals!PageNumber & " of " & Globals!TotalPages.
Another thing that I have found is if I export a report with this page
number textbox included in the footer, this WrapperReportRenderingException
is throws. But, if I remove this page number text box from the footer, the
export to excel works...
Here is the error from the report server log:
------
aspnet_wp!library!1!01/11/2008-14:54:49:: i INFO: Call to RenderNext(
'/ExportExcelProblemReport' )
aspnet_wp!reportrendering!1!01/11/2008-14:54:50:: 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 --
aspnet_wp!webserver!1!01/11/2008-14:54:50:: e ERROR: Reporting Services
error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An
error occurred during rendering of the report. -->
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 --
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(IRenderingExtension
renderer, CreateReportChunk createChunkCallback, RenderingContext rc,
GetResource getResourceCallback)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
at Microsoft.ReportingServices.Library.RenderSnapshotAction.Render()
at
Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext
reportContext, ClientRequest session, RenderingResult& result)
at
Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effecectiveParameters, String[]&
secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderNextCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderNextCancelableStep.RenderNext(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobType type,
Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
streamFactory)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation
operation)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
itemType)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
------
Thanks in advance !
Regards,
Chris.Hello,
Since the Excel export did not include the page footer, you may try to
remove the footer.
I tested on my side and did not reproduce this issue.
Did this issue appeared on all reports?
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 Wei,
Nice to hear from you again and thank you very much for looking into it.
I have just tried it on my cut down version of report, if I remove the
footer its works.
But when I tried it to my actural report, even if I have removed the
complete footer, the error still occured.
I have emailed you the actural report of our company, again a RDL file
together with the RDL.DATA file.
Could you please, please spent a little time of yours and take a look at it
please.
It is getting desperate.... :(
To answer your question, we have another 2 reports that use the similar
dataset also have the same problem when the table is group on the same
field.
Also, I am not sure whether it helps, I listed some of the dll files version
within our Report server bin directory.
On our live Web Server:
ReportingServicesService.exe
9.0.3205.0
Microsoft.ReportingServices.ExcelRendering.dll 9.0.3042.0
Microsoft.ReportingServices.NullRendering.dll
9.0.1399.0
On My Test Machine:
ReportingServicesService.exe
9.0.3054.0
Microsoft.ReportingServices.ExcelRendering.dll 9.0.3042.0
Microsoft.ReportingServices.NullRendering.dll
9.0.1399.0
Chris
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:zO0IwgoVIHA.4264@.TK2MSFTNGHUB02.phx.gbl...
> Hello,
> Since the Excel export did not include the page footer, you may try to
> remove the footer.
> I tested on my side and did not reproduce this issue.
> Did this issue appeared on all reports?
> 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 am performing some research on this. Since i did not reproduce this
issue, I may need some more time to try to get the resolution.
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.
Could anyone help please..... ?
A 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.
I have found out it is down to a table grouping on a data field.
I have created a cut down version of RDL file together with the RDL.data
file if anyone interested to take a look.
The report conatins a list and the list has a details group, which grouping
the data by week.
A table is sit inside the list to report the data.
Within the table, there is a group list which is grouped by a field from the
dataset.
Also a header and footer together with the table of cause is repeated on
every page.
The header in the cut down version of RDL file contains only a static
textbox.
The footer contains a static textbox and a textbox that has value ="Page " &
Globals!PageNumber & " of " & Globals!TotalPages.
Another thing that I have found is if I export a report with this page
number textbox included in the footer, this WrapperReportRenderingException
is throws. But, if I remove this page number text box from the footer, the
export to excel works...
Here is the error from the report server log:
------
aspnet_wp!library!1!01/11/2008-14:54:49:: i INFO: Call to RenderNext(
'/ExportExcelProblemReport' )
aspnet_wp!reportrendering!1!01/11/2008-14:54:50:: 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 --
aspnet_wp!webserver!1!01/11/2008-14:54:50:: e ERROR: Reporting Services
error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An
error occurred during rendering of the report. -->
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 --
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(IRenderingExtension
renderer, CreateReportChunk createChunkCallback, RenderingContext rc,
GetResource getResourceCallback)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
at Microsoft.ReportingServices.Library.RenderSnapshotAction.Render()
at
Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext
reportContext, ClientRequest session, RenderingResult& result)
at
Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effecectiveParameters, String[]&
secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderNextCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderNextCancelableStep.RenderNext(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobType type,
Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
streamFactory)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation
operation)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
itemType)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
------
Thanks in advance !
Regards,
Chris.Hello,
Since the Excel export did not include the page footer, you may try to
remove the footer.
I tested on my side and did not reproduce this issue.
Did this issue appeared on all reports?
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 Wei,
Nice to hear from you again and thank you very much for looking into it.
I have just tried it on my cut down version of report, if I remove the
footer its works.
But when I tried it to my actural report, even if I have removed the
complete footer, the error still occured.
I have emailed you the actural report of our company, again a RDL file
together with the RDL.DATA file.
Could you please, please spent a little time of yours and take a look at it
please.
It is getting desperate.... :(
To answer your question, we have another 2 reports that use the similar
dataset also have the same problem when the table is group on the same
field.
Also, I am not sure whether it helps, I listed some of the dll files version
within our Report server bin directory.
On our live Web Server:
ReportingServicesService.exe
9.0.3205.0
Microsoft.ReportingServices.ExcelRendering.dll 9.0.3042.0
Microsoft.ReportingServices.NullRendering.dll
9.0.1399.0
On My Test Machine:
ReportingServicesService.exe
9.0.3054.0
Microsoft.ReportingServices.ExcelRendering.dll 9.0.3042.0
Microsoft.ReportingServices.NullRendering.dll
9.0.1399.0
Chris
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:zO0IwgoVIHA.4264@.TK2MSFTNGHUB02.phx.gbl...
> Hello,
> Since the Excel export did not include the page footer, you may try to
> remove the footer.
> I tested on my side and did not reproduce this issue.
> Did this issue appeared on all reports?
> 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 am performing some research on this. Since i did not reproduce this
issue, I may need some more time to try to get the resolution.
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.
Sunday, February 26, 2012
Export to Excel in MS Access
Hi,
I have one form in access application which shows various fields from
the database. The fields are like No of PCs a client has,No of
employees,revenue etc.
Need of the user is to filter the data on the form and export the
results.
I am using a Qury as the base for this form.Can I do it easily or i
need to write the code to do this.
Secondly can I provide a separate interface to allow user to Query and
extract the data.
Say, PC between <SomeRange> AND/ OR
Revenue Between <Some Range
whatever result comes will be exported to the Excel file.
Please tell me if you have any solution.
Thanks in Advance.
Rohit
--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/General-Dis...pict241673.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=840002If you can utilize a query to create the data you want, then you can do
a simple trick of exporting the data within Access to Excel with very
little code.
DoCmd.OutputTo acOutputQuery, "Name Of Query", acFormatXLS
This can be assigned to a button and you have your results. This works
great if the query is based off the actual form.
Enjoy!
Subscribe to:
Posts (Atom)