Now, let's create the report with SAP HANA view as the data source. We'll use the same calculation view that we used in our previous exercises (the CALC_AN_SALES view). The steps for this exercise are as follows: 

1. Launch SAP Crystal Reports.
2. Create a new server connection. Go to File | Log On To Server | Connect To Server | OK. Then, provide the credentials that are provided by your administrator (User Name and Password).
3. Click on Test connection. Enter your password and click OK.

4. Create a new report, say, z_demo_crystal_report_HANA, showing the year, state, city, sales revenue, and margin.
5. Choose New | Data source type | BusinessObjects Intelligence Platform | Browse Repository | Connect To Server | OK.
6. Select the new data source connection and then choose SAP HANA view as the data source.
7. Choose the HANA_OLAP connection, and then select Next.
8. Go to the efashion folder, select CALC_AN_SALES, and then click OK.
9. Drag the objects from the left-hand side of the result objects into the Query panel:
   • • YR 
     • State
     • Store
     • Amount sold
     • Margin

The next steps are the same ones that we used when we used the BEx query as a data source:

1. Check the Generate checkbox and select Finish.
2. Go to Insert, choose the Group button, and mark the Ascending radio button for Calendar year (you can now sort how you want).
3. Add new elements to our group to show the number of cities and total sales revenue. For that, go to the Insert tab and click the Total button. Define the new total, whether it be city, distinct count, sum of, or sales revenue.
4. Save the report to the BI platform server:
   1. Choose File | Save.
   2. Choose All Folders | My Folders | My Favorites.
   3. Give it a name and save it. This will be the name that's used automatically for the report title.
   4. In the Report Contains Saved Data dialog box, choose Save with Data.
   5. Choose File | Export | PDF.
   6. In the Export Options - PDF dialog box, ensure that the All pages radio button is selected, and then click OK. In the Export Destination dialog box, choose To Application. The PDF file will open automatically.
   7. Review the PDF file and, to close the Adobe Reader application, choose File | Exit.

5. We can make our report well-formatted and aligned by adjusting the color and layout of it. We can do this by using features such as report header and footer. I leave this for the reader to explore.
6. The report that we've created can now be viewed in the BI launchpad.