Poll
Question:
how to select months(number format 200701) from 2 value prompts
Option 1: Crosstab
votes: 0
Option 2: Reportstudio
votes: 1
Hi,
I'm working on value prompts. In these prompts contains date ie number format. When I senet the dates between the crosstab report will display the data.
i created filter that month=?period?.
shall i create two prompts? can any one explain.
Thanks is Advance
RP
Can you be more clear.Its difficult to say what are you looking for.
I understood that you have value prompt and users selects the dates.
Which is passed to Crosstab.
After that i did not get what are you looking for.
sys2674
thank you for your reply, just I want display the "in between months", in value prompt, when user slected the months. I hope this is clear for you.
Months (number format) in value prompt are like this:
200707
200706
200705
200704
200703
200702
200701
200612
200611 etc.,
when user select the data between 200701 to 200704, the four months data display.
pl let me know if you need any other info.
Thank you,
RP
1 Parameter, in 1 filter, using 1 prompt control.
Report Query Filter:
[Month] in_range ?month_Param?
Build your prompt page using the desired prompt control and be sure to select to use an existing parameter, ?month_Param?
Because we are using the in_range operator, Cognos 8 will render a value prompt that includes both From and To selections.
Thank you i'll appreciate your help
Thank you, it is working again I have a question.
In my crosstab(same) report. in left side box theare are three value prompts. While either I'm giving printing or view pdf format these prompts not visible and even prompts and data also.
could suggest me something to visible data,
In properties i changes visible 'yes' but no use.
Once agian thanks
rparcha
Prompt Controls will not render in PDF, Excel and other formats.
If you wish to see the parameter values on the report, you need to use ParamDisplayValue("param_name") layout calculation.
If you wish to keep your in-line prompts for HTML rendering, then use a Conditional Block, based on a boolean variable. The boolean variable will be set based on the reportOutput() result. Put your prompt controls in the condition that holds true if not PDF or Excel and in the false condition, use the ParamDisplayValue().
This has been covered in detail before... please do a search for that detail.
Thank you verymuch, I'll try to search and fix the error.
RP