Hi Cognos Experts,I am Having DatePrompt In My Report.I want to display The Repo

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:

Question Posted / guest

3 Answers
6661 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Hi Cognos Experts,I am Having DatePrompt In My Report.I want to display The Report Between Twodates ..

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

Hi Cognos Experts,I am Having DatePrompt In My Report.I want to display The Report Between Twodates ..

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

Hi Cognos Experts,I am Having DatePrompt In My Report.I want to display The Report Between Twodates ..

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

Post New Answer