Dynamic Tables bind in reverse order

[Mahesh]

Hi..

My sp returns 3 datatable in a dataset. i put the dataset in loop and creates dynamic table

 for (int m = 1; m < dataSet.Tables.Count - 1; m++)
{
  Table table1 = new Table();
        DataTable data = dataSet.Tables[m];
        ...................................
        -----------------------------------
        Panel pnlPeerReviewerRecommendation = new Panel();
        pnlPeerReviewerRecommendation.Anchoring = AnchoringStyles.Left;
        table1.Anchoring = AnchoringStyles.Left;
        table1.Top = new Unit(20.0d);
        pnlPeerReviewerRecommendation.Items.Add(table1);
 }

and i'm adding this panel to another panel which i cretated in the desiger.

My issue is the tables are binding in the reverse order.

Thats is the the last table in the dataset shows first. please help me..


Thanks,
Mahesh

[Steve]

Hello Mahesh,

Specifying Location and Size for each report item is mandatory, where the Location should not match with any existing item's location, otherwise both items would overlap resulting in unexpected layout.

Greetings,
Steve
the Telerik team

[Mahesh]

Thanks Steve, for your reply.

I have one more doubt. Since the table is creating and binding dynamically, how can i mention the position of those tables? do you have any code piece for this?

Thanks,
Mahesh

[Steve]

Hello Mahesh,

When you set Location of a report item in the designer and this report item grows at runtime, the distance between the item and other items is preserved i.e. they are pushed right and below. An overlapping item can only exist at design time when you manually set a Location for two or more items that overlap.

All the best,
Steve
the Telerik team

[Adrian]

Hello Mahesh,

Please can you share me the code for creating dynamic tables inside loop.

Thanks in advance

[Stef]

Hello Adrian,

This is the response I posted in your support ticket on the same question:
"Using the Report Designer, create the desired layout for the Table item. Then extract all related objects from the report's designer.cs file. You will notice that:

1. The Table needs to have column groups and row groups defined (at least one of each)
2. The table body needs columns and rows defined (as much as the corresponding groups)
3. Each cell of the table must have an item inside of it (textbox, panel, etc...)

Based on this, you can determine which elements to be created and added in a loop, and which are required just once.

You may find useful the following help articles:

• Basic concepts
• Understanding CrossTab areas
• Understanding table cells, rows and columns

The created item can be added to the report's Items collection at run-time"


Regards,
Stef
Telerik