How to input parameters from Excel ?

building reports crystal reports
1

I have an excel spreadsheet with Emp ID, Start Date and End Date as three columns. ( has roughly around 300 rows )

With an existing template in crystal for which the main data source is the Universe how can I use the spreadsheet to input the 3 (Emp ID, Start Date and End Date) parameters automatically ?

How can this be made possible and if created, where should the spreadsheet reside ( server / local )?

Crystal Reports 2008

Teradata

Thanks.

rnola (BOB member since 2006-03-26)