The proper way would be although this is c# try { DateTime dt = DateTime.Parse( txtDate.Text ); } catch(){} you could create a class and just pass the date and if its invalid don't create the object. 1 line of code equals many bugs. So don't write any!!

hi Try this piece of code! ReportDocument rptDoc = new ReportDocument(); TableLogOnInfo tblLogInf = new TableLogOnInfo(); rptDoc.Load( <Report Path> ); foreach( Table tbl in rptDoc.Database.Tables ) { tblLogInf = tbl.LogOnInfo; tblLogInf.ConnectionInfo.ServerName = <Database Server Name> tblLogInf.ConnectionInfo.DatabaseName = <Database Name> tblLogInf.ConnectionInfo.UserID = <User ID> tblLogInf.ConnectionInfo.Password = < Password> rptDoc.Database.Tables[tbl.Name].ApplyLogOnInfo(tblLogInf); rptDoc.Database.Tables[tbl.Name].Location = <Database Name> + .dbo. + tbl.Name; } Manoj 'Doing what u like is Freedom, Liking what u do is Happiness'

And what is the problem? --- b { font-weight: normal; }

Your description isn't very easy to understand. What are the primary keys of each table? What are their foreign key counterparts in other tables? ColinMackay.net "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius "If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

hi, sorry for delay Its basically sql Qn. so u should put it up in sql message board. secondly how its related with Crystal reports. Well, What i understood, You need query design tips. its inbuilt in Crystal reports. plz troubleshoot yourself. or submit it clearly.:) Any systematic work reflects its significance for a long time, Though I m not totally against "The Prototyping".So let's discuss in depth...

Given the vagueness of your request you could trying reading this article: http://msdn.microsoft.com/msdnmag/issues/03/12/DataPoints/[^] ColinMackay.net "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius "If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell