Variables Exits

[former_member199448]

I'm trying to design a dynamic query that looks like this:

20005-- Jan06 --- Feb06 --- Mar06 --- Apr06 ... Dec06 --- YTD

My Problem, ich you give per e.g Dezember, all Months have to appear. Or you give may, your going to receive till may.

In the year to date column, i muss do a calculation.

Do you have some Ideas?

Cheers

[Former Member · Accepted solution]

no need to write any exit for that, just restrict the 13 selections with the respective months from Jan to dec and other one for YTD. But for year pass a variable, where the user would pass the year and another one for period. if the user passes may .. all the columns till may get populated and the remaining columns would have 0's. so you can surpress 0's and the columns would be gone.

[former_member199448 · Accepted solution]

Thank you very much.

i wol try it.

[former_member199448 · Accepted solution]

Hi Voodi,

i proceed as you explain me .

I gave August by executing the query and i received all columns with august.

The column respective column of August was fill with data. The other were empty.

A Question again. I didnt understand how i would restrict the column with YtD.

Thanks for your Help.

Cheers

[Former Member · Accepted solution]

did you restrict each column with respective period .. i mean 1st column with Jan, and so on. to get the YTD, restrict it with #to 1 for jan, # to 2 for feb so on... that would fetch you YTD for each period.