IIS

[Former Member]

I have asp.net project using visual studio 2008. The report itself worked on crystal desing 2008 and .net development. However, when it is run in IIS, it gives the following error

One or more fields could not be found in the result set. Use Verify Database to update the report. Error in File reportname{FE4AE92E-D68E-4B8C-94D3-83D307BE1D33}.rpt: The rowset column could not be found.

I verified databases of the reports and they are updated.

Need help. Thanks

[Former Member · Accepted solution]

Hi,

Are we changing the database schema at runtime? Please note that it seems that the report is unable to access a field that was used in the design time.

Please use the following code to get the schema and data in xml format and then use this as a data source in the designer to make sure that we do not get any field getting dropped.

datasetObject.WriteXml("c:\temp\myData1.xml",XmlWriteMode.WriteSchema);

Thanks.

Edited by: A G on Aug 25, 2009 1:10 AM

[Former Member · Accepted solution]

Thank you for your answer. The application design is to call the .rpt directly without creating xsd data source. The problem appears that the IIS memorizes the original report data source. I can add not new data field to report. The reports were updated from Crystal report 9. I thought the memorization was from IIS .net application. However, it is not true since I restarted IIS. The problem remains. I changed a field datatype from int to character, say field A. The A in asp development is showing correctly and in IIS showed an integer, which was incorrect. Please help.

[Former Member · Accepted solution]

Hi,

I am assuming that you have checked the report from CR2008 SP0 designer at least.

Now if we are not changing the location of the report(server name , database name etc) then create a udl file to check the connection of the server with database. Do you get a success?

Thanks.

[Former Member · Accepted solution]

Yes. I did all of those and they were successful.