Hi Experts,
My requirement is I have a table in the below format.
| Measuring Point | Description of Measuring Point | UOM | Date | Time | Reading |
| 96 | POWER GENERATED | kwh | 20140501 | 101837 | 1.00E+04 |
| 96 | POWER GENERATED | kwh | 20140502 | 102220 | 1.00E+04 |
| 96 | POWER GENERATED | kwh | 20140503 | 104623 | 1.25E+01 |
| 96 | POWER GENERATED | kwh | 20140504 | 101111 | 2.00E+03 |
| 98 | AUX POWER CONSUME | kwh | 20140501 | 101837 | 1.00E+05 |
| 98 | AUX POWER CONSUME | kwh | 20140502 | 102220 | 1.00E+05 |
| 99 | NET POWER EXPORTED | kwh | 20140501 | 101837 | 1.00E+07 |
| 99 | NET POWER EXPORTED | kwh | 20140502 | 102220 | 1.00E+07 |
| 100 | AVG POWER GENERATED | MW | 20140501 | 101837 | 1.00E+02 |
| 100 | AVG POWER GENERATED | MW | 20140502 | 102220 | 1.00E+02 |
| 101 | AUX POWER CONSUMED(%) | % | 20140501 | 101837 | 1.00E+02 |
| 101 | AUX POWER CONSUMED(%) | % | 20140502 | 102220 | 1.01E+01 |
| 102 | PLANT AVAILABLE HRS | hrs | 20140501 | 101837 | 1.01E+01 |
| 102 | PLANT AVAILABLE HRS | hrs | 20140502 | 102220 | 1.01E+01 |
| 103 | PLANT RUN HOURS | hrs | 20140501 | 101837 | 1.01E+01 |
| 103 | PLANT RUN HOURS | hrs | 20140502 | 102220 | 1.01E+01 |
| 104 | PLANT AVAILABLITY FACTOR | % | 20140501 | 101837 | 1.00E+02 |
| 104 | PLANT AVAILABLITY FACTOR | % | 20140502 | 102220 | 1.00E+02 |
which i need to display like below based on the user Requirement for print out.
| DATE | POWER GENERATED(96) | AUX POWER CONSUME(98) | NET POWER EXPORTED(99) | AVG POWER GENERATED(100) | AUX POWER CONSUMED(%)(101) | PLANT AVAILABLE HRS(102) | PLANT RUN HOURS(103) | PLANT AVAILABLITY FACTOR(104) |
| kwh | kwh | kwh | MW | % | hrs | hrs | % | |
| 01.05.2014 | 1.00E+04 | 1.00E+05 | 1.00E+07 | 1.00E+02 | 1.00E+02 | 1.01E+01 | 1.01E+01 | 1.00E+02 |
| 02.05.2014 | 1.00E+04 | 1.00E+05 | 1.00E+07 | 1.00E+02 | 1.01E+01 | 1.01E+01 | 1.01E+01 | 1.00E+02 |
| 03.05.2014 | 1.25E+01 | | | | | | | |
| 04.05.2014 | 2.00E+03 | | | | | | | |
Now the issue is how to assign the values of stops from the internal table to dynamically for a specific date in SMARTFORMS?
Please help me in resolving this issue.
Bluesky
