Skip to main content
Topics#Visualforcemeghna m의 질문
meghna m 님이 #Visualforce에 질문했습니다
2015년 2월 24일 오전 9:52

how to identify the same product name in a table in a visual force page

Can any one help me outhow to identify the same product name in a table in a visual force page which is in a PDF format .

For Example : Here the Product Name as "BXRC-25e4000-F-04" appears twice in a Quarter for the months Jan and Feb.Now the Quantity & Amount Should get Added displayed at one place and the product name should get appeared only once.

The Table looks like :

The Table looks like :
ProductName             Quantity          Amount     Q1      Q2  Q3  Q4 Total
BXRC-25e4000-F-04          100             5000    100,5000
BXRC-25e4000-F-04          200             3000    200,3000

The quarter is calculated as Q1 = JAN+FEB+MAR Q2= Apr+may+jun similarly other q3 and q4.

But Im looking for the Table as :

 

ProductName                  Quantity      Amount         Q1        Q2     Q3      Q4            Total 
BXRC-25e4000-F-04        300           8000       300,8000

I tried SOQL Using the Group By clause but it did not work out. Any help is very much appreciated .

답변 2개
답변을 작성하세요...
0/9000