BIP Question on providing Sum for a table
Hello...At the beginning of a report I want to provide a summary of Opportunities by Sales Rep. Here is an example of one record in XML.
- <ListOf_ssOpportunity>
- <ssOpportunity>
<ssSalesRep>SMEYERS</ssSalesRep>
<ssProjectedRevenue>245</ssProjectedRevenue>
<ssNumberOfCards>123</ssNumberOfCards>
<ssSalesStage>01-Prospect Discovery</ssSalesStage>
<ssProbability>30</ssProbability>
<ssAnnualTransactions>12</ssAnnualTransactions>
<ssBIPCreated>2013-02-28</ssBIPCreated>
</ssOpportunity>
</ListOf_ssOpportunity>
I also have 2 parameters: StartDate and EndDate that looks at ssBIPCreated.
Repeating group to start:
<?for-each-group:ssOpportunity[ssBIPCreated >= (psfn:totext($StartDate,"yyyy-MM-dd","MM/dd/yyyy")) and ssBIPCreated <= (psfn:totext($EndDate,"yyyy-MM-dd","MM/dd/yyyy"))];./ssSalesRep?>
Inside of that I have field to display total AnnaulTransactions for each Sales Rep with:
- <ListOf_ssOpportunity>
- <ssOpportunity>
<ssSalesRep>SMEYERS</ssSalesRep>
<ssProjectedRevenue>245</ssProjectedRevenue>
<ssNumberOfCards>123</ssNumberOfCards>
<ssSalesStage>01-Prospect Discovery</ssSalesStage>
<ssProbability>30</ssProbability>
<ssAnnualTransactions>12</ssAnnualTransactions>
<ssBIPCreated>2013-02-28</ssBIPCreated>
</ssOpportunity>
</ListOf_ssOpportunity>
I also have 2 parameters: StartDate and EndDate that looks at ssBIPCreated.
Repeating group to start:
<?for-each-group:ssOpportunity[ssBIPCreated >= (psfn:totext($StartDate,"yyyy-MM-dd","MM/dd/yyyy")) and ssBIPCreated <= (psfn:totext($EndDate,"yyyy-MM-dd","MM/dd/yyyy"))];./ssSalesRep?>
Inside of that I have field to display total AnnaulTransactions for each Sales Rep with:
0