In need of a simple sql report.
The purpose of the report is to show the commodities carried on a trailer within a specified time period.
The report will have a header that prints on the first page. It will contain basic information such as the report name, who printed it, parameters chosen, pages, date printed, and a logo. I have attached a pdf sample of the header. The development environment will have other completed reports from which most of the header can be copied.
Layout of the report.
The report layout will follow the design scheme from the sample report.
The report will have the following parameters. The user will be prompted for these parameters when running the report.
Select Commodities (Single Selection, Required)
Sales Cust (Multi-select Selection Box, If none is selected return ALL)
Bill To Cust (Multi-select Selection Box, If none is selected return ALL)
Shipping Cust (Multi-select Selection, If none is selected return ALL )
Consignee Cust (Multi-select Selection Box, If none is selected return ALL)
Date range of Requested Pickup From and To (Required)
Date range of Requested Drop From and To (Required)
Report Columns will be described in detail later along with the tables.
Software & Experience
Must have experience writing SQL queries and using SQL Reporting Services to create reports.
The developer will be given access to a Terminal Server where the SQL Reporting Services and Development Environment is already setup. I have the database and connection information as well as the database tables necessary for the report.
I would expect the report to take someone only a few hours.
Project due date is Jan 15th
Payment is recevied upon report completion. The report is considered complete when it can be run from the sql reporting services report manager.
35 freelancere byder i gennemsnit $120 for dette job
Hi jsbevins, The report in the pdf looks straight forward with grouping by the company. I would like to know more details about the project. Sincerely yours, John