 lov selecting [message #473279] |
Fri, 27 August 2010 03:56  |
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 #473284 is a reply to message #473282] |
Fri, 27 August 2010 04:37  |
cookiemonster
Messages: 13920
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 #473288 is a reply to message #473286] |
Fri, 27 August 2010 04:46 |
cookiemonster
Messages: 13920
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 |
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 |
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 #473294 is a reply to message #473293] |
Fri, 27 August 2010 05:48 |
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 |
cookiemonster
Messages: 13920
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 |
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 |
cookiemonster
Messages: 13920
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 |
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 |
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??
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
