Duplicate rows in browser but no in viewer of Visual Studio 2005 Crystal Report 10

Hi,

I am using Visual Studio 2005 and Crystal Reports 10.
I have a stored procedure which correctly returns a single row when checking it in the SQL Server Studio Manager.
I created a crystal report in visual studio. When pressing PREVIEW inside the crystal report editor, all is well. One row is shown.
However, when I show that SAME cystal report in the <CR:CrystalReportViewer> control of an ASPX page in Visual Studio, run the project and view the result in the browser, for some reason, the row get duplicated.
How do I fix this? The stored procedure is ok. The preview of the report by itself is ok. What could be happending in the browser? (IE7)
DoughBoyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
Same database?

Same user?

mlmcc
0
DoughBoyAuthor Commented:
same database, same user, same everything. this is the wierdest thing i have ever seen in crystal reports. why would rendering the page in the browser cause multiple rows to appear?
0
mlmccCommented:
I don't know that is why I asked the obvious.

mlmcc
0
DoughBoyAuthor Commented:
I solved my own problem. There was a funny left outer join in the stored procedure. Some of the data in the browser was slightly different than my tests in the visual studio. All is well.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.