Skip to main content
Topics#VisualforcePergunta de meghna m
meghna m perguntou em #Visualforce
24 de fev. de 2015, 09: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 respostas
Escrever uma resposta...
0/9000