|
| Re: Chart Report For Work Schedules [message #793146 is a reply to message #792561] |
Tue, 07 February 2012 20:33   |
|
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 #793479 is a reply to message #793146] |
Wed, 08 February 2012 07:28 |
 Pol Pan
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 #793895 is a reply to message #793470] |
Wed, 08 February 2012 18:16 |
|
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 #793979 is a reply to message #793929] |
Wed, 08 February 2012 19:50 |
|
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 #794801 is a reply to message #794348] |
Thu, 09 February 2012 18:07 |
|
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
>
|
|
|
Powered by
FUDForum. Page generated in 0.04449 seconds
] 
Search
Help
Register
Login
Home
