what should i do with this

[sajankk]

Are the curly brackets ( { and } ) needed for Crystal? (for normal DB work they would cause a problem).

Did the error message contain "SQL server" or was it "SQL Server" - there is a big difference, as SQL Server is a particular product, whereas a SQL server is just a database engine. Either way, if removing curly brackets doesn't work then you should check your database connection settings in Crystal.

actually what i did is... i made a report using crystal report. and in the design stage of program i insert the crystal report componet from the componect dialog box. after that right click the report control and in the properties i select the report file name. then in the command button i did the above coding. but it is showing "cannot open SQL server". no where i am mentioning database in crystal. i feel straight way am connecting to report. how can i go ahead.... removed curly then the error is "error in formula" ............... am very beginner in crystal report

saj