web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / failed to open a rowset
Microsoft Dynamics SL (Archived)

failed to open a rowset

(0) ShareShare
ReportReport
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

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    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.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    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.

  • Community Member Profile Picture
    Community Member on at

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans