SAP Business Objects Crystal reports on SAP HANA – Part 2

Welcome back to the Crystal reports tutorial. If you landed directly on this page without checking out Part-1, please do so before continuing here.

SAP Business Objects Crystal reports on SAP HANA (Contd…)

As we drop into the body, we see that the heading DATE also automatically appears in the “Page Header”. This “Page Header” represents your column headings. Whereas the DATE written in your body section represents the data for this DATE field.

Crystal reports


Similarly, let’s pull in the other fields also.

Let’s see how our changes here, affect the report output. As seen below, the Page header and body are left aligned by default. What if I change the alignment of one of these components?

For example, I changed the alignment of SCORE body to right, just like we do in Microsoft word.

Once done, switch to the “Page” tab to see how the layout got affected.

Crystal reports

As expected the SCORE heading is still left aligned but the data is now right aligned.

Let’s have some more fun with this. Switch back to the structure tab.

Crystal reports

Once back, Let’s select all the Page headers and make them Bold by using the (Ctrl+B) keyboard shortcut or the bold button which would be on the crystal reports design pane.

Crystal reports

Also select DATE header and body and drag it closer to the EMP_ID column. Note that there is a

Crystal reports

Do the same thing to the SCORE header and body using by dragging them closer to EMP_ID

Crystal reports

Let’s switch to the format tab now.

Crystal reports

Here you have all the options of changing font styles, font size, Bold, italics, alignments… and the rest of everything else you’ve known and loved for years.

For the sake of science and exploration, let’s select all the headers and change their font.

Crystal reports

Hmm.. lots of fonts.. Let’s pick Copperplate gothic bold. Someone must have taken a while to think of such a name. Anyways…

Crystal reports

That’s a new look…

Crystal reports

Let’s select the headers again and color it Yellow.. because.. well.. because why not?

Crystal reports

The report structure now looks as below.

Crystal reports

I can select them all and move them around for some final alignment.

Crystal reports

While we are at it, let’s select EMP_ID body and also align it to the right.

Crystal reports

Now that the report has been formatted (or converted to modern art…), let’s switch to the Page Tab to see how the final output is looking.

Crystal reports

As seen below, all the formatting we applied to the column headers (font, bold, yellow highlights) and the body (right alignments on 2 columns) have been applied.

Crystal reports



This is the beauty of crystal reports. You can align things perfectly and the structure remains constant throughout. This is perfect when you want these reports to be extracted as PDFs and sent to printers. The prints would always be precise to the millimeter.

Time to save this report now. Press the save button.

Crystal reports

It would bring up the list of folders on the Business Objects repository. In my case, I will save it to the TEACHMEHANA folder.

Select the folder and press save.

Crystal reports

This successfully publishes this report on to the repository where it is now available to everyone with access to this folder.

Your first crystal report on the HANA database is now finished.

Crystal reports

As always, I hope you could follow the instructions easily.

Please share one tutorial on social media to show your support for all the effort in bringing this to everyone – free.

<<Previous Page                                                                                                Next Tutorial>>

Content Protection by DMCA.com
Tagged , .

Leave a Reply