Need help with creating a report.

I am new to BIRT and I am trying to make a Weekly report by Year. I want to make a 3 line chart, each line representing 2006 - 2008 respectively and broken down by week. I am using a SQL database to pull my data. I have attached an example of what I am trying to accomplish. Any help is greatly appreciated. Thanks!

Find more posts tagged with

Comments

mwilliams

Hi hammerhead,

You can use the optional Y-Series grouping on the year value to have a different line for each year.

hammerhead

Hi mwilliams,

Thanks for the Reply. Could you give me an example of how to do this? As Far a my Data is sorted in Columns. I have a Date Column (ex. 11/7/2008), Column for the year for that Date (ex. 2008), and a Week # Column. How can I set this up? Thanks again.

hammerhead

Here is a screenshot of my Edit Chart screen if it helps.

mwilliams

hammerhead,

What data are you trying to capture in the chart? What I mean by that is, what is the y-series you want displayed? You would use week as the x axis category and year as the optional y-series grouping, but what is your measure value?

hammerhead

I am counting the Records. I am using the date that they are completed. So I guess I would use the Records in the Y series and the Completed Week in the X Series & use the Year in the Y Group.

mwilliams

You may also have to do an aggregation on the chart to count the records. Let me know if you get it working or not.