Suppress Grouping Value

[darcy325]

Trying to suppress top level of Grouping on a easy employee grid listing:
Drop down Dept List: (user picks)
runs query by dept number

form shows: Job Name Employee Name

I want to supress the duplicate Job Names
Listing all employee names per Job Name

It keeps duplicating for each record received back from sql server connection.

thanks
Darcy

 

[Franck Dauché]

Hi,

Did you try to Modify your data connection to the SQL DB and "Edit SQL..."
to play with the SQl Statement?

Regards,

Franck Dauché

 

[darcy325]

I am pulling the data from a view i wrote in sql server.
here is what the data looks like. i can't figure out how
to suppress the jobname in my view.
016011 CHARGE NURSE ARNOLD ELIZABETH DIANE
016011 CHARGE NURSE BURROWS JOANNA
016011 CLINICAL DIRECTOR MILLER JANA C.
016011 HUC (NON-CERT) DANIELS CARLA K.
016011 LVN EZELL CAROLYN JOANN
The user picks the dept from my list box
then the jobname last name and first name appear.
but the jobname is still duplicated all the way down.