Add Cross Tab Report in Crystal Reports Tutorials Part-5

First let me make you clear what is Cross tab report. Normally we are generating report row wise like first we show customer name then product wise etc. But suppose we want to see report as a column wise like product name should be display as column in report then cross tab report come into picture. See result of Cross Tab report in figure 31

Figure 31

Here also I will show how to design cross tab report only, for rest of the thing refer Part-1.

First add .rpt file to the solution. Then add cross report to the Report Header section as per below figure (Refer figure 32)

Remember we can add cross tab report only in Report header or report footer section.

Figure 32

Once we click on cross tab report options it will show moving rectangle around mouse pointer just place it to the report header section.

As we click on header section it will lead to the figure 33

Figure 33

As per figure move Customer name field to the Rows  section, Product name we want to show as a Column so move it to the Columns fields, and we want to show product total so move it to the summarized fields. That’s it. Just run the report and you can see the output as figure 31.