Skip to Content
avatar image
Former Member

Details appear with addition space in preview

hi,

I have a problem with showing details. Hope someone can help me out.

In design tab, all my detail's field is in the same line. However, when I preview them, those fields are in 2 different lines.

I've tried to work it out more than a month but no luck.

Any helps are really appreciated.

Thanks a lot.

designinvoice.jpg (333.3 kB)
previewinvoice.jpg (263.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 16 at 07:46 AM

    Hi Thang,

    The additional row is not being generated by CR. If you query the database table you'd see the same.

    If you need those two rows to be merged, you'd need to "group" on a common field and place fields on the Group Header/Footer instead.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      hi, I finally can fix it.

      This happened due to joining problem. The details are from 2 different tables.

      The data stream only let us do the inner join an left outer join.

      Finally, I have to delete the link, which came with data stream, and filter records by Record Expert.

      Problem solved.

      Thank you very much for helping.

  • May 16 at 08:32 AM

    What Abhilash is saying is correct, however, the problem could be a symptom of bad joins in your data set.

    For example if your field Extended Description is in another table, take a look at the join condition. Improving that might eliminate the duplications of data.

    Ian

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      hi, I finally can fix it.

      This happened due to joining problem. The details are from 2 different tables.

      The data stream only let us do the inner join an left outer join.

      Finally, I have to delete the link, which came with data stream, and filter records by Record Expert.

      Problem solved.

      Thank you very much for helping.