• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Review of SQL Commands

Hour 3, “Accessing Your Data,” introduced the new SQL Commands feature of Crystal Reports 9. Let's perform a quick review of what this feature is and what advantages it has.

With reports based on tables, views, or stored procedures, Crystal Reports does the dirty work of generating a query in the background. This query incorporates which fields you have used in the report, any sorting or filtering you've applied, and even some calculations. This is one of the strengths of Crystal Reports—you need not be an expert at writing SQL to use the product. All that complexity is abstracted away from the user designing the report. However, sometimes the person developing the report is familiar with the SQL language, and perhaps is also the database administrator. In situations like this, these people often want to write their own query. This could be because of several reasons, including


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint