Stored procedures or a sub report..???

[acr1]

All,
I have a range of data that I need to report on as in the example as follows; Note that the SOR range is only part of the total SOR range (10000-99999)

Where the defect code = 1064 and SOR is in the range 18050 - 18999 (inclusive) then the fault code = 3133

Defect SOR Range Fault Code
1064 18050 - 18999 3133
1065 18050 - 18999 3131
1066 18050 - 18999 3200
1067 18050 - 18999 3132

Would I need to create a temporary table..that could be dropped/refreshed..??

I need this selection prior to running a report and I need to run a query based on the data in the Fault Code field

Should I use a stored procedure or a subreport prior to a main report. I am using Oracle 8i and Seagate Info Vs7.0.
I have submitted before but have become unstuck... Any help would be greatly appreciated and/or assistance with writing a stored procedure.
TIA

 

[lyanch]

I am not sure what you are asking here. What does the data look like in the tables? What does the final output you want look like?

Lisa

 

[acr1]

Hi Lisa
Currently their is no table for the above data, hence my need to create a table/stored proc/subreport..??

Currently we have a report output from a SQL query against a Oracle 8i Database. Each line item in the report has a defect code with which we wish to map a Fault code against it if it is in the specified SOR group range (as in the above example).

Hope this helps..
TIA