I have an application that contains nearly 100 reports written in C#.net using VS 2008 and I have been able to create most of them, often through repeated trial and error, but I am having a problem with a few reports where data either gets printed multiple times or data that is not contained in my database gets printed.

I generate the data I want to print from a SELECT statement which uses several fields on a Windows form to build the select dynamically. I then connect to my DB, pull the data I need to display, and pass the data set along with some parameters to the report. When I look at the data set before I create the report, it contains the proper information I want to put into the report, so I know my SELECT is working as I expect.

When the report viewer opens however, I get a lot of data in the report that I didn't pass into it with the data set! Often times it is the "correct" data repeated multiple times, but other times it is data that was not even contained in the data set. For example I have a situation today where I am passing 6 rows of data to the report, but the report is 224 pages long! I suspect the problem is in the way I have setup the report using the Database Expert and Links, but for the life of me I can't find anything that helps me find what I am doing wrong.

I have tried changing all of my links through trial and error, and "most" of the time I was able to stumble on the result I wanted. I have one report I am working with today that I have been fiddling with for 2 days and I can't seem to make it display the correct data.

Can anyone point me to a tutorial or article that might shed some light on what is happening here? I can post more details if someone needs them, but I was hoping someone might have some insight as where I might be able to find something that addresses this type of CR related issue.

It seems like it should be simple. If I pass the report 20 lines of information in a data set, I want it to show 20 lines...

Thanks for any information you can provide.

I'm not sure I understand where "saving data with the report" would be done. I don't see any reference to in in CR

I don't see any reference to saving data with the report, so I have not saved the data with the report. I am using VS 2008 to generate the crystal reports. Each time I try something different, the data that gets displayed changes, but it still turns a data set with perhaps 6 or 10 lines of information into 200 - 6000 pages of report...

Thanks,

I'll give it a try

my logic wasn't exact, but if you really want help, just throw this to dblank he has more experience with the various ways of utilizing CR than I do.