I have rpd which was deployed in system and the reports which are in dashboards are running fine with default prompts but from the prompts like fiscal year when i try to select the list it just shows the default prompt it doesnt show the entire list, the same report is working fine in dev and it shows all the prompts.
any help or inputs please?
Are you sure that you have supporting data in the new environment that you moved your reports to?
1. Are the prompt values generated by a SQL? If so did you try running the SQL to see if there is data
2. Are you constraining(Limit Values) of the prompt? If so test that logic again in the new env and see that it works..
Can you check in the Choice List Values option as ‘Include All Column Values Choice in the List" is selected.Below the screen shot for your reference.
Mark if helps.
I didnt get you point in "Prompt values are getting generated by presentation variable defined in report" ....
Prompt is where the values will be generated (we assign them to Presentation Variable) and these are used in reports.
1. Is your prompt a column prompt, if yes is it a custom Logical SQL or a direct Presentation Column. What ever that is it should contain data,Verify this.
2. Do you have "Choice List Values" as "All Coulumn Values" or "Specific Values", if it is specific values then check what are the values and make changes accordingly.