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.
Quote from: vignesvar on 11 Jun 2015 11:51:38 PM
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
Quote from: Raghuvir on 12 Jun 2015 03:00:53 AM
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
Thank you for your response reghuvir. I made it.
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?