KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

How to combine two columns in single column #3019

Open Komuraiah A opened this topic on on Mar 28, 2023 - 4 comments

Komuraiah A commented on Mar 28, 2023

Hi Team, am implementing datatable multiple columns in single column, but i can't find any related data. please help me sovle my problem. below am sharing screen shots

now data coming like this. but i need like below screenshot please help me solve the issue

AhmedHaroon commented on Mar 28, 2023

as what i understood, you need to use concatination operation here.

if you are using SQL query for your report then try MySQL CONCAT method to combine 2 or more values like below:

select CONCAT(Demo1,'/',Demo3) AS myDemo from myTable.

if not, other seniors can help.

HTH

Komuraiah A commented on Mar 28, 2023

hi AhmedHaroon Thanks for your suggestion, but am using Demo1 for the hyperlink for my subpage, so when I use the CONCAT method it will not work. can you help any other method to combine 2 columns for clickable column

AhmedHaroon commented on Mar 28, 2023

no, here is my limit :) sorry, but this can be resolved by a senior here at KoolReport forum, be patient.

David Winterburn commented on Apr 3, 2023

You can try the CalculatedColumn process to create a new column like you want:

https://www.koolreport.com/docs/processes/calculatedcolumn/#example-use-function

Let us know if you have any issue with this approach. Rgds,

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
help needed

None