How Do You Create A Spreadsheet In Crystal Reports?
Crystal Reports is a powerful reporting utility capable of querying a plethora of data sources. After building a report, though, it is sometimes necessary to export the result to a spreadsheet application for further sorting, grouping, and massaging of data. Learn how to create such a spreadsheet using the Crystal Reports application. Build the report. To create a report showing useful data, you must have a basic knowledge of Crystal Reports and of the database you are querying. Build the report by connecting to the data source, selecting the fields you want to include in the report, and dragging those fields to the “Details” section of the Crystal Reports design view. You may perform grouping and data selection as necessary. Refresh the report. Once the report is designed in Crystal Reports, click the “Refresh” icon (the refresh icon on the toolbar looks similar to a lightning bolt). Crystal Reports will connect to the data source and retrieve all applicable records in order to create