Cannot Drop Down Fields from Table In DB Expert
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21728
Printed Date: 18 May 2024 at 4:44pm
Topic: Cannot Drop Down Fields from Table In DB Expert
Posted By: chorwitt575
Subject: Cannot Drop Down Fields from Table In DB Expert
Date Posted: 08 Oct 2015 at 5:31am
I am using SAP Crystal v14 and have a super n00b question;
I have created a successful ADO connection that allows me to add tables but, after adding those tables, I cannot drop down to see the Fields under "Database Expert"
The user in question that I am testing on is a SQL user with sysadmin rights and extra -- Because I just want to get it to work.
Anyone know why I have a good ADO connection to DB and allows me to grab tables and views but doesnt let me see the field data?
|
Replies:
Posted By: kevlray
Date Posted: 09 Oct 2015 at 5:58am
|
Odd as it sounds, I know that unless you give specific rights to a table in newer versions of MS-SQL, you can see the table, but not the fields (go figure). I have a DBA double check the rights for the tables.
|
|