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
- 8010 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
-----------------What is Determination Model?
What is the difference between a data mart and a data warehouse?
How create measures and demensions?
What is difference between content store and content manager?
What are all the types of indexes in Cognos?
What are shortcuts? Where it can be used? What are the advantages?
Can you explain dynamic query mode?
What is the difference between Standard and Metrics folder?
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
what is requery in cognos?
What are the steps to import the two data sources in framework manager?
How to publish a package by running Java Script?
What is difference between data mart and data warehouse?
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
what is the role of cognos comsultant?what actually it means?pls reply
