Data Not Lining up and has a ton of duplicates

Stimulsoft BI Designer discussion
Post Reply
Eddy78
Posts: 21
Joined: Fri May 05, 2023 4:45 pm

Data Not Lining up and has a ton of duplicates

Post 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.
Attachments
Data issue.png
Data issue.png (44.12 KiB) Viewed 428 times
Lech Kulikowski
Posts: 6538
Joined: Tue Mar 20, 2018 5:34 am

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

Post by Lech Kulikowski »

Hello,

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

Thank you.
Eddy78
Posts: 21
Joined: Fri May 05, 2023 4:45 pm

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

Post by Eddy78 »

Attached. Thanks
Attachments
ReportTest.mrt
(16.64 KiB) Downloaded 23 times
Lech Kulikowski
Posts: 6538
Joined: Tue Mar 20, 2018 5:34 am

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

Post by Lech Kulikowski »

Hello,

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

Thank you.
Attachments
ReportTest2.mrt
(17.82 KiB) Downloaded 19 times
Post Reply