Find Jobs
Hire Freelancers

Crystal Reports (Version 8.5)(repost)

$30-100 USD

Cancelado
Publicado hace más de 15 años

$30-100 USD

Pagado a la entrega
# Crystal Reports (Version 8.5) This project is for the creation of a two crystal reports. The reports must be created using Crystal Reports Version 8.5. The report will be generated from a database using an ODBC connection. A sample database and an ODBC driver will be provided together with instructions for setting up the driver and database. 1. Report #1: Manager’s Activity Report 2. Report #2: User’s Activity Report The two reports will be identical except the Manager’s Report will show activity for all users while the User’s Activity report will only show their own activity. The report will prompt for two parameters. These parameters will determine what date range is used when querying the database for the information. 1. Start Date 2. End Date ## There will be two sections of the report: **Activities Completed** ??" This section will query the activities table and print a summary of all the activities logged by a user broken down by activity type. For example: User: RMS Phone Call Made 3 Interview Scheduled 2 Email Sent 10 This means that the User ‘RMS’ logged 3 phone call activities, 2 Interview activities and 10 email sent activities. **Records Entered** ??" This section will list all the new records entered by the user. This section will be divided up into * Companies Entered * Candidates Entered * Contacts Entered The name of the record will be listed (e.g. Company Name) with the entry date and the recruited that entered the record. A subtotal will also be printed for each record type (e.g. number of companies entered). There will also need to be a total section that shows the total number of all records entered for that user. ## Deliverables ## Database information: Most of the information will be generated via ODBC to the main database. You will obtain the User Code for the currently logged in user using a second ODBC connection to a flat file database. ### **ODBC Database #1: MJSODBC** **Tables:** 1. [login to view URL] (boolean) 2. [login to view URL] (char 2) 3. [login to view URL] (char 3) 4. [login to view URL] (DateTime) <!-- --> 1. [login to view URL] (char 20) 2. [login to view URL] (char 15) 3. [login to view URL] (boolean) 4. [login to view URL] (boolean) 5. [login to view URL] (Date) 6. [login to view URL] (char 3) <!-- --> 1. [login to view URL] (char 55) 2. [login to view URL] (char 50) 3. [login to view URL] (date) 4. [login to view URL] (char 3) <!-- --> 1. [login to view URL] (char 6) 2. [login to view URL] (int) 3. [login to view URL] (char 35) <!-- --> 1. [login to view URL] (char 12) 2. [login to view URL] (char 18) 3. [login to view URL] (char 3) **Links:** 1. [login to view URL] = [login to view URL] 2. [login to view URL] = [login to view URL] 3. [login to view URL] = [login to view URL] 4. [login to view URL] = [login to view URL] ### ODBC Database #2 - MJSVAR This ODBC connection points to a tab delimited text file containing the user code of the user currently logged in and the location of the database. A sample of this file is as follows: RMS <tab> "C:\SAMPLE DATA\" ### Filters for selects: When querying the activities table, the following filters will be hard coded into the report: [login to view URL] = true [login to view URL] must equal one of the following: F,J,L,@,K,C,N,$,O,T,R,S,E, or P Both the candidates entered and contacts entered sections are generated by querying the FCAND table. A record in the FCAND table is considered a candidate when [login to view URL] = true. It is considered an contact when [login to view URL] = true. Two sample crystal reports that loosly fit the requirements above will also be provided to use as a starting point. ? ? ?
ID del proyecto: 3442110

Información sobre el proyecto

9 propuestas
Proyecto remoto
Activo hace 15 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
9 freelancers están ofertando un promedio de $73 USD por este trabajo
Avatar del usuario
See private message.
$85 USD en 41 días
4,8 (149 comentarios)
6,9
6,9
Avatar del usuario
See private message.
$80,75 USD en 41 días
4,9 (400 comentarios)
6,8
6,8
Avatar del usuario
See private message.
$76,50 USD en 41 días
4,5 (61 comentarios)
6,6
6,6
Avatar del usuario
See private message.
$85 USD en 41 días
4,9 (39 comentarios)
6,3
6,3
Avatar del usuario
See private message.
$85 USD en 41 días
4,8 (117 comentarios)
5,6
5,6
Avatar del usuario
See private message.
$34 USD en 41 días
4,3 (44 comentarios)
4,7
4,7
Avatar del usuario
See private message.
$76,50 USD en 41 días
3,8 (20 comentarios)
4,8
4,8
Avatar del usuario
See private message.
$72,25 USD en 41 días
4,4 (26 comentarios)
4,0
4,0
Avatar del usuario
See private message.
$59,49 USD en 41 días
0,0 (2 comentarios)
2,6
2,6

Sobre este cliente

Bandera de UNITED STATES
United States
5,0
2
Miembro desde jul 16, 2008

Verificación del cliente

Otros trabajos de este cliente

Job Posting Page C#
$100-500 USD
¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.