HAVE AS MANY ROWS AS I HAVE DAYS IN A MONTH

[Former Member]

Hi,

im facing a big issue ...

I must create a query that ask for a month and find how many days I have on that month and after, I must have as many rows as I have days ....

example : april = 30 days = 30 rows ( one for each day from 1 to 30 )

Any way to achieve that ??

Thanks

[Former Member]

Ok.

If you also include 0calday in your report, then you will get as many days that contains data right?

For example:

In april, there are thirty days. If user chooses, april we only get data for april amd if we have 0calday in row, then for each day we will have one record.

[Former Member]

Hi Raj,

Thats the first thing I thought, but even if the day have no result, they such want the row ...

example

number of answered call for JOHN in APRIL by day ....

row (day number) / column ( key , calls answered)

1 0

2 1

3 0

4 2

5 3

...

30 0

thank's !

[Former Member]

try this for ur key figure calls.

add 0 to every keyfigure and create a ckf.

then use this new ckf and use display zeros in query and try.

[Former Member]

use FM:

'NUMBER_OF_DAYS_PER_MONTH_GET'

[Former Member]

Hi,

thank for the FM.

But, after that I know that I have for example 30 days in my month, How to have 30 rows in my query formatted like this ???

1

2

3

4

5

...

thank you very much !

[Former Member]

This can be accomplished by just placing the characteritic calday over the keyfigure structure.

This would make the count of key figure dynamci. in terms of it will show columns counting to as many cal days as we have in that month.

However with this approach each day will show only the values of the keyfigure corresponding to that date.

Hope I am clear enough.

Naveen.A