Page 1 of 1

Data Not Lining up and has a ton of duplicates

Posted: Mon Jul 08, 2024 7:25 pm
by Eddy78
What is the most effective way /option should I use to have this display as the bottom part of this screen shot. I Used Global Remove Text in the properties but that seems to work for the Loan Number and the Borrower. However, with the Description and other columns I have repeating data points like for instance this loan has 3 Credit amounts showing but It's including the blanks and the Dates and not lining up as the bottom section of the screen shot. Any suggestions/help will be highly appreciated. FYI: I did try the MIN and MAX within the Sql Query and that only displays 1 row per Description but I would like all rows for Credit, Amt Paid and Date paid displaying too.

Re: Data Not Lining up and has a ton of duplicates

Posted: Mon Jul 08, 2024 9:28 pm
by Lech Kulikowski
Hello,

Please send us a sample report with test data for analysis.

Thank you.

Re: Data Not Lining up and has a ton of duplicates

Posted: Tue Jul 09, 2024 2:49 pm
by Eddy78
Attached. Thanks

Re: Data Not Lining up and has a ton of duplicates

Posted: Wed Jul 10, 2024 7:48 am
by Lech Kulikowski
Hello,

In this case, you can use grouping and processing duplicate options.

Thank you.