Trying to add a CrossTab to a report

[Peter]

In what section of the report should a CrossTab be added?

In Crystal, we have the following CrossTab we need to convert.

{Fields.DSort1[Sort/Hidden]} Total
{Fields.A1[Display]}
{Fields.A7} {Count(Fields.A7)} {Count(Fields.A7)}
Total {Count(Fields.A7)} {Count(Fields.A7)} Is the above doable?  You provide for 4 boxes with optional groups for a crosstab.

I have tried placing the crosstab in various sections, and in all cases, the generation hangs for about 5 to 10 seconds and then renders an around 27 page report   The Crystal Reports version is only a few lines.  I have attached the result from Crystal.


We also want to pass the "Total" phrase as a field for language translation.

Peter

[Elian]

Hi Peter,

The section in which you put the Crosstab should make no difference. The Crosstab is a Data Item and has its own DataSource which means that its layout should not be dependant on the parent item. 
The following resource can help you get started with the Crosstab item:

• Product Sales Demo
• Understanding CrossTab areas
• Crosstab Videos

Greetings,
Elian
the Telerik team

[Peter]

 
It automatically assigned the same datasource as the main report.

However, I did have an extra grouping in my cross tab, but I still can't get the data to show.

Do you have a downloadable sample so I can review the code as it is defined?

Edit:  I tried having 2 datasources, one for the report and one for the crosstab.  I also tried recreating the cross tab with the wizard.  The result is shown in capture.jpg, it acts as though the crosstab isn't getting any data.  I also attached (crosstab.jpg) what it looks like within the designer.  I want to replace the "Total" phrases with fields from the recordset. 

[Stef]

Hello Peter,

The demo Product Sales per Period is also available on your machine under C:\Program Files (x86)\Telerik\Reporting Q3 2012\Examples. You can also check the video tutorial how the demo was created. You will find more information what data structure and how to place it in the Crosstab item in the following article from our online help: Understanding Crosstab areas. Please, notice that the displayed text in the Crosstab item depends on your input.
About having completely different data source for your report, you can use the created Crosstab report as a Subreport item in it, separating data. More details on creating Master-Detail Reports in this video: Reporting Subreports.

I hope this helps.

Regards,
Stef
the Telerik team

[Peter]

I have reviewed the samples and the videos but it is still not helping me get the Cross Tab to work in my situation.

My report is getting data but the Cross Tab is not.  I want to be able to have a Cross Tab in each group unique to each group, with a column group and a row group.  But then I want a final cross tab in the report footer that shows just a set of totals by my column groups.

Is more than 1 Cross Tab allowed in a report?

Thanks

[Stef]

Hi Peter,

Yes, you can use more than one Crosstab in your report as you provide well structured data in the right place. The example from this forum thread can give you ideas: Crosstab and groupings. You can add another Crosstab in the Report footer with other data source or the current report data source.
In order to help you, please further elaborate on your case:

• What is the data structure? 
• What is the grouping criteria?
• What should be displayed in the crosstab?
• What should be in the Report Footer?

All the best,
Stef
the Telerik team

[Peter]

I figured out the problem.  I am dynamically running the report by passing a DataTable to the report, as shown below:

    Public Shared Function GeneratePDF(reportDoc As Object, dtData As DataTable) As Byte()
        Dim reportProcessor As New Telerik.Reporting.Processing.ReportProcessor()
        Dim instanceReportSource As New Telerik.Reporting.InstanceReportSource()

        reportDoc.DataSource = dtData
        If reportDoc.CrossTab1 IsNot Nothing Then
            reportDoc.CrossTab1.DataSource = dtData
        End If
        instanceReportSource.ReportDocument = reportDoc

        Dim reportResults As Telerik.Reporting.Processing.RenderingResult = reportProcessor.RenderReport("PDF", instanceReportSource, Nothing)

        Return reportResults.DocumentBytes
    End Function

I had to add the bold/italic code above in order for the CrossTab to get the data.  How can I dynamically make sure the main report passes the data to the cross tab?

Thanks

Peter

[Stef]

Hello Peter,

I am glad to hear you have managed to solve the issue.
About your question, you can use the Crosstab NeedDataSource event to set the Crosstab data source to the report data source.

Let us know if you need more help.

All the best,
Stef
the Telerik team