Difference between revisions of "Reporting - Query String Parameters"
From All n One's bxp software Wixi
Philip Lacey (talk | contribs) |
Philip Lacey (talk | contribs) |
||
| Line 34: | Line 34: | ||
| − | + | *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 | |
| − | + | *LastQuarter_End | |
| − | + | *ThisQuarter_End | |
| − | + | *NextQuarter_End | |
| − | + | *LastYear_Start | |
| − | + | *ThisYear_Start | |
| − | + | *NextYear_Start | |
| − | + | *LastYear_End | |
| − | + | *ThisYear_End | |
| − | + | *NextYear_End | |
Revision as of 09:49, 30 January 2015
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
- 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
- LastQuarter_End
- ThisQuarter_End
- NextQuarter_End
- LastYear_Start
- ThisYear_Start
- NextYear_Start
- LastYear_End
- ThisYear_End
- NextYear_End
