Jump to content
We've recently updated our Privacy Statement, available here ×

italize part of results in report query


carmi_cd

Recommended Posts

hi i have a sql statement that query data from MySQL database..this is executed

in my ireport program for jasperreport generation..here is my sql statement..

 

SELECT tblscipub.`PubDate` AS tblscipub_pubdate,

GROUP_CONCAT(CONCAT(tblscipub.`Article`,', ',tblscipub.`CoAuthor`,', ',

tblscipub.`Publication`,' ', tblscipub.`PubDate`,' ', tblscipub.`VolNo`,

tblscipub.`IssueNo`,tblscipub.`Pagination`) SEPARATOR '; ')

AS tblscipub_pub

FROM

`tblscipub` tblscipub

WHERE

tblscipub.`SCI_ID` = $P{SCI_ID}

GROUP BY

tblscipub.`Article`

ORDER BY

tblscipub.`PubDate` DESC

 

I used concat function to combined the fields from the table. what i want is for the publication to be italize. is there a function in MySQL sql statement to italize certain values returned by the query Concat function? or is there a way to do this in iReport?

 

thanks in advance for your help

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...