How to display blank row!

[rajrev]

Issue

Report without any parameter

EmpName EmpNo Activity Due Date
AAAAA 1111 Act1 1/20/2001
Act2 2/4/2002
Act3
BBBBB 2222 Act1 1/2/2002
CCCC 3333 act1 10/2/2004

Report with parameter Date Range => ?Duedate > 01/01/2001 to 01/01/2003
(Formula : ?DueDate = {emp.Due Date})

EmpName EmpNo Activity Due Date
AAAAA 1111 Act1 1/20/2001
Act2 2/4/2002
BBBBB 2222 Act1 1/2/2002
CCCC 3333 act1 10/2/2004

(Note: Here I used the formula emp.empname=previous (emp.empname) for suppress the doublicate data in Empname and EmpNo)

It is possible to display the blank (date) row ( the row which contains data except Due date)
(ie) (parameter) Due date range > 01/01/2001 to 01/01/2003, if is possible to get the following output.

EmpName EmpNo Activity Due Date
AAAAA 1111 Act1 1/20/2001
Act2 2/4/2002
Act3
BBBBB 2222 Act1 1/2/2002
Act12


Environment : 8.5, CE 8.5, SQL Server and Win XP
Please let me know if u need more info.

Thanks
MK

 

[vidru]

This will bring back all of the records without due dates as well (if you've got null values in the empty fields):

isnull({emp.Due Date}) or {emp.Due Date}in {?DueDate}

-dave

 

[synapsevampire]

Also just right click any field or formula and select Format->Suppress if duplicated instead of the previous function.

-k

 

[rajrev]

Thanks for your response.