Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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:

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


Please Help Members By Posting Answers For Below Questions

how to connect datamarts

2772


Hi All, I have 1.6 years of experience in cognos in India. I always wanted to do a MS program to earn some money in US. But I think I am little late in taking the decision. As If I have to write my GRE it will be August or September of 2012 and will have to apply for fall 2013 as fall 2012 admissions are almost done now. So my concern is how will be my career do if my MS is at this stage,. i,.e. 3 years experience in Cognos and 2 years MS program in and again looking for job in U.S. Have I been too late in taking the call? I heard that MIS (Managing Information Systems) is having very good placements now. So guys, please advice me in taking the decision to have a good career and also in terms of earning money as I have few financial problems to solve (which I am hoping to solve when I get job in US after completion of my MS program). Thanks a lot friends. I really appreciate and thank one and all for their valuable comments in this site.

5227


2. What functional area you worked on.

2333


What are the steps to import the two data sources in framework manager?

1030


What is the difference b/w macros and prompt?

1099


Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

2085


All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me

2072


Write types of folders present in cognos?

1061


How can I schedule reports in cognos?

994


please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.

2175


Can you define drill down and drill up?

1023


What is the metric store database?

946


what is online view?

1927


How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?

3287


After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate

2021