View source for Reporting - Query String Parameters

= 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.


= 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


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


[[Category:Module Specific:Data Profiling]]
[[Category:Reporting]]