Home » Developer & Programmer » Reports & Discoverer » matrix report with fiscal months (Oracle reports 10g)
matrix report with fiscal months [message #436107] Mon, 21 December 2009 09:37 Go to next message
Messages: 26
Registered: July 2009
Junior Member

I've created a matrix report that has a group type for rows, and the fiscal month as columns. The intersection is the number of issues counted for the group, per month. I run into a problem when there's no issues for a month. The sort will revert back to normal calendar months, and there will be nothing for those months where there is nothing. I'm guessing I'll have to create some type of dummy month for fiscal months were there are no issues, but I'm not sure how to go about this. Anyone who has dealt with this issue, your insight is greatly appreciated!
Many thanks Smile
Re: matrix report with fiscal months [message #436110 is a reply to message #436107] Mon, 21 December 2009 10:33 Go to previous message
Messages: 12816
Registered: September 2008
Location: Rainy Manchester
Senior Member
Use a row-generator (search the wiki here) to generate the list of months.
Previous Topic: Display an image using its URL
Next Topic: problem in using destype
Goto Forum:

Current Time: Wed Aug 16 16:55:00 CDT 2017

Total time taken to generate the page: 0.05811 seconds