Reputation: 11
I just want to ask if anyone here knows a work around for this. So I've been trying to fix this for days.
I have a data from my database that looks like this:
****************************************** 11/3/2021 8:46 AM *Receipt Title *Company *Address Line *City *Building *Contact # Station POS Cashier LastName, FirstName Receipt ID ASD1001 Session 3735318968998975 1 Coca-cola $2.00 Total $2.00 VAT@10% @ 10.00%: $0.18 Payment Cash $2.00 Total Payments $2.00 Change $0.00 _________________________________________ Tax ID240F _________________________________________ Thank You and see you soon ******************************************
Note that this data is stored in a single field/column, meaning you can't break them apart unless you concatenate it which will be very hard since that's a lot of characters and it changes depending on the purchased items of course.
Now when I connected this to my Crystal Report, it will look like this: https://i.sstatic.net/VzOOD.png
and it's frustrating how this should really be a simple problem but nothing that I tried worked.
Here's what I tried so far:
Hope someone can help.
Upvotes: 0
Views: 82
Reputation: 11
Using a monospace font did the trick. Works well with changing the character spacing.
Upvotes: 0