Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » how to display all datas in line chart
how to display all datas in line chart [message #551676] Mon, 09 August 2010 02:58 Go to next message
Rong Yi is currently offline Rong Yi
Messages: 2
Registered: April 2010
Location: Beijing, China
Junior Member

Hi!
I create a line chart. Data of X axis is connected to timestamps which are string type like "1100804032005000". I converted them to date type like 10-8-4 3:20:05 in category X series expression build using expression:

new Date( parseInt("1"+row["Timestamp"].substring(1,3)) - 100 + 2000,
parseInt("1"+row["Timestamp"].substring(3,5)) - 100 - 1,
parseInt("1"+row["Timestamp"].substring(5,7)) - 100,
parseInt("1"+row["Timestamp"].substring(7,9)) - 100,
parseInt("1"+row["Timestamp"].substring(9,11)) - 100,
parseInt("1"+row["Timestamp"].substring(11,13)) - 100 )

The timestamp ranges from 10-8-4 3:20:05 to 10-8-7 3:20:05 by step 5 minutes.

When I preview my chart, I find only datas from 10-8-4 3:20:05 to 10-8-4 19:20:05 are displayed but other datas not. I don't know what is wrong and how to solve the broblem. Any help will be appreciated!
Re: how to display all datas in line chart [message #551804 is a reply to message #551676] Mon, 09 August 2010 11:26 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Any chance you can convert your report to use a scripted dataset so we
can run it and test it?

Jason

On 8/9/2010 2:58 AM, Rong Yi wrote:
> Hi!
> I create a line chart. Data of X axis is connected to timestamps which
> are string type like "1100804032005000". I converted them to date type
> like 10-8-4 3:20:05 in category X series expression build using expression:
>
> new Date( parseInt("1"+row["Timestamp"].substring(1,3)) - 100 + 2000,
> parseInt("1"+row["Timestamp"].substring(3,5)) - 100 - 1,
> parseInt("1"+row["Timestamp"].substring(5,7)) - 100,
> parseInt("1"+row["Timestamp"].substring(7,9)) - 100,
> parseInt("1"+row["Timestamp"].substring(9,11)) - 100,
> parseInt("1"+row["Timestamp"].substring(11,13)) - 100 )
>
> The timestamp ranges from 10-8-4 3:20:05 to 10-8-7 3:20:05 by step 5
> minutes.
>
> When I preview my chart, I find only datas from 10-8-4 3:20:05 to 10-8-4
> 19:20:05 are displayed but other datas not. I don't know what is wrong
> and how to solve the broblem. Any help will be appreciated!


Jason Weathersby

BIRT Exchange
Previous Topic:Master Page or(page orientation) Based on the parameter
Next Topic:Report Designer enforces invalid SQL for Oracle
Goto Forum:
  


Current Time: Wed Apr 16 16:15:10 EDT 2014

Powered by FUDForum. Page generated in 0.15483 seconds