There is one database with 5 user schemas, only two of them show up using ODBC. All rights reserved.Unauthorized reproduction or linking forbidden without expressed written permission. Close Box Join Tek-Tips Today! Problem solvedEngineer Edit Delete Comment bjm_me 25 Laps Re: Cant see tables from crystal connection 03 Oct 2006 Please tell us how you fixed the problem, because the same thing is
Do I need a newer version of Crystal Reports in order to properly connect to the servicedesk database? Try a different database. a long time ago. Like Show 0 Likes(0) Actions 3. Get More Information
Go to report options - database - show Store Procedure - this should be UNCHECKED. I am getting the following message: "Failed to retrieve data from the database" "Procedure or Function expects parameter [email protected]', which was not supplied". 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 He is responsible for the management of RKL’s customer facing helpdesk and application support.
Join Us! *Tek-Tips's functionality depends on members receiving e-mail. Just a few tables are shown but i cannot use 99% of the views in the database because Crystal Reports does not show them. My guess is that when Crystal is making the ODBC calls that it is passing arguments that tell the ODBC driver to ignore certain schemas. Required fields are marked * Name * Email * Website Comment Blog Updates by Email E-Mail Address Grab Your Free Guide!
Click OK and close the Registry Editor. Regards, Fatima Like Show 0 Likes(0) Actions 11. Product Specialties: Sage 500 ERP, Sage ERP X3, Crystal Reports, SQL Server Administration Comments Becky Edwards says May 4, 2015 at 2:28 pm Thank you! http://www.forumtopics.com/busobj/viewtopic.php?p=968381&sid=a2b6d28ebba3810ffcbc16337ae3f7cd The Registry Editor will appear.3.
If she connects using the Oracle Server method she see's all schemas. Like Show 0 Likes(0) Actions 5. I have the same question Show 0 Likes(0) 9757Views Tags: none (add) This content has been marked as final. Via the ODBC connection both user schemas and system schemas (SYSTEM in particular) just don't show up.
share|improve this answer answered May 2 at 9:26 praveen 1 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up http://visualbasic.ittoolbox.com/groups/technical-functional/vb-crystalreports-l/cant-see-view-objects-in-crystal-can-see-them-in-other-reporting-tools-2936322 This issue can be solved with a simple registry change and restarting Crystal Reports. We have hundreds of tables at best, nowhere near the 8000 limit. Are you aComputer / IT professional?Join Tek-Tips Forums!
Hot Network Questions What is with the speech audience? There is a registry setting in Crystal Reports that restricts the objects that are available to add to a report to 8000 objects. Toolbox for IT My Home Topics People Companies Jobs White Paper Library Collaboration Tools Discussion Groups Blogs Follow Toolbox.com Toolbox for IT on Twitter Toolbox.com on Twitter Toolbox.com on Facebook Topics Type "Regedit", then click OK.
Crystal Report has some limit is loading all table names so select the scheme so that it will load only that schema. Nothing. However, I noticed that those instructions mention Crystal Reports XI (version 11). What are the applications of taking the output of an amp with a microphone?
So we found that we needed to give the user namewe were using persmissons in the SP by right clicking on the SP and selecting "Properties". Here are the steps: Click Start, Run, and enter regedt32 in the Open field and click OK (requires administrator access rights). Permalink Save Cancel Change topic typeTopic Type : DiscussionsAnnouncementsQuestionsIdeasProblemsNo of days : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
I am running Crystal Reports 9 Standard. Here's Why Members Love Tek-Tips Forums: Talk To Other Members Notification Of Responses To Questions Favorite Forums One Click Access Keyword Search Of All Posts, And More... Hm... Now that you have crystal reports and query editor, you may not have the necessity to use crystal reports.Kevin Edit Delete Comment bjm_me 25 Laps Re: Cant see tables from crystal
Use a Pipelined Function to Select Source Code Arguments For discussions on Visual Basic for Crystal Reports please visit the Visual Basic – General Discussions group. Re: Crystal Reports 2008 doesn't show all schemas with ODBC user8096417 Oct 5, 2009 12:55 PM (in response to gdarling - oracle) Thanks but no. 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. PCMag Digital Group AdChoices unused RKL eSolutions - Sage ERP and IT Support Provider Home Software Sage 100 Sage 500 ERP Sage X3 Features Overview Sage X3 Cloud Interactive Product Tour
asked 5 years ago viewed 4238 times active 6 months ago Upcoming Events 2016 Community Moderator Election ends Nov 22 Get the weekly newsletter! Remote into the web server to see if I can run one from there. https://community.oracle.com/thread/968005 Hope this helps. oracle crystal-reports reporting oracle11g crystal-reports-2008 share|improve this question asked Nov 8 '11 at 13:57 SeanKilleen 3,446104593 add a comment| 3 Answers 3 active oldest votes up vote 2 down vote accepted
Check TABLES, and thousands of tables show up again. It appears to have been resolved. As always, thanks for your help. I'm using an Oracle in OraClient10g_home3 ODBC driver.
I couldn't remember how to fix this problem and your instructions were perfect!. Any ideas? Why is this C++ code faster than my hand-written assembly for testing the Collatz conjecture? I can see the views in other reporting tools like Cognos Imrpomptu, SQL Plus, and Toad.
by LyleU faq766-7508 Posted: 17Aug11 The number of objects (tables, views, sprocs, etc...)is determined by an entry in the Registry. (Of course, you must have the proper access to all of 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 Also i checked the ODBC Connections and i can connect and also the rights in the database for the user are enough and ok.Following problem:When i build a new report and If everything else was testing okay, then you should now be able to see the tables in Crystal or Access.
I have two users; an admin user (where I create the views, etc.) and a reporting user that has the ability to query certain tables/views. Spoke w/ the DBA, watched/walked him through the check, still nothing. Join them; it only takes a minute: Sign up Crystal Reports 2008 doesn't show database tables / views that I know exist up vote 0 down vote favorite I have a I am new in US (I just have SSN but no California ID in 10 days) but I need change my Cash to Cashier Check to pay the Rent SMS verification,