Help with Crystal Reports

Hi, ,am fairly new to crystal reports......pretty much new...

I have a simple report that is to be done......

I need to generate a report....with columns...emp_num,name,ssn

I pull up these columns thru sql server 2000 from Employee table...

The tricky part is here....

The report has to be in such a way that...

1.)First it prompts asking if u have ssn number with u ,if yes enter the ssn no., display the name and emp_num corresponding to that,

2.)IF NO...prompt the user asking for emp_num, if yes ,enter the emp_num ,display the name and ssn corresponding to that...

I've written a stored procedure for this, but this is taking only one value..while connecting to the crystal....

Plz help me on this.......I dont think you can prompt user this way
Are you calling the report from any front end?

Help setting up an ODBC link to SQL Server From Access 2003

PLEASE HELP ME

I'm a pretty smart guy, but sometimes I end up feeling left behind with all of the terminology I don't recognize.

I am running XP Pro, Access 2003, and SQL Server 2005 express.

I want to set up a ODBC connection in Access to a table that has been created in an SQL Server 2005 Express Database.

I keep getting the message connection failed, SQL Server does not exist or access denied.

Can somebody here please help me?

Could you elaborate on how you are trying to connect? Are you using named pipes, tcp, or shared memory? Have you checked to make sure that the protocol you are trying to use to connect is enabled by your SQL Express installation?

Thanks,

John (MSFT)