Subject:count in XSLT, Need Help Please !!! Author:zakir tech Date:15 Dec 2008 12:50 AM
I am creating a report using a xml (Input File(Source).
In the xml I have Parents Source , Then I have ID, S_ID, Name , Discription, DATE, TIME and STATUS , For Each ID I will be having 96 DATE and TIME, some time I may have 80 or 70 also , But max count will be 96.
I am getting all the column correct in the report, now I am trying to get a new column TOTAL COUNT ( which count all the Date / Time / Status, STATUS value will be "1" by default. If I sum the STATUS.
Below is the XSLT iam trying to right , but If I use count it is displaying 2796 in each, I didn't put the whole xml here I just added 4 - 5 count here as an example.
why I am getting 2796 ( becuase I pulled 1 month i data means 31 days each day will have 96 S_ID , DATE, TIME, STATUS) so the XSLT is count 96 * 31 and displaying 2796 in each row.
The ID is also unique for 96 Measure