I want to create a PDF report like this , where i have HEADER and the value below
In this yellow boxes 'PDMS' column could go in this attribute values 
this is my FME workflow to insert HEADER but , the values / attributes are coming from Excel output , so i need to insert them in this boxes like sum / average , total count etc.
So similar to the header texts you've already added you need to add the values, per feature, below them (in the correct positions). Basically it works the same way.
So similar to the header texts you've already added you need to add the values, per feature, below them (in the correct positions). Basically it works the same way.
I tried but not successful , am attaching SAMPLE file with workbench, please if you could help
Also it would be nice to know how to highlight / bold the title and have background colour
I tried but not successful , am attaching SAMPLE file with workbench, please if you could help
You need to create a point for each feature before adding the text, that can be in an imaginary coordinate system. FME will then place that text on that location in the box you set up in the PDFPageFormatter.
Keep in mind that all the input you send to that box in the PDFPageFormatter gets scaled to the extent of the box, so choose your coordinates wisely.
Styling can be done with the PDFStyler, but keep in mind the PDF specs do not allow for more than one style per text object (so you can't make one word in a line of text bold, you'll have to split it up and position the texts precisely)