Reporting - Query String Parameters
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 38 param
- 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