Hi,
I need to burst the funds and nav of each banks by year. So I kept bankid and year as a master query in page set. Then trying to burst by bankid with year as a prompt.
In the page; I created a First list which will display Nav value of funds of category A ( A as a filter) of Bankid. This list is linked by master detail to page.
2nd list will display nav values of fund of category B for the same bankid. This is linked by master detail to page.
3rd list will display nav values of fund of category C for the same bankid. This is linked by master detail to page.
Now my 3rd list —category C does not have values for all banks.(bankids)
So when I burst by adding 3rd list; it is bursting only the bankids which has category C's.
What can I do so that it bursts all banks? And when category c is not there; let it give no values.
Thanks,
What query are you using to define the burst? The burst query can be completely separate from the other queries on the page, make sure that have the entire list of banks you want.