Duplicate table when use report parameters programmatically

[Thien]

Hello

I have issue when I use report parameters programmatically.

When I chose Category return 3 record it show 3 similar table

I want when I chose Category return 3 record it only show 1 table.

Thanks

Thien

[Stef]

Hi Thien,

Based on your screenshots, it looks like the report and the Table item are bound to the same data source.

In general, the report will produce a Detail section per record in its DataSource. Thus the Detail section will repeat, including its content - the Table item. Additionally, the Table item's DataSource is set and the item also visualizes data.

Thus you can:

1. Reset the Report's DataSource, and leave assigned only the Table.DataSource property;
2. Remove the Table item and place TextBox items directly in the report's Detail section.

I hope this information is helpful.

Regards,
Stef
Telerik

[Thien]

Thanks Stef, I resolve it!

[Sath]

This is nice, it works on mine. Great thanks guys!

[Donal]

[quote]Stef said:Hi Thien,

Based on your screenshots, it looks like the report and the Table item are bound to the same data source.

In general, the report will produce a Detail section per record in its DataSource. Thus the Detail section will repeat, including its content - the Table item. Additionally, the Table item's DataSource is set and the item also visualizes data.

Thus you can:

1. Reset the Report's DataSource, and leave assigned only the Table.DataSource property;
2. Remove the Table item and place TextBox items directly in the report's Detail section.

I hope this information is helpful.

Regards,
Stef
Telerik [/quote]
Hi Stef
I followed your instructions but file .cs from asp.net can't call datatable in Telerik Report Designer

[Neli]

Hello Donal,

Can you give us more details about the report and its scenario, so we can provide any options? Also, which version of Telerik Reporting do you use?

Regards,
Neli
Progress Telerik

[Donal]

Hi Neli,

I 'm using Telerik report version 11.1.17.503

I had a problem when I used the parameter on the webform to pass it into the telerik reporting designer, the output was displayed on a webform screen displaying 1 page but when I exported to an excel file, I got a duplicate table error.
This post helped fixing duplicate table error in Telerik Report Designer but I can't call data table from Telerik Report Designer file to load on webform.
Can You help me how to use parameter on webform to load datatable from telerik file?
Ths!

[Katia]

Hi Donal,

You can test the approach suggested in How to: Bind to a DataTable help article that explains how to use an ObjectDataSource to load the data from a DataTable.

 

Regards,
Katia
Progress Telerik