oracle 10g ias reports issue

hi
i  have recently migrated  forms and reports from 6i to 10g. all reports are working fine.
but few reports getting issue where we used place holder columns in the computation.
whereever we use place holder columns value is repeating the same to all records.
eg::CP_ItemOsQty := Nvl(:POsQty,0)
but when we r running rdf in 10g thru builder its showing correct value but when we run thru parameter form, its repeating the value.

do the needful

venu3108Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mark GeerlingsDatabase AdministratorCommented:
Use PL\SQL logic in a formula column to reset the place-holder columns to default (likely null) values for each record queried.  You probably have at least one formula column.  Just add lines in that column's PL\SQL block to do this work for you.  Or, if necessary, create a new formula column that doesn't need to be printed.  It just needs to reset all of the place-holder column values to whatever default value(s) you want them to have.  Without an explicit reset on each record, the place-holder columns in Oracle Reports (all versions) will carry forward a value from a previous record to the next record.
venu3108Author Commented:
hi mark

we r doing the initialization in the formula columns also.
the report is running perfectly in 6i .
but in 10g thru report builder its showing correct value but when we run thru form only , its value is not showing perfectly . ie  place colder column is  not flusing the value.



Helena Markováprogrammer-analystCommented:
Do you call reports from forms ? What does it mean "...but when we run thru form only ..." ? Is it parameter form on report server ?
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

venu3108Author Commented:
yes , i am running from a form..
in the form , when button pressed trigger, i am calling the report.

Helena Markováprogrammer-analystCommented:
How do you pass paramters to the report ?
venu3108Author Commented:
from the forms where we create the fields for the parameters.
venu3108Author Commented:
problem solved, close the ticket
Helena Markováprogrammer-analystCommented:
Congratulation ! venu3108, put here the solution and accept it as an answer.
venu3108Author Commented:
issue with placeholder columns .
thanks

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2003

From novice to tech pro — start learning today.