Report Printing - Sort Order

[#1]

Hi,

I have a pivot chart that is displayed correctly with specified sort orders on some of the dimension.  However, when this is printed in a report - some of the sort orders aren't matching the screen display.

Is this a common bug within QV 11?

Many thanks,

Tom

[Anonymous]

Tom,

Can you verify that the pivot table shown on the screen is the same that is used in the report?  Check object ID to make sure.

Regards,

Michael

[#3]

HI,

Yes the chart objects are both the same.

Thanks,

Tom

[Anonymous]

Can you upload an example?

[#5]

HI I cant really post an example. 

I have over 300 indicators that I need to sort in a particular order that are split into 3 categories :

• Tab
• Tab_Group
• Tab_Sub_Group

In the 'Sort' tab I have tried to sort each Dimension using the following fields

• Tab_Order (main category sort order which holds values 1-5)
• Tab_Group_Order - which is the second sort column
• Tab_Sub_Group_Order - final sort order column. 

In my pivot table I am also sorting the Month-Year (which is used horizontally across the top of the pivot).

What ever I try to do the Pivot doesn't sort correctly...

Hope this helps.

Tom

[Anonymous]

Tom,

Without an example, I can only answer your question in the opening post:
I've never seen a situation where an object in a printed report has different sort order than the same object on the screen.  Nor in QV 11 neither in any other version.

From your latest reply, it looks like there are problems with sort order on the screen as well.  Pivot tables are not flexible when it comes to sort order.  Basically, it sorts in order of dimensions.  If you cannot upload an example - search forum for "pivot table sort", you'll definitely find a lot of workarounds for the different specific situations..

Regards,

Michael

[ashwanin]

Check whether the sort order is working fine in QV object?

Problem is only with report or is it with when you send data into excel als