Report running multiple times per parameter

[pmourfield]

I have a report that shows me a customer's ID, their bank, and a certain fee. When I run the report it shows the correct data in the correct format but the report repeats itself. I should only be getting back one page but I am getting back sometimes 150 pages depending on which customer parameter I choose to run the report on. Here is a simple example of the data I should be getting back.

CustomerID: 123456     Bank: BOA    Fee: $300
CustomerID: 554433     Bank: Wells Fargo     Fee: $324
CustomerID: 225676     Bank: FCU    Fee: $400

However, when I run the report, I am getting back multiple pages containing the same data, like this:

CustomerID: 123456     Bank: BOA    Fee: $300
CustomerID: 554433     Bank: Wells Fargo     Fee: $324
CustomerID: 225676     Bank: FCU    Fee: $400

CustomerID: 123456     Bank: BOA    Fee: $300
CustomerID: 554433     Bank: Wells Fargo     Fee: $324
CustomerID: 225676     Bank: FCU    Fee: $400

CustomerID: 123456     Bank: BOA    Fee: $300
CustomerID: 554433     Bank: Wells Fargo     Fee: $324
CustomerID: 225676     Bank: FCU    Fee: $400

CustomerID: 123456     Bank: BOA    Fee: $300
CustomerID: 554433     Bank: Wells Fargo     Fee: $324
CustomerID: 225676     Bank: FCU    Fee: $400



Any ideas?

[Peter]

Hello Joshua,

It seems that you have used a data item (subreport, table, list or crosstab) in the report's detail section. However the data items are a separate data region and does not make use of the report's data source. They have their own DataSource property which you have set in order to populate the item with data. However if you have in addition set the Report.DataSource property. The report engine will create a detail section instance with the data item for every row of your datasource. To avoid this behavior our suggestion is to set the Report.DataSource property to none or move the table item to another non repeating section such as report header or unbound group header (group without grouping).

Regards,
Peter
the Telerik team

[pmourfield]

Peter,

Thank you very much for your reply. That does help. I did figure out at the end of the day yesterday that if I completely removed the datasource from the main report that the data no longer repeated itself. However, it would be great if I could have that datasource available for other data on the report thus I will try your other suggestion regarding "group without grouping". Thank you again!

Josh
Developer
TaxSlayer.com