calling a form from a report [message #440803] |
Wed, 27 January 2010 01:24 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
charuamit
Messages: 121 Registered: January 2009
|
Senior Member |
|
|
Hi friends
I am calling a report from a form passing a specific date as a paramater.
The report runs fine in report builder;it works fine if in web.show_document - i say paraform=yes
bt if i try to select a date from a calendar and pass it as a parameter,it shows blank report.
I have tried all date format etc....bt still nthng helped...
everywhere i have set format - 'dd-mm-rr'(EVEN TRIED 'DD-MON-RR')
also from the database settings :
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET AR8MSWIN1256
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
CAN U PLEASE SUGGEST AS I HAVE SO MANY REPORTS THAT NEED TO BE CALLED FROM THE FORMS WITH DATES AS PARAMETERS
THANKS AND REGARDS
CHARU
|
|
|
|
|
|
|
|