Interested to Buy Any Domain ? << Click Here >> for more details...
Hi Cognos Experts,I am Having DatePrompt In My Report.I want to display The Report Between Twodates Like jan-SEP How can We Achieve This one?PLS Expain Me With Ex:
- 3 Answers
- 7853 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / modipalli
Hi,
First create two date prompts like (from date and todate)
and then apply these two prompts into report query. it
will display the data between those dates only
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / sri
In Report Studio
->Drag Date Prompt Into Work Area.
->Give Parameter Name What You Want. Then Click Next.
->Select Package Item As 'Month'. Click OK.
->Operator as 'in_range'.
->Finish.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / narasimha swamy ln
Hi,
--For in list report there is a country column data item to
need to display the data between som date to som date,
--then first u need to create, drag date prompt - name as
P_Fromdate, finish.
--& Drag one more date prompt - name as P_Todate, finish.
--now u can apply filter to ur main report query(QUERY_LIST
- WHILE DRAG A LIST IT DEFUALT CREATED)
--cursor move on qry explorer click on qry_list.
--from ther u drag country data item into detail filter
criteria...and give expression like -- [Country] between
?P_Fromdate? and ?P_Todate?
--and run report, u can select as per ur requirmnts...
| Is This Answer Correct ? | 0 Yes | 0 No |
Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?
Can you define cognos powerplay?
I would appreciate if any one answer for this, I have faced the question like this, the question was Tell me some complex reports, which u faced?
How to create a dynamic column name in Cognos?
6 Answers Aditya Birla, Polaris,
What are the steps to create DMR model in FM? Give me brienf discription as interview point of you?
what is slowly growing dimension??
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
what is meaning by Master detailed relationship ? please explain one example
what is report view?
how you create security to reports?
what is the meaning of aggregation and rollup aggregation? Difference between layout calculation and query calculation? How do you hide the rows that have null values? why we use query studio? what is the use of query studio compared to report studio?
Hi, I am Searching on Cognos 10, If any experienced person can send out a project or explain a realtime scenario that would be very helpful for me. Please be kind towards me and help me in this regard. I am really finding difficult to find a person who can guide me in this feild. Your help will be highly appriciated. My email id is asimcognos10@gmail.com. Hope you will help....
Teradata 
