cancel
Showing results for 
Search instead for 
Did you mean: 

List of values selection criteria not displayed in Crystal .Net Viewer

Former Member
0 Kudos

As a carry on from issue "https://archive.sap.com/discussions/thread/3668071" the .net viewer does not seem to show the dynamic drop down list whereas the old active X viewer does, the parameter field in the report it set as a dynamic field and the report does not pull the data to show in the drop down list. The report is connected to a DB from a ODBC, and will happen with multiple reports.

Please advise how to carry on and/or what may need to be done to rectify the issue

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

The Log file is from using an ODBC to connect to a DB rather than using the SQL Profiler.

Former Member
0 Kudos

Hello Don,

It does seem to be connecting to the DB before running the fetch command but does not seem to be any data being pulled back, I have tried to understand the log file as much as i can and am not certain but pretty sure of the connection and fetching data. (Attached if you want to have a look)

sql.txt

0 Kudos

Dynamic parameters require logging onto the database first before it can get the data.

Did SQL Profiler show your DB being hit to get the values?

It works for me so something in your environment is not right, check permissions and make sure it is available.

We support DB Permissions so possibly the user you are logging in under does not have rights to query that table for info.

Don