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
- 7133 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 |
How can create users and permissions in cognos?
What is Metrics designer?
------Diff B/W DrillThrough and master and Detailed Report?
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
what is the difference between Cognos EP7 series and Congos8?
Why is auto-regression used in forecasting used on cognos platform?
what is the use of lock and unlock
wt is the differnce between Block & conditional block ?
What is the difference between Open Connection command ang Open Session Command?
What is TRAP in Framework manager?What's the use of TRAP? Where We are using this?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
What is the abrevation of .PPR? (Power play report) or anything new?
Teradata 
