[SOLVED] Â Reports with multiple value in one field exploded |
10/3/2018 7:34:21 PM |
PHPRunner General questions | |
W
WilliamB authorDevClub member
Hello, |
|
admin 10/5/2018 | |
You can use 'View as' Custom and replace commas with $value = str_replace(",", " |
W
|
WilliamB authorDevClub member 10/5/2018 |
I am not trying to change how the report looks. |
fhumanes 10/5/2018 | |
Hello, |
W
|
WilliamB authorDevClub member 10/5/2018 |
Hello, Check this article to see if it works. Document Regards,
|
lefty 10/5/2018 | |
This works perfectly on phpMyAdmin. I will see tonight if it works in app. Thanks!
|
W
|
WilliamB authorDevClub member 10/6/2018 |
This works perfectly on phpMyAdmin. I will see tonight if it works in app. Thanks!
|
lefty 10/7/2018 | |
I think the easiest way out here is to add another field in Insurance companies table and assign an unique ID to each insurance company . Then Group in your report on this ID then second group on client . That way the grouping will show only the insurance companies belonging to that client. If you have existing data without the ID you can run query on the database to update the Insurance companies with the correct ID. If you do that make sure you backup first for any anomalies in your query. As far a multiline/concat , Then use admin advice for view as custom for [size="2"]$value [/size] [color="#666600"][size="2"]Stored Procedure query Link[/size]
|