How to Hide Blank space

[rajrev]

How to Hide Blank space

I'm getting information from 2 tables for a report

TABLE1 - Empno, EmpName, Job, v.no, Startdate

TABLE2 - Empno,v.no,Startdate,Notes

Parameters - 1.Date, 2.Area and 3.EmpId

after entered the parameter values,
Date - 11/4/2003, Area - NY, EmpId- 1234

I got the result something like (Sorted by Start Date and VisitNo)

(using the suppress option, i eliminate the doublicates in all columns)

Empno Empname VisitNo Start Date Notes
1234 XXXX 10 10/01/2003 zzzzzzz

77 10/01/2003

http://wwwwwww

99 10/30/2003 ppppppp

But I need :

Empno Empname VisitNo Start Date Notes
1234 XXXX 10 10/01/2003 zzzzzzz
77 10/01/2003

http://wwwwwww

99 10/30/2003 ppppppp

Formula :
(
{t1.StartDate} <={?Date}
)

and
(
if ({?empID} <>&quot;ALL&quot then
{?empID}={t1.Empno}
else if ({?empID} =&quot;ALL&quot then
true
)

and
(
if ({?area} <> &quot;ALL&quot then
{?area}={t1.area}
else if ({?area} = &quot;ALL&quot then
true
)

Note : In the data the start date for visit no 10 and 99 are same.
I tried the DETAIL-Section Expert- select the checkbox -supress blank section, but its not working.

Any solution to &quot;hide the blank spaces&quot; is helpful for me.

Thanks in adv.

I'm using CE 8.5. CR 8.5 and Sql Server
please let me know if u need more info.

Thanks
MK

 

[synapsevampire]

You didn't specify where these fields are being displayed.

To suppress real duplicates, use Database->Select Distinct Records

-k

 

[dgillz]

SV is right on target here. The key is not to suppress records, but to SELECT only those records you want.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[rajrev]

Thank you very much for the response.
I have to work more in crystal. once again thanks for your express help.
MK

 

[lbass]

To eliminate space left by suppressed records, go to format->section->details->suppress blank section.

-LB