Home > Crystal Reports > Crystal Reports Cannot See Views

Crystal Reports Cannot See Views

When I look at the database tables and try to locate that view within the Schema, it isn't showing up. Thanks! My dba granted me dbo permissions so it doesn't appear to be a rights issue. Re: Crystal Reports 2008 doesn't show all schemas with ODBC 836859 Feb 4, 2011 10:13 AM (in response to user8096417) I am experiencing the same issue. have a peek here

This issue can be solved with a simple registry change and restarting Crystal Reports. That Schema is in the library list on the ODBC Connection. You could also Search through the registry for FetchOptions, which is the same in all the versions I've worked with. There is one database with 5 user schemas, only two of them show up using ODBC. http://scn.sap.com/thread/1441367

Edit Delete Comment aazreen Formation Lap Re: Cant see tables from crystal connection 08 Nov 2006 BJM,Thank You so much for the useful information provided by you.This has been a known Re: Crystal Reports 2008 doesn't show all schemas with ODBC user8096417 Oct 7, 2009 1:25 PM (in response to JustinCave) It's not just system schema. Could there be something configured incorrectly in the ODBC connection, even though the connection test is successful?

  1. 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
  2. Many Information Center references note that recommendation.
  3. In the right-hand window of the Registry Editor, double-click NTablesMax.
  4. Quick Links Sage X3  /  Sage X3 Cloud Sage 100 Sage 500 ERP Cisco Support VMware Support Network and IT Support Blog Contact Us Corporate Headquarters RKL eSolutions, LLC 1800 Fruitville
  5. I'm not sure when the problem started, but this is the first time I noticed it.
  6. 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
  7. If i connect via Toad to the datebase with the same user like with Crystal Reports i can see the database views and also work with them.Does somebody have an idea
  8. Like Show 0 Likes(0) Actions Go to original post Actions About Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and
  9. RKL eSolutions Blog Blog Home Meet the Authors About RKL eSolutions Recent Posts Deleting Customer/BP and Supplier addresses in Sage X3 Moving off Legacy Accounting Software Fixing Book Balance in Sage

By joining you are opting in to receive e-mail. The only ones that I can see are those owned by QSECOFR. The File>Optoins>>Database> Views check box is cheked. Please enter a title.

Any suggestions? Re: Crystal Reports 2008 doesn't show all schemas with ODBC JustinCave Oct 23, 2009 7:12 PM (in response to 729756) Do you know (and/or can you trace) the ODBC calls that Any version older than is affected by this problem. http://www.forumtopics.com/busobj/viewtopic.php?p=968381&sid=a2b6d28ebba3810ffcbc16337ae3f7cd Has anyone had this happen to them before?

You can try this too: From Crystal Reports menu, go to Options >> Database tab>> Check the checkbox " System Tables" Hope this helps. I have a fresh Oracle client install and older Crystal install. Why is looping over find's output bad practice? Frank IP Logged DBlank Senior Member Joined: 19 Dec 2008 Online Status: Offline Posts: 8538 Posted: 13 May 2010 at 10:14am Sometimes I have to shut Crystal down and restart

Please turn JavaScript back on and reload this page. http://visualbasic.ittoolbox.com/groups/technical-functional/vb-crystalreports-l/cant-see-view-objects-in-crystal-can-see-them-in-other-reporting-tools-2936322 She created ODBC drivers on her Windows XP laptop but when she connects to the databases she doesn't see all the schemas. Thank you very much. Thank you.

After installing the patch, I can now see all the servicedesk tables via the MySQL ODBC connector. navigate here Thanks Shekhar 1 Likes 1 View this answer in context Helpful Answer by Abhilash Kumar Abhilash Kumar Dell Stinnett-Christy Janos Nagy Dell Stinnett-Christy 9 replies Share & Follow Privacy Terms of The same is also true on the computer that ServiceDesk is installed on. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers

Objects can include tables, views, synonyms and stored procedures.Solution:To access the NTablesMax item in the registry:1. 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 Thanks for the help. Check This Out Crystal User replied Aug 18, 2009 Hi, Please make sure that you are connecting to the correct schema and you have provided the correct schema name in ODBC connection.

Re: Crystal Reports 2008 doesn't show all schemas with ODBC dgernaat Mar 8, 2011 2:37 PM (in response to user8096417) we had a users that was missing some schemas... What else should i do to get access to the servicedeskplus database and tableI have attached a screenshot of my connections.regardsengineer Attachments servicedeskplusscreenshot_105.doc Size : 678.0 KB Reply Replies: (11) engineer_me Would we find alien music meaningful?

Forums Active Directory ADManager Plus ADAudit Plus ADSelfService Plus Applications Applications Manager SQLDBManager Plus Site24x7 Desktop and MDM Desktop Central Mobile Device Manager Plus OS Deployer IT Help Desk ServiceDesk Plus

johnjames noel replied Aug 18, 2009 Go to File>>Options and click the databse tab, then click the show checkbox. I can see all of the tables and views in that schema in iSeries Navigator. Required fields are marked * Name * Email * Website Comment Blog Updates by Email E-Mail Address Grab Your Free Guide! At least, it worked for me.

Regards, Fatima Like Show 0 Likes(0) Actions 11. Why is (a % 256) different than (a & 0xFF)? We're an authorized provider of Sage ERP software along with Cisco and Microsoft network solutions, supporting clients coast-to-coast from local offices throughout the U.S. this contact form Learn More ...

If everything else was testing okay, then you should now be able to see the tables in Crystal or Access. Just a few tables are shown but i cannot use 99% of the views in the database because Crystal Reports does not show them. share|improve this answer edited Feb 28 '15 at 0:26 answered Feb 27 '15 at 0:40 user2338816 1,70549 I wanted to say that too but I'd bet it wasn't quite IP Logged Frank in VA Newbie Joined: 15 Nov 2007 Location: United States Online Status: Offline Posts: 33 Posted: 14 May 2010 at 5:14am After checking the SQL connection, a

In the Value Data text box type "10,000". Ltd. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! When I create a new report and use the stored procedure, the parameters work fine and the report prompts me for them.

Click here to Sign upYou can also use the below options to login:Login with FacebookLogin with GoogleLogin with Yahoo Permalink close Link this topic Provide the permalink of a topic that Edit Delete Comment kkevin Employee Re: Cant see tables from crystal connection 05 Oct 2006 Bjm,See if this helps you. Crystal Reports --> Menu --> File --> Options… --> Database [tab] - uncheck Stored Procedures checkbox -doug- Like Show 1 Likes(1) Actions 10. I can see the views in other reporting tools like Cognos Imrpomptu, SQL Plus, and Toad.