on 12-01-2016 4:46 PM
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
The Log file is from using an ODBC to connect to a DB rather than using the SQL Profiler.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.