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

Answer / srini madhala

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.

what is bobble chart?

1 Answers   Syntel,

---

1.How can we driil through from a page report having query1 to list report having Query2 in master detail relationship n Drill through? 2.In database i have 50 records but when it is displayed on the report i'm getting 100 record with duplictes.How can we solve this to eliminate duplicates? 3.Exact Diff B/W Filter n Condition? 4.Render Variable? 5.I have leftouter join when right table does not have any matched records with left table what will be the output of the report whether it will be dispalying Null or blank in that particular row? 6.How to test the reports i.e Unit Testing? 7.How canwe drill through when there is no common column between the parent n child report? 8.How can we do performance tuning? I kindly request all the experts to give reply with correct answers and if possible send me some examples regarding that at srini.madhala@gmail.com

1 Answers   IBM,

---

what is Galaxy schema??

2 Answers   IBM, iGate, Wipro,

---

how u migrate reports to cognos 8 from previous versions

3 Answers   TCS,

---

What is the advantage of using shortcuts?

0 Answers  

---

What are the methods by which it non-durable model could be changed into the durable model?

0 Answers  

---

How will u execute a stored procedute from a reportstudio

2 Answers   Cap Gemini,

---

Can i apply drill through on chart in report studio?

4 Answers   TCS,

---

What do you understand by user class in cognos?

0 Answers  

---

data import to models, datastores,stored processed, is there any other way to import data?

1 Answers   TCS,

---

What do you understand by the cognos?

0 Answers  

---

How to hide value prompt box and list when run report?

4 Answers   IBM,

---