All,
I have posted this to the data access forum as well as am unsure who reads what.....
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
I have posted this to the data access forum as well as am unsure who reads what.....
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