Home > Crystal Reports > Crystal Reports Cannot See Views

Crystal Reports Cannot See Views

I just wanted to note it here in case someone else is searching for a similar issue. Thanks, Lakshmi Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Back to top jdkingForum MemberJoined: 01 Jun 2009Posts: 8 Posted: Mon Oct 21, 2013 1:51 pmPost subject: Re: Unable to see Views in Crystal Reports XI The OLE worked, thank you!! I hope someone has a better solution as it saves quite some time. weblink

I'm using the iSeries Access ODBC Driver. Select Decimal.6. Owners of objects should not have special authorities. crystal-reports ibm-midrange iseries-navigator share|improve this question asked Feb 26 '15 at 18:03 Karen D 104 Been a long time since I've been in Crystal but have you checked on http://scn.sap.com/thread/1441367

I have the same question Show 0 Likes(0) 9762Views Tags: none (add) This content has been marked as final. How do I get the report to pass the parameters to the SP? I am the only one who has access to change anything on the server or in Crystal Reports.

My dba granted me dbo permissions so it doesn't appear to be a rights issue. Goto File, Options then click on the database tab. More discussions in ODBC All PlacesDatabaseDatabase Application DevelopmentWindows and .NETODBC This discussion is archived 11 Replies Latest reply on Oct 10, 2012 2:43 PM by 967486 Crystal Reports 2008 doesn't show move to directory that was no directory Product catalog Did a thief think he could conceal his identity from security cameras by putting lemon juice on his face?

Max no of attachments : 5Publish Preview Cancel null This is preview.Publish Back to edit CancelAttachments Size : This is preview.Publish Back to edit Cancel Attaching...... Trademarks | Privacy Policy | Site Map | Contact Us | Careers Skip navigationOracle Community DirectoryOracle Community FAQLog inRegisterMy Oracle Support Community (MOSC)SearchSearchCancelGo Directly To Oracle Technology Network CommunityMy Oracle Support From Crystal when i try to create a report. http://www.forumtopics.com/busobj/viewtopic.php?p=968381&sid=a2b6d28ebba3810ffcbc16337ae3f7cd http://forums.manageengine.com/forumHome.do?forumGroupId=49000000002007&forumTopicId=49000002659655&Kevin// Edit Delete Comment bjm_me 25 Laps Re: Cant see tables from crystal connection 05 Oct 2006 Following those instructions exactly, I still can't see any tables.

If possible, change the ownership to a different profile that has no purpose other than to act as an owner. Any ideas on why I can't see the views in Crystal only? Click OK.7. I have created a stored procedure in SQL2005.

I don't know why it wouldn't do the same thing when you make a direct OCI connection-- potentially they never implemented that particular nicety when they had to directly query the Does f:x mean the same thing as f(x)? Re: Crystal Reports 2008 doesn't show all schemas with ODBC 733145 Nov 10, 2009 12:45 AM (in response to 729756) I'm seeing this as well. Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Business Objects: Crystal

I must have been logged in that way when I created those 5 tables. http://homeshareware.com/crystal-reports/crystal-reports-this-document-cannot-be-opened.html More Visual Basic Groups Your account is ready. I can see the views in other reporting tools like Cognos Imrpomptu, SQL Plus, and Toad. The full article is available in a knowledgebase article located at http://support.crystaldecisions.com/library/kbase/new_articles/c2013269.aspRegards,aazreen.

Other times I find I am using an incorrect ODBC connection and pointing to my test set when my changes were in my production set or vice versa. All product names are trademarks of their respective companies. However, I noticed that those instructions mention Crystal Reports XI (version 11). http://homeshareware.com/crystal-reports/crystal-reports-uninstall-utility.html Can there be a sarcastic meaning to "top gun" in a (non-)linguistic context like this?

Edit Delete Comment kkevin Employee Re: Cant see tables from crystal connection 05 Oct 2006 Bjm,See if this helps you. Join your peers on the Internet's largest technical computer professional community.It's easy to join and it's free. Replace the default of 8000 with a higher number like 20000.

Regards, Fatima Like Show 0 Likes(0) Actions 11.

The permissions on individual views/tables within the Schema give me "All" authority. In the right-hand window of the Registry Editor, double-click NTablesMax. This was driving me crazy! Why is looping over find's output bad practice?

Join this group Popular White Paper On This Topic ERP Supply Chain Comparison Guide 4Replies Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes She created ODBC drivers on her Windows XP laptop but when she connects to the 10.2.0.4 databases she doesn't see all the schemas. Re: Crystal Reports 2008 doesn't show all schemas with ODBC gdarling - oracle Oct 2, 2009 7:24 PM (in response to user8096417) See if this helps, http://www.sdn.sap.com/irj/scn/advancedsearch?query=1213798 Greg Like Show 0 http://homeshareware.com/crystal-reports/crystal-reports-cannot-load-keycode-dll.html I have no idea what might have changed (I always login to Crystal as Karen), but this will get me by until I can figure it out. –Karen D Feb 26

Many Information Center references note that recommendation. This new application's vendor is not helpful--so I'm left wondering also if I need an updated driver, or even a newer version of Crystal or does XI work on this type Back to top jdkingForum MemberJoined: 01 Jun 2009Posts: 8 Posted: Fri Oct 18, 2013 3:19 pmPost subject: Re: Unable to see Views in Crystal Reports XI Yes, the Views are selected The only ones that I can see are those owned by QSECOFR.

Tell us and we'll get back to you Cancel © Zoho Corporation Pvt. The report now prompts me for the dates, but the SP is not seeing them. Filed Under: General, Sage ERP Software (All Products), Sage X3 Tagged With: Crystal Reports, Sage ERPAbout Cliff HorstCliff is the VP of Application Support at RKL eSolutions LLC. The Registry Editor will appear.3.

Register now while it's still free!

Back to Top