Question

Asked on 2005-08-10 at 06:58:29ID: 25470995

report builder

by: Sara_j_11250

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...

  1. oracle where is application builder icon??? or …
    oracle where is application builder icon??? or how can first database be created from the tuturial: 4 Creating a Simple Application Creating an application is an easy way to view and edit your database data. You create this application based on the EMPLOYEES table, which is part of the HR schema. To create an application based …
  2. Report Builder 6i: How to get the Group Page N…
    Hello! I have a report and I need to get the page number of the group. I mean I have a repeating frame grouped by a field. Every group may have 1,2,3,4... pages. When the group column changes the group number resets at 1, e.t.c. How can I get the page numbering of every group and display it on the layout? Thank you in advance!
  3. How to Bind an image to Link File Object at Runtim…
    How to Bind an image to q Link File Object at Runtime (Report Builder)
  4. simple report
    I want to create a report using data from multiple tables such that all data from first table appears, followed by data from second table, followed by data from third table...
  5. Report Builder Question
    I have two question regarding report builder. 1. I have a base table column in database name address and it is varchar2(60).Then I make a form like report.Format it and so it running successfully. Now after some insertions it is noted that 60 lenght is short for the complete address . Now i increase it to varchar2(200) in sql*plus. But the pr…

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
5
Solution Grade
A

Replies

 by: Sara_j_11

Posted on 2005-08-10 at 07:00:45ID: 28302911

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

Posted on 2005-08-10 at 07:16:49ID: 28302912

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:

Posted on 2005-08-10 at 08:48:41ID: 28302913

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

Posted on 2005-08-10 at 16:31:46ID: 28302914

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

Posted on 2005-08-10 at 16:32:56ID: 28302915

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

Posted on 2005-08-11 at 01:45:31ID: 28302916

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

Posted on 2005-08-11 at 06:50:51ID: 28302917

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

Posted on 2005-09-03 at 09:23:34ID: 28302918

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

Posted on 2005-09-04 at 21:49:09ID: 28302919

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

Posted on 2006-03-25 at 20:17:47ID: 28302920

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

Posted on 2006-03-25 at 20:19:27ID: 28302921

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

Posted on 2006-03-29 at 05:28:44ID: 28302922

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