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:
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 |
What is the difference between macro & Parameter
fiscal year means what???
How do you improve the performance of the Cognos Analytics report
Explain about Parametermap?
Report studio has two SQL tabs one native SQL and another one cognos SQL which one is get more preference? which one we need to consider?
7 Answers Blue Cross Blue Shield Association, TCS,
what is meant by roll up and roll back in dataware housing????
4 Answers Covansys, IBM, Wipro,
Can you explain dynamic query mode?
how can you create a report like if country=india then true if contry=spain then false?
hi,dis is kumari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is vicky_ceti@yahoo.co.in hope u will respond as soon as possible. thank u in advance
my cient has reports in java and the dw mart is there already, whether you will suggest for Cognos reports ?
-------------What is a Conformed Dimension?
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?