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

Workshop

The quiz questions and activities are provided for your further understanding of the current hour's topics.

Quiz

1:Why would you need to surround a field or table name in quotes?
A1: You would need to surround a field or table name in quotes if it contains a space, but it's good practice to always quote both field and table names.
2:Why would you want to incorporate sorting and filtering into the SQL statement if Crystal Reports already supports those operations?
A2: By incorporating as much of the sorting and filtering logic into the SQL statement, the report will run faster because the database is always faster on these operations.
3:What does aliasing a field do?
A3: Aliasing a field gives the field a virtual name that is more user friendly or appropriate for that particular query.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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