Report Properties - Revision history

Dgarratt at 09:38, 25 August 2024

2024-08-25T09:38:57Z

2024-08-23T10:51:17Z

← Older revision		Revision as of 12:51, 23 August 2024
Line 1:		Line 1:
	Below is an example report.		Below is an example report.

	[[file:User Reports Properties.png\|700px]]		[[file:User Reports Properties.png\|link=\|700px]]

	Lets say for example you want to export all pallets in the database in a certain date range.		Lets say for example you want to export all pallets in the database in a certain date range.

2024-08-22T09:21:21Z

← Older revision		Revision as of 11:21, 22 August 2024
Line 1:		Line 1:
	Below is an example report.		Below is an example report.

			[[file:User Reports Properties.png\|700px]]

	Lets say for example you want to export all pallets in the database in a certain date range.		Lets say for example you want to export all pallets in the database in a certain date range.
Line 45:		Line 47:
	ORDER BY DATE_OF_MANUFACTURE		ORDER BY DATE_OF_MANUFACTURE


	~~[[file:User Reports Properties.png\|700px]]~~

	If we run this report with the date range shown on the DEMO database then we should get Excel output as shown.		If we run this report with the date range shown on the DEMO database then we should get Excel output as shown.

	[[file:User Reports Excel.png\|800px]]		[[file:User Reports Excel.png\|800px]]

2024-08-22T09:20:05Z

← Older revision		Revision as of 11:20, 22 August 2024
Line 47:		Line 47:

	[[file:User Reports Properties.png\|700px]]		[[file:User Reports Properties.png\|700px]]

			If we run this report with the date range shown on the DEMO database then we should get Excel output as shown.

			[[file:User Reports Excel.png\|800px]]

2024-08-22T09:15:14Z

← Older revision		Revision as of 11:15, 22 August 2024
Line 19:		Line 19:
	You should be careful when creating queries which can return a great many rows.		You should be careful when creating queries which can return a great many rows.

	We could amend our query to look like this if we wanted to ensure that we never return more than 1000 rows.		'''''We could amend our query to look like this if we wanted to ensure that we never return more than 1000 rows.'''''

	MS SQL Server		MS SQL Server

	SELECT TOP 1000 * FROM APP_PALLET		SELECT '''''TOP 1000''''' * FROM APP_PALLET
	WHERE DATE_OF_MANUFACTURE >= ?		WHERE DATE_OF_MANUFACTURE >= ?
	AND DATE_OF_MANUFACTURE <= ?		AND DATE_OF_MANUFACTURE <= ?
Line 35:		Line 35:
	AND DATE_OF_MANUFACTURE <= ?		AND DATE_OF_MANUFACTURE <= ?
	AND CONFIRMED = 'Y'		AND CONFIRMED = 'Y'
	ORDER BY DATE_OF_MANUFACTURE LIMIT 1000		ORDER BY DATE_OF_MANUFACTURE '''''LIMIT 1000'''''

	Oracle		Oracle
Line 42:		Line 42:
	AND DATE_OF_MANUFACTURE <= ?		AND DATE_OF_MANUFACTURE <= ?
	AND CONFIRMED = 'Y'		AND CONFIRMED = 'Y'
	~~ORDER BY DATE_OF_MANUFACTURE WHERE~~ ROWNUM <= 1000		'''''AND ROWNUM <= 1000'''''
			ORDER BY DATE_OF_MANUFACTURE


	[[file:User Reports Properties.png\|700px]]		[[file:User Reports Properties.png\|700px]]

2024-08-22T09:12:25Z

@@ Line 7: / Line 7: @@
 The SQL statement we can experiment with is as follows :-
-SELECT * FROM APP_PALLET
+ SELECT * FROM APP_PALLET
 [[file:User Reports Properties.png|700px]]

2024-08-22T09:06:24Z

← Older revision		Revision as of 11:06, 22 August 2024
Line 1:		Line 1:
	Below is an example report.		Below is an example report.

			Lets say for example you want to export all pallets in the database in a certain date range.

			First of all you will need to know the names of the tables and columns in the database and to assist with this you can use the [[Schema Browser]].

			The SQL statement we can experiment with is as follows :-

			SELECT * FROM APP_PALLET

	[[file:User Reports Properties.png\|700px]]		[[file:User Reports Properties.png\|700px]]

2024-08-22T08:30:34Z

← Older revision		Revision as of 10:30, 22 August 2024
Line 1:		Line 1:
			Below is an example report.

	[[file:User Reports Properties.png\|700px]]		[[file:User Reports Properties.png\|700px]]

2024-08-22T08:29:31Z

Created page with "700px"

New page

[[file:User Reports Properties.png|700px]]