failed to open a rowset

(0) Share

Report

Posted on by Community Member

Hi,

Hope someone can help me.

I am new in creating custom Crystal Report for MSDynamics SL. I created a VIEW to begin with with this statement below:

SELECT  
 	APDoc.DocType ,APDoc.RefNbr ,APDoc.BatNbr, APDoc.PerEnt, ApDoc.PerPost
FROM   
	dbo.APDoc APDoc WITH(NOLOCK)	
WHERE 
	APDoc.DocClass = 'N' AND (APDoc.DocType = 'VO' OR APDoc.DocType = 'AD' OR APDoc.DocType = 'AC')
	--AND APDoc.PerPost = '201712'

I also created the following successfully: created the report in the menu and in Report Control Maintenance, and created a new crystal report file.
0488.crystalreport.jpg

1st. Previewing the report without the option to view data filter by PerPost is fine.
2nd. When I updated the report control with the setting below

5270.reportcontrol1.jpg

that is when I get this error

7345.error.jpg

*This post is locked for comments

All responses (3)

Answers (1)

Community Member on at

Like (0)

Report

RE: failed to open a rowset

Thank you for checking and replying to my question. I fixed it my self.
Verified answer

Community Member on at

Like (0)

Report

RE: failed to open a rowset

Fixed this myself. Run a SQL Profiler to see the problem. I am using a view and the value I placed based on my 3rd image above under 'Period Field Name' is Apdoc.PerPost. I updated this to myviewname.PerPost.
Suggested answer

Community Member on at

Like (0)

Report

RE: failed to open a rowset

Not sure if this is your issue or not but I had something similar several years back and resolved it by opening the ODBC definition for the database (Crystal Reports utilizes ODBC to connect to SQL) and I checked the option to Use ANSI quoted identifiers on the DSN configuration page.