Hi All, I have a requirement in Infoassist where I have to provide dropdown everytime user runs a report (Auto prompt facility). Based on the selection in dropdown the report will be generated. The dropdown will have dynamic values fetched from Database view column. To achieve this I am using below code in WHERE section :
WHERE ASSET_RFP.FX_RATE_MONTHLY_VW.TO_CCY_CODE EQ '&TO_CCY_CODE.(FIND ASSET_RFP.FX_RATE_MONTHLY_VW.TO_CCY_CODE IN ASSET_RFP).To Ccy Code:.';
Here 'To Ccy Code' values are fetched from ASSET_RFP.FX_RATE_MONTHLY_VW.TO_CCY_CODE view to populate the dropdown. What I want is to add one blank value in the dropdown list at the top. If user runs the report with blank value, this filter will be skipped at the time of report generation. Is there any way to achieve this in Infoassist? Please suggest.
Thanks in advance.This message has been edited. Last edited by: Kerry,
Shankar, would you mind to share the case info with all? Thank you.
Cheers,
Kerry
Kerry Zhan Focal Point Moderator Information Builders, Inc.
March 27, 2018, 07:05 AM
Leela Krishna
Hi Shankar,
I want to create the same functionality on a business view for infoassist i.e. auto prompt a dropdown, where user need to select a value to proceed further. This selected value should be applied on the report. I am using Data management console and I have created a filter and a variable to input values to the dropdown. I have marked this filter as mandatory but still no prompt. Can you please let me know how did you accomplish this?
quote:
Originally posted by Shankar: Hi All, I have a requirement in Infoassist where I have to provide dropdown everytime user runs a report (Auto prompt facility). Based on the selection in dropdown the report will be generated. The dropdown will have dynamic values fetched from Database view column. To achieve this I am using below code in WHERE section :
WHERE ASSET_RFP.FX_RATE_MONTHLY_VW.TO_CCY_CODE EQ '&TO_CCY_CODE.(FIND ASSET_RFP.FX_RATE_MONTHLY_VW.TO_CCY_CODE IN ASSET_RFP).To Ccy Code:.';
Here 'To Ccy Code' values are fetched from ASSET_RFP.FX_RATE_MONTHLY_VW.TO_CCY_CODE view to populate the dropdown. What I want is to add one blank value in the dropdown list at the top. If user runs the report with blank value, this filter will be skipped at the time of report generation. Is there any way to achieve this in Infoassist? Please suggest.
Thanks in advance.
This message has been edited. Last edited by: Leela Krishna,