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
  • 14174 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™

Instantly add interactivity, scheduling, sharing, live Excel exporting, and JavaScript integration capabilities to your BIRT application with the new, free BIRT server, BIRT iHub F-Type.
 
Find me on:
Twitter
Facebook
Blog

LinkedIn
 
Email me:
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!!