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
- 7176 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?
Can you define materialized view?
what is model and say about process how to create model and how to test model?
What are the themes in a data warehouse?
What do you understand by the term 'model durability'?
What do you understand by the term 'dynamic cube'?
What is main difference mapplets and mapping?
What is difference between content store and content manager?
What is the information present in the cognos configuration file?
Which lifecycle we will use for reporting?
if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
i have one file i saved in csv how can i take these file into framework manager
how to create measures and dimensions?
is cognos 7 is better than cognos 8
