It's all about the answers!

Ask a question

How to get parameter as a prompt drop down with all available values of that parameter using Advanced SQL mode in Report Builder(JRS) ?


Giribabu Pragada (1126) | asked Jul 27 '16, 7:45 a.m.
edited Jul 28 '16, 2:53 a.m. by Ralph Schoon (63.1k33645)
We are trying to modify SQL query in advanced mode of report builder to make report which should ask Project Area as a input parameter in run time. We have used the following code which is using dollar symbols for this purpose according to the link "https://jazz.net/downloads/jazz-reporting-service/releases/6.0.1?p=news".

SELECT DISTINCT T1.PROJECT_NAME,
       T1.REFERENCE_ID,
       T1.NAME AS URL1_title,
       T1.URL AS URL1
FROM RIDW.VW_REQUEST T1
WHERE T1.PROJECT_NAME = '$PA$' 
 AND
(T1.ISSOFTDELETED = 0) AND
(T1.REQUEST_ID <> -1 AND T1.REQUEST_ID IS NOT NULL)

For this code we are getting prompt as we want but for the selected values we are not getting any output data even the select values had data in it. Without Putting this prompt we are getting the output for the same selected values. 

Be the first one to answer this question!


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.