Need help with demographic report - datasources
I was hoping someone could help me along with this issue I am having.
I have a demographic report that has multiple textbox and each one would contain an average or count of data that would come from different datasources. I converted this report from Access97, it worked fine there (just fyi).
Right now the report has one List control that surrounds all the controls. Inside the control are the averages and counts that are being determined. Right now it takes forever to run the report, I am not even sure what the data looks like at this point because I give up waiting (almost an hour).
So I tried putting each control that deals with a different dataset inside each own List control and bind that list to the datasource it needs. I did that for each control. It ran but contained 2,000 pages of repeated data.
Also, I am not using this report inside a Reporting Solution, but rather I added a Report inside my existing project. Is this ideal? What would be the correct way to use reports if I need to launch a report from within my windows application?
Any help would be appreciated. This has been an issue for months now.