Dynamic Report Creation

Hi Dimitar and  George 

I think george has need to create crosstab/Table columns dynamically with respect to his Report Data.

 I have also need the same but some issue with the crosstab  result . so that I am also question about the same 

Dynamic Colum Creation 

@george  you can also check the sample project attached in the Question 

@Dimitar kindly go through the question and if any solution is there let me know

Regards ,

 Arun KM

Dear Arun,

I checked your project I am expecting the same thing. Thank you for your valuable replay

Regards ,

George

Hi Dimitar,

Thank you for you replay. But still I cannot find the solution for my problem .

I need to dynamically create  the column  with respect the data table .Let me know what was the problem in  my code . my code is given below

Private Sub Table1_ItemDataBinding(sender As Object, e As EventArgs) Handles ctSupplierPaymentSummary.ItemDataBinding
        Try

            Dim processingTable As Telerik.Reporting.Processing.Table = (TryCast(sender, Telerik.Reporting.Processing.Table))
            Me.ctSupplierPaymentSummary.ColumnGroups.Clear()
            Me.ctSupplierPaymentSummary.RowGroups.Clear()
            Me.ctSupplierPaymentSummary.Body.Columns.Clear()
            Me.ctSupplierPaymentSummary.Body.Rows.Clear()
            Dim textboxGroup As Telerik.Reporting.TextBox
            Dim tableGroupColumn As Telerik.Reporting.TableGroup
            Dim i As Integer = 0

            Dim TableGroup2 As Telerik.Reporting.TableGroup = New Telerik.Reporting.TableGroup()
            TableGroup2.Groupings.Add(New Telerik.Reporting.Grouping(Nothing))
            TableGroup2.Name = "detail"
            Me.ctSupplierPaymentSummary.RowGroups.Add(TableGroup2)


            For Each dc In mdtResult.Columns

                tableGroupColumn = New Telerik.Reporting.TableGroup()
                Me.ctSupplierPaymentSummary.Body.Columns.Add(New Telerik.Reporting.TableBodyColumn(Unit.Inch(1)))
                textboxGroup = New Telerik.Reporting.TextBox()
                textboxGroup.Value = dc.ColumnName.ToString()
                textboxGroup.Name = dc.ColumnName.ToString()
                textboxGroup.Size = New SizeU(Unit.Inch(1.1), Unit.Inch(0.3))
                tableGroupColumn.ReportItem = textboxGroup
                ctSupplierPaymentSummary.ColumnGroups.Add(tableGroupColumn)


                Dim textBoxTable As Telerik.Reporting.TextBox
                textBoxTable = New Telerik.Reporting.TextBox()
                textBoxTable.StyleName = "Normal.TableBody"

                textBoxTable.Value = "= Fields.[" & dc.ColumnName & "]"
                ctSupplierPaymentSummary.Body.SetCellContent(0, i, textBoxTable)
                ctSupplierPaymentSummary.Items.AddRange(New ReportItemBase() {textBoxTable, textboxGroup})
                i = i + 1
            Next


            Me.ctSupplierPaymentSummary.DataSource = mdtResult
        Catch ex As Exception
            Throw ex
        End Try
    End Sub

This is my Datatable

This is my out put

In output window first column was correct ,but remaining column are wrongI need to print these datatable correctly  in .rpt file.This is what I want.

Since you are working with the processing elements, you need to at the end of the ItemDataBinding, set the table data source as follows:

 processingTable.DataSource = mdtResult;

If that doesn't work, then the design for the crosstab is probably incorrect. What you may do is the following:

1. Take sample data
2. Use that data to design the crosstab so that it looks as you expect when you preview the report in the WinForms application
3. After you have done that, all you need to do in the data binding event is set the DataSource as suggested above.

The given solution is not not working for me.

can you please correct the sample project attached below

Implementing a custom solution is out of the scope of the support service. This is a very custom scenario that is using an approach that we do not recommend. Designing tables in code should always be avoided because of cases like this one. It is hard to debug the issue and there are better ways to dynamically edit the columns.

Please consider Using Expressions, Conditional Formatting, Bindings, and User Functions instead to dynamically edit a report. These tools are typically the most productive way to build declarative reports and should be favored over using events.

The way the table is right now, it creates a column group for each column. You do not need to do that. All you need to do is to insert a new column for each ColumnName and then get its field data for the row.

If you would need me to give you further suggestions, please send me the data itself, not an image of it, so that I can test it locally.

As we have discussed so far, I will not be able to prepare a custom solution for your needs considering that such case is out of the scope of the support service. 

With that being said, going through the following articles should give you a good idea of the possible approaches that you can take:

•  How to Create a Dynamic Table/Crosstab/List item (contains a sample report)
•  How to add multiple tables dynamically based on the data source (contains a sample report)
•  How to modify table with preset styles and width dynamically

Such a custom scenario is not in the scope of the support service. With that being said, through the linked resources in previous replies, you should be able to achieve the desired result but as said earlier, it will be a much easier process if you use the Visual Studio Report Designer to design the crosstab and to then only feed it data.