Reporting - Query String Parameters - Revision history

Philip Lacey at 12:22, 4 May 2015

2015-05-04T12:22:06Z

Philip Lacey at 22:19, 3 February 2015

2015-02-03T22:19:12Z

Philip Lacey at 09:05, 30 January 2015

2015-01-30T09:05:04Z

Philip Lacey at 09:03, 30 January 2015

2015-01-30T09:03:37Z

Philip Lacey at 09:02, 30 January 2015

2015-01-30T09:02:34Z

Philip Lacey at 08:53, 30 January 2015

2015-01-30T08:53:26Z

Philip Lacey at 08:49, 30 January 2015

2015-01-30T08:49:45Z

Philip Lacey at 08:48, 30 January 2015

2015-01-30T08:48:51Z

Philip Lacey at 08:48, 30 January 2015

2015-01-30T08:48:14Z

Philip Lacey: 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..."

2015-01-30T08:43:48Z

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

New page

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

'''Example'''

https://www.allnone.ie/myform_reports.asp?ID=28

''Or''

https://www.allnone.ie/myform_reports.asp?intCampaign_Id=28

← Older revision		Revision as of 12:22, 4 May 2015
Line 107:		Line 107:

	[[Category:Module Specific:Data Profiling]]		[[Category:Module Specific:Data Profiling]]
−	[[Category:Reporting]]	+	[[Category:Topic:Reporting]]

@@ Line 97: / Line 97: @@
-'''URL Example'''
+= URL Example =
 The below URL is an example of a report being generated for 28 for today.
@@ Line 104: / Line 104: @@
 myform_reports.asp?intCampaign_Id=28&dteReport_From=Today_Start&dteReport_To=Today_End

@@ Line 99: / Line 99: @@
 '''URL Example'''
-The below URL is an example of a report being pulled on for 28 for today.
+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

@@ Line 40: / Line 40: @@
 In the query string they are represented as '''dteReport_From''' and '''dteReport_To'''.
-These two fields can be passed 38 parameters that can be passed to each field.
+These two fields can be passed 39 parameters that can be passed to each field.
 *Now

@@ Line 40: / Line 40: @@
 In the query string they are represented as '''dteReport_From''' and '''dteReport_To'''.
-These two fields can be passed 38 param
+These two fields can be passed 38 parameters that can be passed to each field.
 *Now
@@ Line 81: / Line 81: @@
 *ThisYear_End
 *NextYear_End

@@ Line 33: / Line 33: @@
 == Report Date Replace Parameteres ==
 *Now
@@ Line 64: / Line 72: @@
 *ThisQuarter_Start
 *NextQuarter_Start
 *LastQuarter_End
 *ThisQuarter_End

@@ Line 34: / Line 34: @@
-**Now
+*Now
-**All_Start
+*All_Start
-**All_End
+*All_End
-**Yesterday_Start
+*Yesterday_Start
-**Today_Start
+*Today_Start
-**Tomorrow_Start
+*Tomorrow_Start
-**Yesterday_End
+*Yesterday_End
-**Today_End
+*Today_End
-**Tomorrow_End
+*Tomorrow_End
-**LastWeek_Start
+*LastWeek_Start
-**ThisWeek_Start
+*ThisWeek_Start
-**NextWeek_Start
+*NextWeek_Start
-**LastWeek_End
+*LastWeek_End
-**ThisWeek_End
+*ThisWeek_End
-**NextWeek_End
+*NextWeek_End
-**LastMonWeek_Start
+*LastMonWeek_Start
-**ThisMonWeek_Start
+*ThisMonWeek_Start
-**NextMonWeek_Start
+*NextMonWeek_Start
-**LastMonWeek_End
+*LastMonWeek_End
-**ThisMonWeek_End
+*ThisMonWeek_End
-**NextMonWeek_End
+*NextMonWeek_End
-**LastMonth_Start
+*LastMonth_Start
-**ThisMonth_Start
+*ThisMonth_Start
-**NextMonth_Start
+*NextMonth_Start
-**LastMonth_End
+*LastMonth_End
-**ThisMonth_End
+*ThisMonth_End
-**NextMonth_End
+*NextMonth_End
-**LastQuarter_Start
+*LastQuarter_Start
-**ThisQuarter_Start
+*ThisQuarter_Start
-**NextQuarter_Start
+*NextQuarter_Start
-**LastQuarter_End
+*LastQuarter_End
-**ThisQuarter_End
+*ThisQuarter_End
-**NextQuarter_End
+*NextQuarter_End
-**LastQuarter_End
+*LastQuarter_End
-**ThisQuarter_End
+*ThisQuarter_End
-**NextQuarter_End
+*NextQuarter_End
-**LastYear_Start
+*LastYear_Start
-**ThisYear_Start
+*ThisYear_Start
-**NextYear_Start
+*NextYear_Start
-**LastYear_End
+*LastYear_End
-**ThisYear_End
+*ThisYear_End
-**NextYear_End
+*NextYear_End

← Older revision		Revision as of 08:48, 30 January 2015
Line 32:		Line 32:

	== Report Date Replace Parameteres ==		== Report Date Replace Parameteres ==
		+

	**Now		**Now

@@ Line 20: / Line 20: @@
 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'''
-https://www.allnone.ie/myform_reports.asp?ID=28
+myform_reports.asp?ID=28
 ''Or''
-https://www.allnone.ie/myform_reports.asp?intCampaign_Id=28
+myform_reports.asp?intCampaign_Id=28