Interested to Buy Any Domain ? << Click Here >> for more details...
I have prompt date prompt (from and to), country and city,
how to get data from jan1/2012 to jan31-2012.
- 2 Answers
- 6679 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nagendra
create a filter in the report Query with date from and date
to parameters.
eg: date>=paramdatefrom and date<=paramdateto
When you run the report Select date prompt from jan 1 to jan
31 2012
| Is This Answer Correct ? | 8 Yes | 1 No |
For example if you are in Mar2012:-
_add_months(sysdate,-2) which takes you into Jan2012.
After this convert the _add_months(sysdate,-2) to t0_char or to_date as required.
| Is This Answer Correct ? | 0 Yes | 7 No |
write a query to display the third record from the employee table?
What are the batches and it’s details?
8. Can you use calculations in report headers and footers? How?
How do we implement Check Box Prompt in COgnos Report Studio?
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
What is diffence between query calculation and layout calculation?
hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com
how can create a report like if the salary>50,000 display balance,if salary<50,000 display green?
Which lifecycle we will use for reporting?
Can anyone explain the procedure for configuring cognos8 with oracle as Content Manager/Content Store? I know the configuration of cognos8 with SQL SERVER (Like how to create CM database in oracle and applying securities to access that Database from cognos8 (Cognos Configuration)
Give me some examples for Lifecycle reporting,i mean which lifecycle we will use for reporting
What is defined as Query studio?
Teradata 
