clulster
a category can have many cluster
as when i select a category in the pormpt
in the list values of cluster it should show only the values of those which belong to the cateogy selected in the previous prompt how can i do this
thanks
The technique you are describing is generally called a “cascading prompt” and is detailed in this entry in the Designer FAQ. In later versions (XI) the facility for creating casdading prompts is built into the application. I haven’t tested it in Webi XI but it works quite well in Crystal XI. Haven’t had access to Desktop Intelligence XI (BusinessObjects reborn in XI Rel 2) so I can’t comment on how (if) it is implemented there.
its not working out dave
i am using user responce function its not giving any thing
even if i select insert special field -query prompt
there its not showing the prompt with category
?
I expect, then, that there is something unusual about the way the prompts are set up. At the moment I can’t think of anything specific to suggest. If you can replicate the problem with an Island Resorts or eFashion report and post it here it might help.
The state value is not available as a prompt value but you can display it because it is one of the result objects. It is already in your table but if you want it displayed in a header use:
=Max()