Problem exporting to pdf

When I export a report to pdf I sometimes get the error 'There was an error
opening the document. The file is damaged and could not be repaired.' When I
give different parametervalues there is no problem with the export (of the
same report).
I examined the created pdf-file (with notepad) and noticed that at the end
there is the html-code for the following errormessage: Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError); Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.; Index was out of range. Must be non-negative and less than the size
of the collection. Parameter name: indexThis may have already been fixed - make sure you have installed SP1.
If it is happening on an SP1 machine, please email me a copy of your .pdf,
.rdl, and .rdl.data so I can take a look.
Thank you.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"kabouterman" <kabouterman@.discussions.microsoft.com> wrote in message
news:DCC8F9A1-E00E-473A-9A95-37ADBF497649@.microsoft.com...
> When I export a report to pdf I sometimes get the error 'There was an
> error
> opening the document. The file is damaged and could not be repaired.' When
> I
> give different parametervalues there is no problem with the export (of the
> same report).
> I examined the created pdf-file (with notepad) and noticed that at the end
> there is the html-code for the following errormessage: Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError); Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.; Index was out of range. Must be non-negative and less than the
> size
> of the collection. Parameter name: index|||When I tried the export again there was no longer a problem with the pdf-file.
SP1 was already installed.

Problem Converting XML to table in SQL server

Hi There,
I'm new to the .Net environment, and I am currently trying to convert an xml document and its appropriate schema, to a dataset then with this Dataset I would like to load it into the database. This XML file is generated from the Access 2000 format. Then sent over the internet where it is received by an HttpFileCollection object, then the schema and xml file are loaded into a dataset.
I have created a new SQL database in which I imported the table required from Access, so in theory the table that the xml is generated from should be the same as the table that the xml is destined for.
I am getting the data loaded into the dataset however, when I try to execute the data adapter update command

oda.Update(myDS, "MSGLOBAL") it is throwing an Exception, in this exception the message is telling me that there is a problem near the key word 'on'.
Now I have added a watch window to monitor the sql statements, now the oda has an insert statement generated from a query builder, however this same query builder will not create either an update or delete command.
I hope this is a good enough explanation to get a few answers, or a possible example, it seems to be a topic that is quite difficult to research.
Thank you, and if you require more info please indicate this.
Damon

Http://www.ezywiz.biz

Access 2000 is barely relational and XML that old is not relational either so use DTS to move the data to SQL Server. Try the link below for DTS samples. Hope this helps.
http://www.sqldts.com|||Thanks Gary for your quick response.
I'll have a look at the link with the SQL examples.
The dataset isn't coming directly from Access 2000 though, it is coming from the XML file extracted from the Access database on the client side and received at the server. Is DTS still an appropriate option.
Thanks...Damon|||You can move the data to SQL Server with DTS and get the dataset from SQL Server. Hope this helps.|||

Choices aplenty.

1. You can code your own inserts statement rather than using the command builder

2. Use SQL/XML updategrams

3. Use SQL OpenXML and send the XML in

4. Process the XML and send in straight forward insert commands

5. Process the dataset and send in straight forward insert command

Do you really need to use a dataset?