Skip to main content


Eclipse Community Forums

      Home
Home » Archived » BIRT » Yearly/Quarterly Report in Crosstab(Yearly/Quarterly Report in Crosstab)
Yearly/Quarterly Report in Crosstab [message #992961] Sat, 22 December 2012 23:53 Go to next message
Eclipse UserFriend
Hi,
in Crosstab I want to incorporate Year/Quarter-wise report. Now our financial year start from 1st April of the running year to 31st march of the next year.For example if Our Finacial year is 2012-13,then it starts from 1st april-2012 to 31st march 2013 and 1st quarter starts from 1st april-2012 and last quarter ends in 31st march 2013.But in BIRT report year is from jan to dec and quarter is also starts from January.So can u plese guide us how to implement our yearly/quarterly report in BIRT/Crosstab.
Re: Yearly/Quarterly Report in Crosstab [message #992977 is a reply to message #992961] Sun, 23 December 2012 01:08 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
Re: Yearly/Quarterly Report in Crosstab [message #992978 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
Re: Yearly/Quarterly Report in Crosstab [message #992980 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
Re: Yearly/Quarterly Report in Crosstab [message #992981 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
Re: Yearly/Quarterly Report in Crosstab [message #992983 is a reply to message #992961] Sun, 23 December 2012 01:08 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #992984 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #992985 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #992986 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #992988 is a reply to message #992961] Sun, 23 December 2012 01:08 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #992989 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #992990 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #992991 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #992993 is a reply to message #992961] Sun, 23 December 2012 01:08 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #992994 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #992995 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #992996 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #992998 is a reply to message #992961] Sun, 23 December 2012 01:08 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #992999 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993000 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993001 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993003 is a reply to message #992961] Sun, 23 December 2012 01:08 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993004 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993005 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993006 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993008 is a reply to message #992961] Sun, 23 December 2012 01:08 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993009 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993010 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993011 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993013 is a reply to message #992961] Sun, 23 December 2012 01:08 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993014 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993015 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993016 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993018 is a reply to message #992961] Sun, 23 December 2012 01:08 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993019 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993020 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993021 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993023 is a reply to message #992961] Sun, 23 December 2012 01:08 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993024 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993025 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993026 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993028 is a reply to message #992961] Sun, 23 December 2012 01:08 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993029 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993030 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993031 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993033 is a reply to message #992961] Sun, 23 December 2012 01:08 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993034 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993035 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993036 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993038 is a reply to message #992961] Sun, 23 December 2012 01:08 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993039 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993040 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993041 is a reply to message #992961] Sun, 23 December 2012 01:09 Go to previous messageGo to next message
Eclipse UserFriend
Create computed columns to create your groupings, rather than using the auto groupings. That should allow you to do what you're wanting. Let me know your BIRT version, if you need an example.
--
Regards,

Michael Williams
http://www.birt-exchange.org
Re: Yearly/Quarterly Report in Crosstab [message #993176 is a reply to message #992977] Sun, 23 December 2012 11:58 Go to previous messageGo to next message
Eclipse UserFriend
hi ,
Iam using BIRT 4.2.1.

Please give an example
Re: Yearly/Quarterly Report in Crosstab [message #993182 is a reply to message #993176] Sun, 23 December 2012 12:16 Go to previous messageGo to next message
Eclipse UserFriend
hi ,
Iam using BIRT 4.2.1.

Please give an example
Re: Yearly/Quarterly Report in Crosstab [message #993262 is a reply to message #993182] Sun, 23 December 2012 17:49 Go to previous messageGo to next message
Eclipse UserFriend
Wow. Not sure what happened there.
Re: Yearly/Quarterly Report in Crosstab [message #993331 is a reply to message #993262] Sun, 23 December 2012 23:14 Go to previous messageGo to next message
Eclipse UserFriend
Hi please give an example of computed column of any birt version.In your previous reply you asked me for BIRT version for example
Re: Yearly/Quarterly Report in Crosstab [message #994864 is a reply to message #993331] Fri, 28 December 2012 08:50 Go to previous messageGo to next message
Eclipse UserFriend
Sorry for the delay. I was off for the holiday. I'll get an example made, right now.
Re: Yearly/Quarterly Report in Crosstab [message #994872 is a reply to message #992961] Fri, 28 December 2012 09:15 Go to previous message
Eclipse UserFriend
Take a look at this report design. There are two computed columns in the dataSet to create the new cube groups with. The top crosstab shows the original setup with the default groups. The second one shows what it looks like using the computed fields.
Previous Topic:Adding an object to the application context! (Book example: Integrating and Extending)
Next Topic:Eclipse BIRT vs. commercial tools (IBM Cognos, Oracle Hyperion, MS BI Suite, etc)
Goto Forum:
  


Current Time: Thu Jul 24 15:49:31 EDT 2025

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly