Answer / cognos

Take the BO report(Crystal Report) query.
Put it as a SQL inside the Report Studio.
Run and save the report

I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?

0 Answers  

---

I have to apply drill through 1,2,7 out of 10 in order method, how can i do?

1 Answers   Satyam, TCS,

---

hi my name is siraj i want to know cognos queriy language

0 Answers  

---

Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?

0 Answers   IBM,

---

How to schedule the report in Cognos? And i have 2 users u1,u2. how to schedule the report for these 2 users(the 2 users will get result once for a week) but u1 get the result on every monday to his inbox,and u2 get the result on every wednesday to his inbox.

3 Answers   UHG,

---

Hi everyone, In my report i have ten pages like page1,page2, upto page10, i have textbox prompt when i enter 1 page1 should display,when i enter 2 page2 should display,can anyone suggest the answer.

4 Answers  

---

what is dimention?explain dimentable with example?

3 Answers   Syntel,

---

WHAT ARE THE TYPES OF LIST REPORTS?

4 Answers   Patni,

---

Hi Friends, Please tell me at What situations we use the Segment, Link in FM, What is the Main Difference functionality wise? Thank You

1 Answers  

---

I would appreciate if any one answer for this, I have faced the question like this, the question was Tell me some complex reports, which u faced?

5 Answers   SAIC,

---

what type of charts we create mostly in realtime? plz help

4 Answers   IBM,

---

what are summary filters? grouped filters?

3 Answers   IBM,

---