Report displays different column orders at different times running it

[WKar]

Hello - See the 4 attachments, i have to post them separatley it seems

The one that says behaving the latest version is how the report should look:

Note the situation.  No one is loading to the tables, the data is constant, but in the span of a week.. we ran this report 3 different times/days and our Months go out of order, and our quarters go out of order.  Why is this happening?? The very last time we ran it, it worked.  We cannot put logic to it.  Also attached is the specs of my report. 

It seems that it wont let me attach all 4.. ill post 3 more times to get all of this out.

Please advise thank you!

[WKar]

second attachment

[WKar]

third attachment

[WKar]

report specs

[WKar]

Also, something to add that may be my problem, is that I am using

firstchild  to get Q1
and then next member(Derived Q1) = Q2
next member(Derived Q2) = Q3
next member(Derived Q3) = Q4

would this throw off the order occasionally?  What makes it confusing is that it will run perfectly fine and then randomly get out of order.. and then run fine..

Please help. thank you

[rockytopmark]

use the Order() function to properly order your quarters

[WKar]

the 4 quarters are 4 diff data items.

and then the code is as i listed above to get to each.

where do i put the order function? Do I create a 5th data item and place on top? or is it within the code of each of the 4 quarters?

thanks for the reply, let me know

[DSR]

Hi,

Try this solution once....I think all months are sitting in one column..

If this is the case better to use one condition in calculated data item which says like...

Case when [Mon]='Jan' then '1'
        when [Mon]='Feb' then '2'
.................. end

and for quarters

I think you are using cross tab to display months....If these quarters are different columns you will get all the colums ordered as per the columns droped in report (cross tab) at the time of report creation....

Please check this once... if your getting all the quarters data from a single column or calculating from the months then you need to put same kind of logic as mentioned above for months.

Let me know the situation..........

regards
Sanjeev