How to resolve Failed to open a rowset problem in crystal report
-
Dear Experts, I made crystal report which is displaying one main report and then more than ten sub reports.When i login particular user report displaying as proper. When i login another user, report showing following error. Sp and tables and databases are all same. Sp also returns some data.when i manually run the crystal report in outside of the .net solution problem doesnt occured. I had verified database also. Failed to open a rowset. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: CrystalDecisions.CrystalReports.Engine.InternalException: Failed to open a rowset. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. How to resolve this issue. Any body known please help me. Thanx & Regards Mani
-
Dear Experts, I made crystal report which is displaying one main report and then more than ten sub reports.When i login particular user report displaying as proper. When i login another user, report showing following error. Sp and tables and databases are all same. Sp also returns some data.when i manually run the crystal report in outside of the .net solution problem doesnt occured. I had verified database also. Failed to open a rowset. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: CrystalDecisions.CrystalReports.Engine.InternalException: Failed to open a rowset. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. How to resolve this issue. Any body known please help me. Thanx & Regards Mani
1. Is your application running on an intranet with active directory? 2. Is the username passed as a part of the query for the crystal report? The error you are getting usually appears when the SQL command is not executed and generates an error. So I suggest to get the parameters values from you .net application and executes your query in the query analyzer window then fix the SQL error. If this does not solve your problem provide me with more information and I will do my best to help you.
Mohammad Al Hoss Development To Me Is A Pleasure more than a Job