Hi,
I have three prompts in the report like Name, Date Range and Id.
But while running the report all the three are not required, only one is required. For that i need to create another customized value prompt with three values Name, Date range and Id. If the user selects Name then he should be redirected to name prompt, similarly if he selects date range he should be redirected to date prompt similarly for id prompt.
The selection of the prompt depends on the choice of the guy based on which prompt he wants to filter data.
Thanks,
Mark
Hi mark,
QuoteThe selection of the prompt depends on the choice of the guy based on which prompt he wants to filter data
Is this a basic requirement?
If this isnt a basic requirement create a prompt page with all three prompts and set the parameters to optional.
Or you create a report variable and three different prompt pages. Show/generate the prompt pages depend on your variable. (All three oarameters need to be optional)
Schrotty
Hi,
I have three prompts in the report like Name, Date Range and Id.
But while running the report all the three are not required, only one is required. For that i need to create another customized value prompt with three values Name, Date range and Id. If the user selects Name then he should be redirected to name prompt, similarly if he selects date range he should be redirected to date prompt similarly for id prompt.
The selection of the prompt depends on the choice of the guy based on which prompt he wants to filter data.
Thanks,
Mark
Create a filter in your query that will take the static choice prompt response into account along with the appropriate parameter and data item upon which to base the filter.
You will need to have a default value specified for all your prompt controls but these will be ignored for the choices the user does not select.
You can show a prompt page for the prompt type response (Name, Date or ID) and then conditionally render the appropriate control after that.
(
?PromptType? = 'Name'
and
[Name] = ?SelectName?
)
OR
(
?PromptType? = 'Date'
and
[Date] between ?SelectBeginDate? and ?SelectEndDate?
)
OR
(
?PromptType? = 'ID'
and
[ID] = ?SelectID?
)
Hi mark 123,
you need to create 4 prompts
1st value prompt should be with static choice with use and display values: Name, Date Range and Id.
2nd for Name, 3rd Date Range and 4th for ID.
create string variables
Add the values example(A,B,C)
take Conditional block
Select conditional block
assign string variable to conditional block (Select the Property Block variable From variable select string Click on ok)
From properties window select current block property from dropdown list select 'A'
Drag the Name prompt, drag in the conditional block.
then change the current block property to 'B'
drag the one more value prompt..
repeate it for last prompt.
hope this will help you.
Thanks
Nagendar
More double-posting!! Is it me or does there seem to be an epidemic of this lately?
http://www.cognoise.com/index.php/topic,29853.msg96894.html#msg96894
Quote from: Lynn on 19 Jan 2016 06:56:45 AM
More double-posting!! Is it me or does there seem to be an epidemic of this lately?
http://www.cognoise.com/index.php/topic,29853.msg96894.html#msg96894
mark123, please don't double-post your questions in multiple threads. Forum members might spend their valuable time trying to answer your question in one thread when it might already have been answered in another. Please read the Forum Etiquette post here (http://www.cognoise.com/index.php/topic,24030.0.html), paying close attention to point 4. I have merged your two threads into one in this instance.
MF.
Lynn, seems to be a virtual epidemic this morning. I was logged in a bit yesterday and this cropped up over night. Most if not all are new people, I have noticed, maybe it is the new year ramping up or something like that. Probably thanks to time differences, MFGF had already dealt with most of them when I logged on a few minutes back. 8)