Friday, 1 June 2012

How to write sql query in Crystal reports

Strange , no need to go XSD for simple reports... We can do it directly from crystal reports..... setting

How to write sql statement in CRYSTAL REPORTS :

  • Go to Field Explorer -> Database Field -> Set Database expert
  • In history your database server (any) ->  ADD Command
  • Enter your query and click finish or OK
Suppose you want to edit your sql statement

  • Again that rightclick on command "Database Expert" -> on right handwindow your command name is visible .
  • Double click on it or right click 
  • Editor will be visible
  • Again OK
Its simple some more advance thing in new crystal report version ...

Happy Coding

No comments:

Post a Comment