Skip to Content
author's profile photo Former Member
Former Member

Double rows printed from .NET DataSet - A Table Linking Issue

VS2008. SP1. CR2008. SP latest. Development issue.

I have a dataset with 4 tables. 2 tables have 1 row. 2 tables (Archive and SeqNo) have 2 rows. I manually check this using QuickWatch in Debug before I actually SHOW() the report.

I am using the latter tables for printing in the CR.

Now, when the report shows it shows 4 rows instead of the max two rows.

Archive row 1 has string "A". SeqNo row 1 has string "".

Archive row 2 has string "B". SeqNo row 2 has string "*".

The 2 other tables have 1 row of arbitrary data.

The output is this:

Archive  SeqNo
A           
B          
A           *
B           *

I was referred here from the .NET forums:

4 rows printed instead of 2 rows (only 2 rows data in DS tables)

Any help?

It could be a linking issue b/c I changed the linking and different behavior happened.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Dec 22, 2008 at 07:50 PM

    Hi Ajay,

    I agree with you that the problem is most likely with linking. How are your tables linked? Are you linking like:

    Table1 -> Table2 -> Table3 -> Table4

    If you remove 1 table, does the data duplicate? If it does then remove another table. If it still does then remove the third table.

    When the records stop duplicating that will tell you where to fix the link or that there may be duplicate records in the table.

    Good luck,

    Brian

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Brian Dong

      Well the ADO.NET DataSet (not ADO recordset) had 3 tables before, two tables with 1 row and one table with multiple rows. This caused no problem. When I added a new table with multiple rows, the exact count has the older one with multiple rows, now this problem occurs.

      This is a driving table issue.

      So there is no workaround except merging multiple row tables?

  • author's profile photo Former Member
    Former Member
    Posted on Dec 22, 2008 at 07:34 PM

    Whenever SeqNo is on the report then 4 rows are printed instead of 2!

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.