Reporting - Query String Parameters
From All n One's bxp software Wixi
1 Overview
The reporting suite in bxp software contains a large amount of reports that you can use to filter your data and generate interesting graphs and charts.
Sometimes you may have a report that you pull very day and you need to turn it into a single button click.
How can this be achieved when you have to select the form and enter the dates.
This can be achieved by using query string parameters.
2 Query String Parameters
There are a few main values that need to be passed to the reports in order to generate the report.
The first is the ID or intCampaign_Id.
The ID field depending on the report will either be passed as ID or intCampaign_Id.
It will always be the number of the form that the data is located in, in the example below the number is 28.
Example
myform_reports.asp?ID=28
Or
myform_reports.asp?intCampaign_Id=28
2.1 Report Date Replace Parameteres
There are two fields that can be passed to a reporting page.
They are the date fields for to and from dates for the report to run.
In the query string they are represented as dteReport_From and dteReport_To.
These two fields can be passed 39 parameters that can be passed to each field.
- Now
- All_Start
- All_End
- Yesterday_Start
- Today_Start
- Tomorrow_Start
- Yesterday_End
- Today_End
- Tomorrow_End
- LastWeek_Start
- ThisWeek_Start
- NextWeek_Start
- LastWeek_End
- ThisWeek_End
- NextWeek_End
- LastMonWeek_Start
- ThisMonWeek_Start
- NextMonWeek_Start
- LastMonWeek_End
- ThisMonWeek_End
- NextMonWeek_End
- LastMonth_Start
- ThisMonth_Start
- NextMonth_Start
- LastMonth_End
- ThisMonth_End
- NextMonth_End
- LastQuarter_Start
- ThisQuarter_Start
- NextQuarter_Start
- LastQuarter_End
- ThisQuarter_End
- NextQuarter_End
- LastYear_Start
- ThisYear_Start
- NextYear_Start
- LastYear_End
- ThisYear_End
- NextYear_End
These can be split into start dates and end dates after the underscore in each field there will either be the word start or end.
Example - Today
dteReport_From=Today_Start&dteReport_To=Today_End
Or - This Week
dteReport_From=ThisWeek_Start&dteReport_To=ThisWeek_End
Or - This Month
dteReport_From=ThisMonth_Start&dteReport_To=ThisMonth_End
URL Example
The below URL is an example of a report being generated for 28 for today.
The link is not an actual page in bxp software but is an example of how the report URL should look, everything after the question mark is valid bxp software code.
myform_reports.asp?intCampaign_Id=28&dteReport_From=Today_Start&dteReport_To=Today_End
