Query Output

[Former Member]

Hi All,

If no values for the slection period,the system has to show blank/zero to that month in output of query.

for example : if we given the selction like 001/2008 to 003/2008 in fiscal year period

at present my report showin values like

001/2008 003/2008

100000 2500

but requiremnet to show all the selections months if values are nt present also in report

like

001/2008 002/2008 003/2008

100000 0000 2500

Thanks in advance

Mahesh

[Former Member]

i don't exactly get what you want.

Do you want to see all the columns even if there are only zero values?

This sounds like normal query behavior.

You can use options on query level to hide zeroes or to display zeroes in the way you want.

Otherwise try to explain to me what you are aiming at.

Marco

[former_member205352]

Try this, I have never tried this.

Create a formula/CKF and assign 1 to it.

Hide this key figure.

Try displaying.

Hope this helps.

[Former Member]

Hi

I tried with CKF/formula=1 ,No use.

is their any other way to handle this

for example, if the given range their where no values for the selection cretiria,then system has to show blank/zero in that place.

for example: if given selection like fiscal year period 001/2008-003/2008

then report has to show all 001 002 003 (if no data then system will appear no applicable data found ) & if two months you have data and any one of the month doest have data then it has show the block in that column).

mahesh

Edited by: Mahesh Kumar on Oct 13, 2008 1:59 PM

[Former Member]

as posted before, make a fixed structure in your columns

tip: use 0FISCPER3 in stead of 0FISCPER

[Former Member]

Hi

if i use 0FISCPER3 ,it will displays only months. but i have to show month and year to requirement so iam using the 0FISCPER to show like 001/2008 002/2008 003/2008 004/2008

in database level for perticulat month for perticular selection in query no values,still i want to show the month in output to satisfy them with blank.

How to do..............

mahesh

Edited by: Mahesh Kumar on Oct 22, 2008 9:11 AM

[Former Member]

listen, the only way to display blanks is to use a structure... if you wish to show PPP.YYYY in the columns, then you'll need to create a text variable that combines the fiscal period with the year

[Former Member]

you can do so, if you make a fixed structure in your columns

tip: use 0FISCPER3 in stead of 0FISCPER