Jump to content

BIRT Developer Center
Download


Photo
- - - - -

Chart on single cell with multiple values


  • Please log in to reply
4 replies to this topic

#1 MikeyD

MikeyD

    Junior Member

  • Members
  • PipPip
  • 22 posts

Posted 12 May 2009 - 01:20 AM

Hi all, I have a table with the following structure: keycol1, keycol2, numcol, charcol. The character colum (charcol) contains a list of 50 values seperated by a ";". I would like to create a line chart based on these values where the x-serie is the position of the value (1 to 50). I have looked around, but could not find any solution to this. Unfortunately I can't change the database itself. I hope somebody can help me with this one. Thanks

#2 mwilliams

mwilliams

    BIRT Guru

  • Administrators
  • 13890 posts

Posted 12 May 2009 - 11:18 AM

Hi MikeyD, What kind of database are you connecting to? Can you attach some sample data so I can see what if looks like?

Regards,

Michael Williams

Actuate Corporation – The BIRT Company™

Be the first to experience the new BIRT deployment server along with giveaways, free software, food, and an open bar at the release event in San Jose on July 10th. RSVP today!
 
Find me on:
Twitter
Facebook
Blog

LinkedIn
 
Email me:
Yahoo: mwilliams_actuate@yahoo.com
Google: mwilliams.actuate@gmail.com


#3 MikeyD

MikeyD

    Junior Member

  • Members
  • PipPip
  • 22 posts

Posted 12 May 2009 - 12:43 PM

Hi Michael, I connect to a MS SQL server db, and here you have some records. The first column is the key, the second a numeric, and the third the character column with the values I need to use in a chart. 1 0.9678 "119.40286; 69.52344; 81.71848; 62.27562; 211.56694" 2 1.0402 "138.57874; 88.26634; 81.25192; 100.49358; 174.16348" 3 1.1064 "96.32898; 80.11904; 171.94168; 129.69928; 80.751" 4 1.1335 "88.5482; 77.68668; 217.79588; 113.073; 75.97006" 5 1.1072 "102.85906; 81.8013; 163.99548; 133.21422; 89.38144" 6 1.0970 "86.56494; 77.2379; 72.4721; 200.14034; 133.23152" Mikey.

#4 Bsupport

Bsupport

    Junior Member

  • Members
  • PipPip
  • 16 posts

Posted 22 May 2009 - 05:24 AM

Hi mikey,

I think you should drag the table on the report. Then add a data field to it and try using function
charcolcellvalue = charcolcellvalue.replace(";",""); on create event.
Drop the chart in the same table and the assign the new column binding value to the X-axis.

Hope this might help you,
let me know if there is any query.



Regards,
birtsupport
Reporting House: Our Focus...Your Reports

#5 MikeyD

MikeyD

    Junior Member

  • Members
  • PipPip
  • 22 posts

Posted 06 August 2009 - 04:09 AM

This works, thanks for your support!!