$(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: true, vro: true, 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

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 06, 2016 at 12:04 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 07, 2016 at 12:37 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 06, 2017 at 11:50 AM

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

    Add comment
    10|10000 characters needed characters exceeded