Eclipse Community Forums: BIRT » Chart Report For Work Schedules

Home » Archived » BIRT » Chart Report For Work Schedules

Chart Report For Work Schedules [message #792561]

Tue, 07 February 2012 00:54

Eclipse User

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.

Attachment: Work_Schedules.PNG
(Size: 15.85KB, Downloaded 213 times)

Re: Chart Report For Work Schedules [message #793146 is a reply to message #792561]

Tue, 07 February 2012 15:33

Eclipse User

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.
>

Attachment: crosstabsortheadervalues.zip
(Size: 5.88KB, Downloaded 166 times)

Re: Chart Report For Work Schedules [message #793470 is a reply to message #793146]

Wed, 08 February 2012 02:09

Eclipse User

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 155 times)

[Updated on: Wed, 08 February 2012 02:19] by Moderator

Re: Chart Report For Work Schedules [message #793479 is a reply to message #793146]

Wed, 08 February 2012 02:28

Eclipse User

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 03:38] by Moderator

Re: Chart Report For Work Schedules [message #793894 is a reply to message #793479]

Wed, 08 February 2012 13:15

Eclipse User

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 13:16

Eclipse User

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 13:56

Eclipse User

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 14:50

Eclipse User

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 02:14

Eclipse User

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 13:07

Eclipse User

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:

-=] Back to Top [=-

Current Time: Mon Mar 17 11:44:55 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter