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
tuckersuz
Messages: 26
Registered: July 2009
Junior Member
Hello:

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
cookiemonster
Messages: 13958
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 Nov 27 06:26:20 CST 2024