Rolling Totals - Parameter Passing

From All n One's bxp software Wixi

Jump to: navigation, search

Rolling Totals reports are exceptionally useful reports for providing statistical counts of records by any number of criteria and roll up headings.

To make the reports even more powerful, they have been extended to accepting information and details through the Query String.

Using a sample link

https://ww3.allnone.ie/client/client_demo/datamining/rptRollingTotals_StartDate-data.asp?intRollingTotals_Id=20&dteRollingTotals_Start=2014-05-08%2010:04:14&strGender=Male&strProblems=Bereavement


Dissecting the links parts:


URL: https://ww3.allnone.ie/client/client_demo/


Module: datamining/


Page: rptRollingTotals_StartDate-data.asp


? shows that parameters now follow & separates parameters


Parameters: intRollingTotals_Id=20 dteRollingTotals_Start=2014-05-08%2010:04:14 strGender=Male strProblems=Bereavement


intRollingTotals_Id is the Id of the Customised Group where the Rolling Totals report settings are stored. In this case report 20.


dteRollingTotals_Start is the key date around which the Rolling Totals report is generated. The %20 in the middle represents a space in the value. So the parameter will be read by BE as "2014-05-08 2010:04:14" without the double inverted commas.


It is then possible to add as many custom parameters to the fields as are required.