I need to select the rows based on the latest 'Payment_due_date' column value. Let's say I have a Deski report with 3 columns: Payment_due_date, Cust_Name, Oustanding_Amt. Report is like this: ===================================== Payment_due_date,Cust_Name,Oustanding_Amt 02/28/11 , Bob, 115 03/31/11 , Bob, 90 02/28/11 , Mike, 120 02/28/11 , Susan, 220 05/31/11 , Bob, 80, 03/31/11 , Susan, 70 05/31/11 , Mike, 220 05/31/11 , Susan, 120 04/30/11 , Susan, 130 So,we would like to see (based on latest Payment_due_date) ================== 05/31/11 , Bob, 80, 05/31/11 , Mike, 220 05/31/11 , Susan, 120 Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe. If we use Max(Payment_due_date),we do get one row but then, the column 'Oustanding_Amt' sums up. Not allowed to use do SQL Override .Context Operators aren't working. Thanks in advance:)

3 Answers  

---

In a context can i get the data from two different factables by using the single data provider?

2 Answers   IBM,

---

what are the all possible reasons of getting partial result on a webi report?

3 Answers   L&T,

---

From Business Objects Web-I reports, we can link to other BO reports using Opendoc functinality. How do we link to reports in other reporting tool or how to give a link any website?

1 Answers  

---

How to hide the table s in webi?can any one tell me plzzzzzzzz

9 Answers   Accenture, TCS,

---

@prompt('message',['type'],[lov],[mono/multi], [free/constraint]) what is Constraint?

4 Answers   iGate,

---

hi my question is in a report table how can we write table header without using of individual cell.can we merge column cells togrther??

0 Answers  

---

What are @FUNCTION?

4 Answers  

---

What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

0 Answers  

---

How can you first report in Business Objects by using broadcast agent?

0 Answers   Ness Technologies, Wipro,

---

how can we join two classes with full outer join.in join dialog box only one outer join check box is checked another on e gone .for this any property is there in universe designer?

2 Answers   TCS,

---

There is one report running and a user wants to know whether data is from detail table or summary table. what is your approach?

1 Answers  

---