VS.Net Pro & Crystal Reports...
-
Hello all, I am working with VB.Net going to an Access database. I am working with the version of Crystal that ships with VS.Net 2005 and I am trying to design a report. I have an MR number as the grouping (because I have it in all of my tables that I read). But when I preview it from within Crystal (not running my code) I get mutiple copies of the same record showing on the page. Does anyone have any idea what could cause this? Thanks for an input you can give me!!
-
Hello all, I am working with VB.Net going to an Access database. I am working with the version of Crystal that ships with VS.Net 2005 and I am trying to design a report. I have an MR number as the grouping (because I have it in all of my tables that I read). But when I preview it from within Crystal (not running my code) I get mutiple copies of the same record showing on the page. Does anyone have any idea what could cause this? Thanks for an input you can give me!!
Multiple copies of the same record in the report would mean that your SQL queries are returning those multiple copies because of some flaw in your SQL or table design. Without seeing your table design and relationships and you SQL, it's impossible to tell you where else to look.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007 -
Multiple copies of the same record in the report would mean that your SQL queries are returning those multiple copies because of some flaw in your SQL or table design. Without seeing your table design and relationships and you SQL, it's impossible to tell you where else to look.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007Thanks Dave, I mean to come post out here the I found the problem. It was with the linking of the tables. There must have been something wrong becaue I removed the links and then recreated the exact same links and this time it works. I am sure I had something wrong with them but I still don't know what it was. Thanks for you reply!!! You are always a great help!
-
Thanks Dave, I mean to come post out here the I found the problem. It was with the linking of the tables. There must have been something wrong becaue I removed the links and then recreated the exact same links and this time it works. I am sure I had something wrong with them but I still don't know what it was. Thanks for you reply!!! You are always a great help!
:-D
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007