Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

for report i have to parameters those are from_date and
to_date ,so to_date should be greater when compare to
from_date ,if we are giving to_date is less then it must
shows some error how we willmake

Answer Posted / rajesh

I have not been using reports since long back.But as per my
previous knowledge i am giving you this sugession.

We can also validate it at run time by writing small code
in 'After Parameter Form Trigger' like

If :p_from_date > :p_to_date then
srw.message(20001,'You should enter to_date > from_date');
--srw.message();
end if;

OR

If :p_from_date > :p_to_date then
return(false);
else if
return(true);
end if;

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is instead of trigger in where we will use?

1128


Explain what are the tables of auto invoice?

1098


Can we create tables in apps schema?

1086


Tell me how to debug the report?

1066


What does appl_top directory contain?

1080


Are you familiar with internet architecture of oracle apps 11i?

1018


how to print multi lay outs,muti currency,muti language in xml publisher

12156


List the various types of value set.

1024


How to move the one file from one instance to another instance? And your scripts also?

1073


what is the difference between request group and request security in oracle apps?

5797


What are the Standard Reports and Forms in HRMS?

2230


Can u give the Documentation of Custom.pll in oracle apps

3424


is it possible to run the interface without using oracle apps?

1931


What do you understand by soa?

1102


What is oracle soa suite?

1182