Insert new records into a table

[jenschmidt]

I'm not sure if this is the right place to go with this question - please redirect me if not!

I am using Crystal Reports to create reports from data based on Oracle tables. I have a VERY limited knowledge of PL/SQL and Oracle - I've built a few small scale views, that's it. I'm trying to get Crystal to do something, but I don't think it will happen, but there's a good chance Oracle can.

Here's the report:
I have a report grouped by doctor and then grouped by patient. For each doctor in the report, I have a graph that displays his/her usage of specific codes.

Here's the problem:
There are 5 codes that could be reflected on the graph, but it obviously only shows the codes the doctor actually used during the speficied time period. The end users would like to see at least a place holder for all 5 codes, even if the code wasn't used.

The main table in the report is already a view. Seems to me Oracle would have to first evaluate all the records for one doctor to determine if all 5 codes are used or not. If so, it can just reflect what's there. If not, it would need to insert a row populating the doctor's name and ID and the code(s) not used.

Is this even possible? Am I making any sense at all!?
Any suggestions or ideas would be greatly appreciated!

(Using Crystal 9.0 and Oracle 8i, upgrading to 9i early next year.)

Thank you in advance!!
Jen

jennifer.giemza@uwmf.wisc.edu

 

[nagornyi]

oops...least thing I expected is to meet you here... hand of fate... Again, let's try to resolve your problems on the level of SQL statement that does not returns all codes. If you don't like to publish the SQL, send it to vn2 at gmx dot net