Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Chart Report For Work Schedules
Chart Report For Work Schedules [message #792561] Tue, 07 February 2012 05:54 Go to next message
Pol Pan is currently offline Pol PanFriend
Messages: 7
Registered: January 2012
Junior Member
Hello,

We have a custom JSP based (primitive though) report showing work schedules of employees. I have attached screen shot of the report.

Is it possible to do a similar kind of report using BIRT because we would like to use reporting capabilities of BIRT rather than a custom jsp based report. If so what kind of chart we could use for this?

Any help is highly appreciated.
Re: Chart Report For Work Schedules [message #793146 is a reply to message #792561] Tue, 07 February 2012 20:33 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

That image looks like a cross tab and not a chart. I am attaching a
crosstab example report.

If you have some sample data in flat file or xml format I can show you
how to reproduce with your data.

Jason

On 2/7/2012 12:54 AM, Jacob Jacob wrote:
> Hello,
>
> We have a custom JSP based (primitive though) report showing work schedules of employees. I have attached screen shot of the report.
>
> Is it possible to do a similar kind of report using BIRT because we would like to use reporting capabilities of BIRT rather than a custom jsp based report. If so what kind of chart we could use for this?
>
> Any help is highly appreciated.
>
Re: Chart Report For Work Schedules [message #793470 is a reply to message #793146] Wed, 08 February 2012 07:09 Go to previous messageGo to next message
Pol Pan is currently offline Pol PanFriend
Messages: 7
Registered: January 2012
Junior Member
Thanks a lot Jason for the feedback and reply.


I have another question, in cross tab report, is it possible to have some kind of an image or some thing like that to display the period range? If you look at the screenshot I have attached in my first post of this thread, we are displaying an image which is based on the date range. i.e. length of image size varies and depends on date difference.

Quote:

If you have some sample data in flat file or xml format I can show you
how to reproduce with your data.

I have attached some sample data as xml.
Top heading will have months and year for one year period like the screenshot.

Thanks again for your input.


  • Attachment: data.xml
    (Size: 1.51KB, Downloaded 119 times)

[Updated on: Wed, 08 February 2012 07:19]

Report message to a moderator

Re: Chart Report For Work Schedules [message #793479 is a reply to message #793146] Wed, 08 February 2012 07:28 Go to previous messageGo to next message
Pol Pan is currently offline Pol PanFriend
Messages: 7
Registered: January 2012
Junior Member
Quote:
That image looks like a cross tab and not a chart. I am attaching a
crosstab example report.


I was looking at your sample report as cross tab. Was wondering how do you bind the data as xml to a report. I have only added data set from database tables. Albeit my data comes from database.

Regards

Update 1
Never mind I found the source for xml data.
Thanks anyway.

[Updated on: Wed, 08 February 2012 08:38]

Report message to a moderator

Re: Chart Report For Work Schedules [message #793894 is a reply to message #793479] Wed, 08 February 2012 18:15 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

You can use the xml data source. Here is an older version
http://www.eclipse.org/birt/phoenix/examples/reports/birt2.1/xmlds/index.php

Take a look at this one to.
http://www.birt-exchange.org/org/devshare/designing-birt-reports/563-birt-xml-data-source-tutorial/

Jason

On 2/8/2012 2:28 AM, Pol Pan wrote:
> Quote:
>> That image looks like a cross tab and not a chart. I am attaching a
>> crosstab example report.
>
>
> I was looking at your sample report as cross tab. Was wondering how do
> you bind the data as xml to a report. I have only added data set from
> database tables. Albeit my data comes from database.
>
> Regards
>
Re: Chart Report For Work Schedules [message #793895 is a reply to message #793470] Wed, 08 February 2012 18:16 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Crosstabs can contain images, where would you have the image?

Jason

On 2/8/2012 2:09 AM, Pol Pan wrote:
> Thanks a lot Jason for the feedback and reply.
>
>
> I have another question, in cross tab report, is it possible to have some kind of an image or some thing like that to display the period range? If you look at the screenshot I have attached in my first post of this thread, we are displaying an image which is based on the date range. i.e. length of image size varies and depends on date difference.
>
> Quote:
>> If you have some sample data in flat file or xml format I can show you
>> how to reproduce with your data.
>
> I have attached some sample data as xml.
> Top heading will have months and year for one period like the screenshot.
>
> Thanks again for your input.
>
>
>
Re: Chart Report For Work Schedules [message #793929 is a reply to message #793895] Wed, 08 February 2012 18:56 Go to previous messageGo to next message
Pol Pan is currently offline Pol PanFriend
Messages: 7
Registered: January 2012
Junior Member
I would like to have image inside a column. If you look at my screenshot
you could see image which shows the date range size. i.e. size of the image
varies on the number of days between starting date and ending
date.

Thanks
Re: Chart Report For Work Schedules [message #793979 is a reply to message #793929] Wed, 08 February 2012 19:50 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

I believe you could do this by inserting an image into the crosstab and
then writing code to create an image with appropriate size. The image
report item could then be scripted to use this new image as its data.
This would require java code to create the blue box with proper
horizontal size. If you can come up with that I can show you how to use
it in the report. You also may want to look at the Gantt chart type.

Jason

On 2/8/2012 1:56 PM, Jacob Jacob wrote:
> I would like to have image inside a column. If you look at my screenshot
> you could see image which shows the date range size. i.e. size of the image
> varies on the number of days between starting date and ending
> date.
>
> Thanks
Re: Chart Report For Work Schedules [message #794348 is a reply to message #793979] Thu, 09 February 2012 07:14 Go to previous messageGo to next message
Pol Pan is currently offline Pol PanFriend
Messages: 7
Registered: January 2012
Junior Member
Thanks Jason for your replies.

I am trying to follow this example
http://enterprisesmartapps.wordpress.com/2011/07/18/oracle-sql-with-clause-to-create-a-birt-crosstab-dimension/

In the example category
0 10000
10000 20000
20000 30000
>= 30000
is one of the dimension.
For my requirement I need to have a similar date range starting from Jan-2011 to Dec-2011 as one of the dimension.
For this is it possible to have a separate query to get this data?

Another question is in summary field how can I show data as it is, I can only choose one of the function like count,sum, max,min etc.
What if I do not want to use any function, use data as it is?

Thanks
Re: Chart Report For Work Schedules [message #794801 is a reply to message #794348] Thu, 09 February 2012 18:07 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

You can use multiple datasets in a cube as long as they have some kind
of link to the primary dataset. If you use a date time dimension it has
some predefined levels like, month, quarter, and year.

On the second question: The sum will be dependent on the dimension
resolution. If you are rolling up by day then you will get the data
value for the day. If the dimension is rolling up by month then you
will get the month value. So if you want to show it as it is, use the
dimension level resolution of the data. BTW here is a post that has
some cube info and an article you can look at. It also has some
scripting references.

http://birtworld.blogspot.com/2010/07/birt-and-olap.html

Jason

On 2/9/2012 2:14 AM, Jacob Jacob wrote:
> Thanks Jason for your replies.
>
> I am trying to follow this example
> http://enterprisesmartapps.wordpress.com/2011/07/18/oracle-sql-with-clause-to-create-a-birt-crosstab-dimension/
>
>
> In the example category 0 10000
> 10000 20000
> 20000 30000
> >= 30000
> is one of the dimension. For my requirement I need to have a similar
> date range starting from Jan-2011 to Dec-2011 as one of the dimension.
> For this is it possible to have a separate query to get this data?
>
> Another question is in summary field how can I show data as it is, I can
> only choose one of the function like count,sum, max,min etc.
> What if I do not want to use any function, use data as it is?
>
> Thanks
>
Previous Topic:integrate birt RE into RCP product
Next Topic:Access dataSet ColumnValue
Goto Forum:
  


Current Time: Mon Nov 29 03:51:09 GMT 2021

Powered by FUDForum. Page generated in 0.02807 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top