OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » null date

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

null date [message #672143]

Thu, 04 October 2018 05:11

shahzad-ul-hasan
Messages: 615
Registered: August 2002

Senior Member

i have a table which contains following columns.

Table Name:  Fees
Stuid   Number(5),
Chl_no  number(7),
Fmonth  varchar2(30),
Fdate   date,
fyear   number(4),

if fmonth is "october" and fdate is null then it is showing nothing in report. but when i put date in fdate column . the reports shows data. i want to shows the all report wether fdate is null or having a date.

AND isnull(fdate,date) between :fd AND :td
or 
AND fdate between isnull(:fd,date) AND inull(:td,date)

[Updated on: Thu, 04 October 2018 05:48]

Report message to a moderator

[Message index]

		null date By: shahzad-ul-hasan on Thu, 04 October 2018 05:11
		Re: null date By: cookiemonster on Thu, 04 October 2018 05:48
		Re: null date By: cookiemonster on Thu, 04 October 2018 05:50
		Re: null date By: shahzad-ul-hasan on Thu, 04 October 2018 05:54
		Re: null date By: shahzad-ul-hasan on Thu, 04 October 2018 06:31
		Re: null date By: cookiemonster on Thu, 04 October 2018 08:27
		Re: null date By: Littlefoot on Sat, 06 October 2018 01:33
		Re: null date By: shahzad-ul-hasan on Sun, 07 October 2018 21:37
		Re: null date By: BlackSwan on Sun, 07 October 2018 22:19
		Re: null date By: shahzad-ul-hasan on Sun, 07 October 2018 22:40
		Re: null date By: BlackSwan on Sun, 07 October 2018 23:13
		Re: null date By: shahzad-ul-hasan on Sun, 07 October 2018 23:19
		Re: null date By: cookiemonster on Mon, 08 October 2018 06:07
		Re: null date By: shahzad-ul-hasan on Mon, 08 October 2018 21:28

Previous Topic:	Matrix Report
Next Topic:	How to add watermark in pdf

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 14 13:03:04 CDT 2024