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

• • 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