Forms & reportwriter...more help requested.
Date: Thu, 30 Sep 1993 15:36:28 GMT
Message-ID: <roleary.749403388_at_lancelot.st.nepean.uws.edu.au>
G'day,
Thanks to all those that replied to my previous post about the
problems I'm having integrating Forms and Reportwriter.
I'm trying to pass several variables from forms to reportwriter so
I can have a nice, consistent user interface.
Using the guide on page 6-2 of "Building reports with reportwriter" , I have to "Insert parameter values into a temporary table and select from this table in my report" because I have a large number of parameter values and these values can vary. Okay, since I'm in a multi-user environment, I'll have create a uniquely named table at run time and drop it when finished with it.Okay, use date and time. Here I discover you can't create tables in forms...a host call to sql*plus will be necessary. Okay, I finally work it so that all my variables, plus the table name are being passed to sql*plus, where I do a "create table &1
as select * from base_table
where field_1 like '%&2%'
and field_2 like '%&3%'
and .....
and field_12 like '%&13%';
This works fine, providing the users enter a value on the form for each of the varaibles. But if one is null, sql*plus askes for the value, and if you just press return, reads it as a null. AGHHHH!!! Users are suppose to be able to use as many of the variable fields as they feel necessary.
I've just spent the last 3 1/2 hours staying back late trying to fix this. Does anyone have any suggestions on what to do (other than me creating some standard reports and telling the users to go stick it...not a good idea as one of the users is my boss). Your comments would be most appreciated.
Cheers (it's 1:51am, I'm going home to bed...),
--
,-_|\ *********** Rocqueforte Daemaen Alexander O'Leary ***********
/ \ B.App.Sci.(Comp),BPFH,Uni. Of Western Sydney,Nepean,Australia
\_.--_/ E-Mail: roleary_at_st.nepean.uws.edu.au Work Phone: 047 360 773
o "Life^H^H^H^HHonours is a lemon and I want my money back!"
Received on Thu Sep 30 1993 - 16:36:28 CET