$(function () { pageContext.i18n.modTalk = 'moderation talk'; pageContext.i18n.replyToComment = 'Reply'; pageContext.i18n.modTalkEmpty = 'moderation talk is empty'; pageContext.url.getModTalk = "/comments/%25ID%25/listModTalk.json"; pageContext.url.possibleCommentRecipients = "/comments/%ID%/possibleRecipients.json"; pageContext.url.commentEdit = '/comments/%25ID%25/edit.html'; pageContext.url.commentView = '/comments/%ID%/view.html'; pageContext.i18n.commentVisibility = { 'full': 'Viewable by all users', 'op': 'Viewable by the original poster', 'mod': 'Viewable by moderators', 'opAndMod': 'Viewable by moderators and the original poster', 'other': 'Advanced visibility', 'dialogTitle': 'Comment visibility', 'selectGroups': 'Visible to groups', 'selectOther': 'Other recipients', 'selectOriginalPoster': 'Original poster', 'selectModerators': 'Moderators', 'selectAssignees': 'Asked to answer users' }; pageContext.i18n.commentMenuLabels = { 'comment-edit': 'comments.menu.edit', 'comment-delete': 'comments.menu.delete', 'comment-convert': 'comments.menu.convert' };pageContext.i18n.answer= { bestAnswer: 'Best Answer', controlBar : { accept: 'Accept', unaccept: 'Unaccept', acceptCommand: 'Accept this answer as correct', cancelAcceptedCommand: 'Remove this answers accepted status' } }; window.croles = { u: false, op: false, m: false, og: false, as: false, ag: false, dc: false, doc: false, eo: false, ea: false }; tools.init({ q: { e: false, ew: false, eo: false, r: false, ro: false, d: false, dow: false, fv: false, c: false, co: false, p: false, tm: false , ms: false, mos: false }, n: { f: false, vf: false, vfo: false, vr: false, vro: false, c: false, co: false, vu: false, vd: false, w: false, wo: false, l: false }, c: { e: false, eo: false, d: false, dow: false, ta: false, tao: false, l: false }, a: { e: false, ew: false, eo: false, d: false, dow: false, a: false, aoq: false, ao: false, tc: false, tco: false, p: false, tm: false }, pc: croles }, { tc: true, nsc: true }); commandUtils.initializeLabels(); }); Skip to Content
0

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

Dec 01, 2016 at 04:46 PM

156

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Don Williams
Dec 06, 2016 at 12:04 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Oliver Marshall Dec 07, 2016 at 12:37 PM
0

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


sql.txt (187.4 kB)
Share
10 |10000 characters needed characters left characters exceeded
Oliver Marshall Jan 06, 2017 at 11:50 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded