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
  • 18 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
  • 13684 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™

If you need help with deploying BIRT and didn't find your answer here, check out the new Deployment Center.
 
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
  • 18 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
  • 18 posts

Posted 06 August 2009 - 04:09 AM

This works, thanks for your support!!