It's all about the answers!

Ask a question

Report items grouped by month of creation with report builder


Luiz Almeida (22613365) | asked Mar 01 '18, 1:51 p.m.

Hi friends,

I would like to create a report that brings me the total of workitens created in some project areas by month.
Example:

PA1
Jan - 23
Feb - 34
Mar - 54
PA2
Jan - 32
Feb - 65
Mar - 34
PA3
Jan - 99
Feb - 43
Mar - 22

Is it possible to make a report like that in Report Builder?
Do I have to make it with advanced SQL? If so, how do I do that?

Since now, thanks a lot for any tip.

Luiz Cesar.

One answer



permanent link
Rafik Jaouani (4.9k16) | answered Mar 01 '18, 3:04 p.m.
JAZZ DEVELOPER

Hi Luiz, if you are using 6.0.4 or later, you should add a custom expression field that extracts the month and year from the creation date. Also add a count field and use the calculated month/year to group by. This can be easily done without the use of advanced SQL.


Comments
Luiz Almeida commented Mar 01 '18, 3:51 p.m.

Thank you Rafik, but unfortunately I am using the 6.0.2.
I'm trying to do with advance SQL, but I had not success yet.


Luiz Almeida commented Mar 01 '18, 4:40 p.m.

Now I got it.

Your answer


Register or to post your answer.