Post reply

finding char based on ascii value in Ireport

  • October 30, 2012 at 6:27 am

    #264090

    Dear All,

    How to find a ASCII characters based on the ASCII values in Ireport .. Like in Crystal Report Chr(33) used to find ! such things..Please anyone help me and thanks for in Advance..

    Regards,

    T.AnandhaKsC

  • October 30, 2012 at 9:03 am

    #1554218

    You mean like this?

    SELECT *

    FROM SomeTable

    WHERE SomeColumn LIKE '%' + CHAR(33) + '%'

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • October 30, 2012 at 10:47 pm

    #1554475

    Yes..But i need in Ireport expression..How to do it..please help me...

  • October 31, 2012 at 5:31 am

    #1554548

    anandhaksc (10/30/2012)

    Yes..But i need in Ireport expression..How to do it..please help me...

    i had not heard of iReport before your post, i was expecting a SQL related question, of course.

    i guess you'd probably need to post a question on the IReport website

    this seems to be the right place to do it:

    http://community.jaspersoft.com/answers

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply