Question

report builder

Rating7.8Very Good

I have a  report (rdf file) that has just one query in the data model and it produces the following output:
patient_id       ship_id       n_no      

59                  20             ahy6        
60                  21             gh67
60                  21             ---(blank)


I want to add another column to this report called t_no from table t

table t hs the foll. columns:

ship_id        b_no            t_no
20               1                 b8
20               2                 b9

21               1                 c8
21               2                 d3


Now the rule is that if the report output has just one row- for example:patient_id 59 then , just go and then both the t_no (for the ship_id - 20). and place them in 2 differnt rows like :
59      20     ahy6      b8
59      20     ahy6      b9

But if the report output has 2 rows for a patient_id (eg see patient_id 60) where one row has a n_no and the other row does not have a n_no, then associate the row with a n_no with b_no of 1 (from table t) , and then associate the row without a n_no with b_no of 2 in table t, so the output will be like:

60    21      gh67    c8
60    21                 d3


NOW UTIMATELY THE REPORT SHOULD LOOK LIKE:
59      20     ahy6      b8
59      20     ahy6      b9
60    21      gh67      c8
60    21                    d3

hOW DO I this in the report builder rdf file.
I was thinking about a formula column or something like that.
I do not want to mess with the query, since the query already
takes few minutes to run and already has about 8 other tables
in a single query...

See More

Solution

Sign up now to view this solution! It's quick, easy, and secure to subscribe. We will return you to this solution, unlocked, when you’re done.

About this Solution
View This Solution - Start Your 30 Day Free Trial
Zone
General
Tags
column builder report
Participating Experts
3
Solution Grade
A

Replies

 
by: Sara_j_11

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: schwertner

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by:

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: Sara_j_11

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: Sara_j_11

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: Henka

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: markgeer

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: Sara_j_11

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: Henka

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: RCorfman

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: RCorfman

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 
by: DarthMod

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

Stay Connected

Oracle Around the Web

The latest Oracle news, tips, and tricks

Oracle Unveils Netra SPARC T3 Servers

New Carrier-Grade Blade and Rackmount Servers Deliver Better Performance, Density and Power Efficiency for the Communications Industry ...

read more

Oracle fixes 21 flaws in Java SE, Java for Business

Oracle is fixing 21 flaws in its Java SE and Java for Business products in its February critical patch update issued this week ...

read more

Obama’s Silicon Valley “Tech Supper”

Why was he there? Who wasn’t invited and why? What did they talk about? Why was he really there? These are the questions being debated ...

read more

Featured Oracle Experts

slightwv

slightwv has answered more than 2,000 Oracle questions and oversees database management within the U.S. Government. Slightwv

sdstuber

A regular presenter at the Collaborate conference, Oracle developer sdstuber is a top expert in PL/SQL and Oracle 9, 10 and 11. sdstuber

Testimonials

What users are saying about our experts

"The Oracle gurus provide answers, solutions and valuable workarounds"

User: schwertner

"Wow! Excellent, valuable explanation. Hats off to you"

User: aseshu70

"Solution worked fantastic and performs excellent! Thanks heaps"

User: klausbrandlhuber

Top Experts

  1. slightwv

    2,000

    0 points yesterday

    Profile

BrowseBecome an Expert