Cascading parameter does not retrieve all data

[Former Member]

I have cascading dynamic parameters A and B. Depending on A, B is to be retrieved.

When I run the sql in SQL+ for parameter B, there are aprox. 550 records to be displayed in B, but only 177 records are displayed. The box for turning to next page is missing too.

The select for the cascading parameters is very simple:

Select i.installation_name, p.person_name

from oa_person p,

oa_employment e,

ocs_installation i

where p.person_seq = e.person_seq

and E.CURRENTLY_EMPLOYED = 'T'

and i.inst_seq = e.inst_Seq

order by person_name

Installation_name = parameter A and Person_name is B (dependent of A).

I need help to find out why not all parameter records show in B, and why is the page box missing??

[former_member11696]

Please re-post if this is still an issue or purchase a case and have a dedicated support engineer work with you directly:

http://store.businessobjects.com/store/bobjamer/DisplayProductByTypePage&parentCategoryID=&categoryI...