I am looking for someone to create me a fully integrated Report Manager Database. There are several functions this DB please see Deliverables at the bottom for that list. The main idea of this project is for me to be able to sit down at my computer every day and be able to do 99% of my paperwork right on my computer and have the computer keep my records correct. I have included a single version of my omni form Database. This version does not have my Database attached, due to the fact that I assume you do not own omniform, so you couldnt view it. If yo have omniform I will send you the entire database. it just has a blank form, please look it over it has almost every page that is needed in my program. Some of the pages will not be needed in my program. Almost all these pages I have blank forms you can use to create forms in the program you will use to make this program. I have successfully converted these text files to Access in the past. Please contact me via RAC. This job is very important to me and my Police Department and would love to spend some time talking about it. I believe it is hard to fully understand what I am asking for.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
#1) Create and Print reports and arrest packages. “I will provide text files for or copies for each file needed to be included) ??" (I will also include the latest Omni Form version I have made, so you can extract as much data as possible). It must be able to print a complete Arrest package in order at a click of a button. #2) Create and Print Search Warrants ??" I am hoping I can give you the format needed and you can make it a template with me having the option of filling in the blanks, or in case of something wacky happening, I will need to be able to edit the document in full. #3) Create and Print Field Interview Reports ??" If you are not familiar with this term think of it as a questioner about a person. #4) View and Edit the DB. This DB will consist of several sections, depends how you design the DB. It can be designed in any fashion necessary to create the correct reports. #5) Numerous reports need to be able to be viewed and printed a click of a button. I.E number of arrests in last week. Number arrests in zone 2 last month. Number of cocaine arrests last month etc. #6) This program needs to be able to import data from two different sources. I currently have over 400 records inside several different Omni form Databases. I need to be able to extract this data and not duplicate anything in my new database. This program also will not be ran on network. It will be on our vice computer. But just in case I need to create some reports etc at the house I need to be able to save my data and then upload it to vice computer without causes duplicating and records being lost. This was one of the issues I had with Omni form. #7) Each record that contains a person will have the opportunity to contain a picture of his face, car and house. This program will need to be able to upload a pic by a browse button and store it in a location on the vice computer, so it can be viewed with the correct record. #8) This program needs to be easy to use and have as many auto fills as possible, to make things quicker to input. #9) This program needs to be able to backup its database easy or have it automatically do it daily. #10) I will provide as much data as humanly possible to assist in this project. I also volunteer my time, and will work on whatever needs to be done to gets this project to work. I am very hands and like to be kept in the loop of where the project is at. #11) This program can not be just a DB, it must be a EXE program. A program that installs professionally. I need the main screen to be slick clean looking. PLEASE DOWNLOAD THE REQUIRED FILE IT WILL BE REFERENCED BELOW. This is what I made but it is not good enough, although it has all the forms needed accept 2 that I will provide for you. If you look a lot of the forms I had to duplicate for example I made for Probable Cause forms, because narratives get long on big cases. I need this program to be able to create as many pages of Probable Cause forms needed. So once the narrative is past 2300 chr's for example it automatically creates a new form. One other thing, I don’t need this program to necessary be designed so I fill the info into the actually form? as long as I can click a button and view the actual form and when I print it is the actual form. Like if you want to create different modules. Numerous data is repeated on each form, and some forms are rarely needed. For example on a small drug arrest the only pages used are the offense page NTA page and probable cause form. Also there are numerous different ways a person for example Tim Smith, can enter the Database. He could be the victim of a report, the suspect of the report, the arrestee. He could also just be a suspicious person in which I want to enter a Field Interview Report so I have his data on file. I can be doing a search warrant on this subject’s house and have the persons enter that way. I would like each person to have a player card for example like looking at a old baseball card, follow? Where I can click their name and see their BIO info and pic and then see his stats below, which will be in reference to everytime he has been entered into the DB. So if a guy was arrested 2 times, a victim of a car theft one time and I did a warrant on his house another time it will have for lines, that if I click will bring up that specific report.
This program needs to be able to run a Windows 2000 and Windows XP machine. I need this computer to be a fully functioning program, with no need to open access or Omniform. I want to be all enclusive. I am open to the Database or the format you want to use. I am also open intrested in it being a web based system if that is feasable or a good idea. This is where I would like you the designer to be creative.