troubleshooting Question

Complex report

Avatar of kmocampo
kmocampoFlag for Spain asked on
Oracle Database
16 Comments1 Solution871 ViewsLast Modified:
I have to do a report with a special format, i'm not an expert with Oracle Reports 6i, so I ask for help desperately!!! The report uses the following tables:

COMP
idcompc varchar2(20),            
fenvio    date,
frecep   date,
codemp number(5)

FICH
idcompc varchar2(20),
modelo  varchar2(20),
numser  varchar2(10),
obs        varchar2(30) ...

and the results must appear like this:

IDCOMPC    MODELO   NUMSER                  Jan    Feb   Mar  Apr   May  .....   Dec             OBS
                                              FENVIO                dd
                                              FRECEP                               dd

for each component (idcompc)

How can i do this? Does the query that i have to put in the data model must solve this problem? Or can i solve it through groups and other features in Oracle Reports? HELP!!!
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 16 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 16 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros