Em Andamento

Crystal Report from Oracle - #1

We have an ODBC accessible Oracle 8i (in compatibility mode) database we use to drive a web site.

It contains three tables that are relevant to this report:

1) Classes - Classes are like products in our workflow and do not contain a specific event date or location - key is Class_ID

2) Events - Events are specific, scheduled occurrences of classes and contain both a location and a date - key is Event_ID

3) Locations - Classroom locations - key is Location_ID

We need a report that delivers a running projection for the next 12 months (current plus next 11) with the number of events scheduled for each class ID each month, with a total also broken down by location.

For example

Jan

Total Loc 1 Loc 2 Loc 3

Photoshop 7 2 2 3

Illustrator 5 1 2 2

The total values will have to be color coded so that locations that have 0 classes scheduled in a month show a red background and others show a light blue background.

Optionally if it's easy, we'd like to be able to drill down into specific dates, but the collapsed report would simply have the number of events scheduled for each location.

## Deliverables

1) Complete and fully-functional working Crystal Report form in Crystal Report form as well as complete source code of all work done.

2) Exclusive and complete copyrights to all work purchased.

## Platform

Windows Crystal Reports 9

Habilidades: Administração de Bancos de Dados, Engenharia, MySQL, Oracle, PHP, Arquitetura de software, Teste de Software, SQL

Ver mais: php odbc oracle, photoshop windows, report example, oracle reports, oracle functional, loc, database oracle, crystal, engineering work report, report done, compatibility mode, web crystal reports, odbc code, windows oracle, crystal report odbc, oracle form report, oracle report form, event report, crystal web reports, crystal reports photoshop, photoshop work light, broken windows, background report engineering, oracle windows, report background

Acerca do Empregador:
( 0 comentários ) Atlanta, United States

ID do Projeto: #2991705

Premiar a:

sreeyavw

See private message.

$106.25 USD em 67 dias
(31 Avaliações)
5.1

14 freelancers estão ofertando em média $145 para este trabalho

debihammel

See private message.

$127.5 USD in 67 dias
(39 Comentários)
6.5
agrasth

See private message.

$127.5 USD in 67 dias
(107 Comentários)
6.2
vw474134vw

See private message.

$212.5 USD in 67 dias
(3 Comentários)
4.2
gbltechnologies

See private message.

$191.25 USD in 67 dias
(11 Comentários)
3.8
adithyasoftware

See private message.

$127.5 USD in 67 dias
(4 Comentários)
3.4
cdaga

See private message.

$255 USD in 67 dias
(5 Comentários)
3.0
vw759019vw

See private message.

$161.5 USD in 67 dias
(15 Comentários)
3.3
hazels

See private message.

$85 USD in 67 dias
(4 Comentários)
2.2
etsvw

See private message.

$170 USD in 67 dias
(0 Comentários)
0.0
ployber

See private message.

$85 USD in 67 dias
(1 Comentário)
0.0
abelgabor

See private message.

$85 USD in 67 dias
(0 Comentários)
0.0
crystalreports

See private message.

$85 USD in 67 dias
(0 Comentários)
0.0
comsdevvw

See private message.

$212.5 USD in 67 dias
(3 Comentários)
2.7