Difference between revisions of "Reporting - Query String Parameters"
From All n One's bxp software Wixi
Philip Lacey (talk | contribs) (Created page with "= Overview = The reporting suite in Business Express contains a large amount of reports that you can use to filter your data and generate interesting graphs and charts. Som...") |
Philip Lacey (talk | contribs) |
||
| Line 20: | Line 20: | ||
The ID field depending on the report will either be passed as 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. | + | It will always be the number of the form that the data is located in, in the example below the number is 28. |
'''Example''' | '''Example''' | ||
| − | + | myform_reports.asp?ID=28 | |
''Or'' | ''Or'' | ||
| − | + | myform_reports.asp?intCampaign_Id=28 | |
| + | |||
| + | |||
| + | == 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 | ||
Revision as of 09:48, 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
