Validate: not asking for second (and third) prompt value (SOLVED)

[hanfrie]

I've build a report that holds a prompt page with three mandatory prompts, where the second and third prompt have a cascading source, being the value of the first prompt ( http://www.cognoise.com/index.php/topic,25419.0.html ). When i run the report it wil do exactly what I needs to do. As the report is not yet ready I'm still adding parts. And this is where I have this problem, when I try to validate the report or some filter in a query, it comes up with the prompt page, and it asks me for the first promptvalue (=period). No issues there. But the second and third promptvalues are not being asked, and I'm not able/allowed to answer those prompts, leaving me with no other alternative then to cancel the validating process.
I have no clue in what would have caused this behavior, because I think I can remember that this was not the case when I initially created this page, so I must have changed some part somewhere, and to solve it I tried all kinds of options, removing bits and peaces in my report, but am lost. Is there a known situation that can cause this?

[MFGF]

I've build a report that holds a prompt page with three mandatory prompts, where the second and third prompt have a cascading source, being the value of the first prompt ( http://www.cognoise.com/index.php/topic,25419.0.html ). When i run the report it wil do exactly what I needs to do. As the report is not yet ready I'm still adding parts. And this is where I have this problem, when I try to validate the report or some filter in a query, it comes up with the prompt page, and it asks me for the first promptvalue (=period). No issues there. But the second and third promptvalues are not being asked, and I'm not able/allowed to answer those prompts, leaving me with no other alternative then to cancel the validating process.
I have no clue in what would have caused this behavior, because I think I can remember that this was not the case when I initially created this page, so I must have changed some part somewhere, and to solve it I tried all kinds of options, removing bits and peaces in my report, but am lost. Is there a known situation that can cause this?

Hi,

Whan you validate, it doesn't take account of cascading prompt logic, and you end up with all the prompts being rendered simultaneously on a generated page. Is it possible the second and third prompts are there but you just haven't scrolled the page down to see them?

I'd also suggest you save the report, close all your browser sessions, then log back in and open the report again - sometimes prompt values can get cached.

Cheers!

MF.

[hanfrie]

Hello (again) MFGF,

Thanks for your reply. It so happens that I was just about to revoke this post, as I was able to solve it myself. What I did to solve it, was to add a Static Choice to the first prompt, because I finally figured that the reason why both second and third were not asked was because they didn't get an answer of the first, which they both need to perform the underlying queries. And yes, now both prompts two and three were also asked, and the validation was OK. I then removed the Static Choice again from the first prompt, and tried it again, and now the validation was OK without showing me the promptpage. So i saved it all, closed the browser, started it all up again, and did another validation: now it did come up again with the prompt page, and again, couldn't get beyond prompt 1. So added the Static Choice again, and repeated the procedure of closing it all, starting again, validate, and, all is OK. So, adding the Static Choice does for me the trick here.