Home » Developer & Programmer » Reports & Discoverer » lov selecting (forms n reports 10g windows server2003)
icon4.gif  lov selecting [message #473279] Fri, 27 August 2010 03:56 Go to next message
USER20
Messages: 27
Registered: August 2010
Location: INDIA
Junior Member
Hi
I am running my report on web called through a form.
I am using paraform to get input from the users.I have an lov having more than 900 entries.
so if i wish to select India as a country i type "I" it goes to values starting with I but when i press "N" instead of showing entries with "IN" it goes to entries starting with "N".So i want is when i type "IN" it should to entries starting with "IN"

How i can incorporate that in my report lov??

I cannot un restrict that as i have more than 900 entries n when i restricting this the problem am facing...
Re: lov selecting [message #473281 is a reply to message #473279] Fri, 27 August 2010 04:21 Go to previous messageGo to next message
cookiemonster
Messages: 10572
Registered: September 2008
Location: Rainy Manchester
Senior Member
If you're calling the report from forms wouldn't it be simpler to do this in the form?
Re: lov selecting [message #473282 is a reply to message #473281] Fri, 27 August 2010 04:34 Go to previous messageGo to next message
USER20
Messages: 27
Registered: August 2010
Location: INDIA
Junior Member
I didnot understand.. Can you elaborate on that???
Re: lov selecting [message #473284 is a reply to message #473282] Fri, 27 August 2010 04:37 Go to previous messageGo to next message
cookiemonster
Messages: 10572
Registered: September 2008
Location: Rainy Manchester
Senior Member
Have the user input all necessary parameters in the form, have the LOV in the form.
Pass the values to the report.
Don't bother using reports paramform at all.

I've written lots of reports and I've never once used the paramform.
Re: lov selecting [message #473286 is a reply to message #473284] Fri, 27 August 2010 04:41 Go to previous messageGo to next message
USER20
Messages: 27
Registered: August 2010
Location: INDIA
Junior Member
Sop if i keep the parameters in the form as you are suggesting will i able to incorporate that??
Re: lov selecting [message #473288 is a reply to message #473286] Fri, 27 August 2010 04:46 Go to previous messageGo to next message
cookiemonster
Messages: 10572
Registered: September 2008
Location: Rainy Manchester
Senior Member
That what?

The LOV behaviour you say you want is standard in forms.
I would have thought it was standard in reports as well, but apparently not.
Re: lov selecting [message #473289 is a reply to message #473288] Fri, 27 August 2010 04:50 Go to previous messageGo to next message
USER20
Messages: 27
Registered: August 2010
Location: INDIA
Junior Member
Since i am new with the forms and report can you suggest me some links where i can get the required material to redesign my form
Re: lov selecting [message #473292 is a reply to message #473289] Fri, 27 August 2010 05:31 Go to previous messageGo to next message
USER20
Messages: 27
Registered: August 2010
Location: INDIA
Junior Member
Hi cookie master..

I have only one form through which i am calling 135 reports and the reports are not having uniform parameters.SO just want to confirm will yout way of sending values through form work?
Re: lov selecting [message #473293 is a reply to message #473292] Fri, 27 August 2010 05:44 Go to previous messageGo to next message
cookiemonster
Messages: 10572
Registered: September 2008
Location: Rainy Manchester
Senior Member
135?

Unless the vast majority of the parameters are uniform I wouldn't try and use one form to call them all.
Re: lov selecting [message #473294 is a reply to message #473293] Fri, 27 August 2010 05:48 Go to previous messageGo to next message
USER20
Messages: 27
Registered: August 2010
Location: INDIA
Junior Member
I know that but i cannot change that..Will it work if i replicate the calling form according to the similar parameter reports??
Re: lov selecting [message #473305 is a reply to message #473294] Fri, 27 August 2010 06:05 Go to previous messageGo to next message
cookiemonster
Messages: 10572
Registered: September 2008
Location: Rainy Manchester
Senior Member
Maybe?

You aren't really giving me a lot of information to work with here.
Is it just this report that you're having problems with or are there others?
If it's just this one then just write a seperate form to call this one.
Re: lov selecting [message #473314 is a reply to message #473305] Fri, 27 August 2010 06:23 Go to previous messageGo to next message
USER20
Messages: 27
Registered: August 2010
Location: INDIA
Junior Member
I am having a form which calls almost 135 reports and from them around 50-60 reports have lov..In some reports lov is same and in some it is changing and without making a huge change i have to incorporate the lov behaviour mentioned above.the reports are called using the report_id and the parameters are passed through after trigger in the respective reports and incorporated in the url..Paraform is turned on so the user can also enter or modify the data..As i am new with it If u still feel am missing to provide some information let me know...
Re: lov selecting [message #473348 is a reply to message #473314] Fri, 27 August 2010 08:31 Go to previous messageGo to next message
cookiemonster
Messages: 10572
Registered: September 2008
Location: Rainy Manchester
Senior Member
Well it's possible there is way of making the LOV work correclty in the paramform. I don't know what it is but others reading this might. So you can always wait and see if anyone else has anything to contribute.

Failing that you can either live with it as it is or start using forms LOVs instead.

If you're going to do the later then you're almost certainly going to need more than one form to call the reports.
However since a lot of the reports apparently use the same parameters you aren't going to need 135 forms.
How many you will need is something you're going to have to work out yourself.

A point to bear in mind is that you can hide/show items in forms programatically.
So say 50 reports need parameter A and 40 need parameter B.
You can have an item for each of parameter A and B on the form and show the correct one programatically based on the report selected.

So it could well be that you can run most of the reports off of one form and only use other forms for reports that just don't have any parameters in common with the others.
Re: lov selecting [message #473413 is a reply to message #473348] Sat, 28 August 2010 00:17 Go to previous messageGo to next message
USER20
Messages: 27
Registered: August 2010
Location: INDIA
Junior Member
thanks alot for this suggestion and guidance...I am for the time being going with the existing scenario and sideby work to develop the forms and wait if this issue gets sorted out.
Re: lov selecting [message #473435 is a reply to message #473413] Sat, 28 August 2010 05:26 Go to previous message
USER20
Messages: 27
Registered: August 2010
Location: INDIA
Junior Member
HI cookie master.

I tried what you mentioned to enter the report parameters through form on one report.But when am running it is not showing error simply white screen.

any guess where am going wrong??
Previous Topic: How to run two different Queries (merged)
Next Topic: select weeks number per months and year as 1 .....52 week on matrix report 6i (merged)
Goto Forum:
  


Current Time: Thu Apr 17 09:04:52 CDT 2014

Total time taken to generate the page: 0.05937 seconds