Create a prompt in drill through

[vignesvar]

Hi All,
[Business Namespace].[Person].[FIRST_NAME] in ?FIRST_NAME?
This is my query to initialized drill down from one source to target. This FIRST_NAME is nearly 17000 records there. While I run report I got only default 5000 records. So I can't get my remaining value when run the report. Help me to set the limits or Give some details to display only specific records to display because I don't know how to implement prompt and promptmany. Please Help me Thank you.

[Raghuvir]

Hi All,
[Business Namespace].[Person].[FIRST_NAME] in ?FIRST_NAME?
This is my query to initialized drill down from one source to target. This FIRST_NAME is nearly 17000 records there. While I run report I got only default 5000 records. So I can't get my remaining value when run the report. Help me to set the limits or Give some details to display only specific records to display because I don't know how to implement prompt and promptmany. Please Help me Thank you.

hi,

do you want to increase the records that are getting fetched in the prompt ?

Regards

[Raghuvir]

hi,

do you want to increase the records that are getting fetched in the prompt ?

Regards

there is an option "rows per page" in the properties pane. there you can increase the value.

Regards

[vignesvar]

Thank you for your response reghuvir. I made it.

[Robl]

Can you explain a little more what the problem is.

Is it to do with;
the rows displayed in a prompt.
the rows displayed in a list frame.

Or some problem with a drill through not passing the parameter correctly?