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
- 7780 Views
- I also Faced
- E-Mail Answers
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 |
hi, I want to create this report... List View--- -(Drop down list) Order Date From: \/ To: Customer Employee Order customer ------------------------------------------------------------ ------------------------------------------------------------ ------ customer c-name c-address c-phone c- city.................... ------------------------------------------------------------ ------------------------------------------------------------ ----- c-id c-type . . . ------------------------------------------------------------ ------------------------------------------------------------ ---- Employee .............same like one list Order.....................same like one list These are all in one page....i want u show... condtions *when i select in view type ex:employee and date as 10-05- 2007 to 10-05-2010 I need to go the employee list table and display the items .. And Iam trying in value prompt for creating of (cust,emp,ord)in a single value prompt,that will not created... and how to create 3-list and connection for those in value prompt.. Pls any one knows explain me (by step by step) of creating that report? Thanks Vannur
What r the names of the reports that you prepared?
How we check the errors before running the report,plz let me know the answer
How do you improve the performance of the Cognos Analytics report
Hi, I Want To Display The Report. From MOnday To Friday By Using Date Prompt.PLs Expain To Me...
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
Are you aware of any limitations in Cognos?
What is meant by Tabular SQL in Cognos Report net
What is minimum version of internet explorer to run the Cognos report.
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
wat is bus schema?
What are the different type of securities can we apply in framework manager?
Teradata 
