Column Grouping of one column and AllValues selected for other columns return System.Object[]

[n/a]

Hi Team, 

 

Please refer attached screenshot. I am trying to create CrossTab table with One column as Column Grouping.

 

Now It will look like below image -

Now I am trying see preview. It looks like - 

It's showing System.Object[] with just one row. (actually, it's has multiple rows with one batch name (grouping field) 

Please help me to resolve the issue. as soon as possible. 

 

Thank you.

 

[n/a]

It's an emergency. 

 

Please help me to resolve the issue. as soon as possible. 

 

[Momchil]

Hi Danny,

Thank you for providing screenshots of the issue.

I am assuming that your requirement here is to have the CrossTab display a new column for every "BATCHID" and list all the patients that have the same "BATCHID" in rows below the respective column. To achieve that, you can create a Crosstab with "BATCHID" as a column group and insert a Table inside the Values section of the Crosstab. The Table will show patient names and IDs, and its DataSource will be set to the DataObject of the Crosstab through a Binding.

I would suggest the following approach to achieve what I described above.

1. Add the Crosstab with "BATCHID" as a column group and put any field in the Detail Values (It will not be used but it is necessary to complete the wizard).

2. Delete the TextBox that is automatically put in the Values section of the Crosstab and insert a Table in its place.

3. Set the DataSource of the Table created in the previous step to "None", and instead bind it to the DataObject of the Crosstab.

This is what the final result looks like for me.

Additionally, if you want to stop the Tables from stretching when they have a different amount of records, you can, instead, insert a Panel item in the Values section of the Crosstab, add the Table inside the Panel, and anchor the Table to the top of the Panel.

Now, when you preview the report it will look as shown in the following screenshot.

I am attaching the sample report, for your reference.

I hope you find this example useful, and I will be glad to assist you further if any questions arise.

Best Regards,
Momchil
Progress Telerik