hi, i am using microsoft reporting services and when i try to export a report to excel the report is exported with the excel property: sheet - left to right. is there a way to control that and force it to export with the sheet property of: right-to-left? thanks a lot, JB

Hi, It seems that, there is no direct way of of doing this. There is one workaround for this is to change the sorting property of group. Here, also you can't change Order dynamically, you need write the expression such that it can be based on Parameter. You can create a parameter for splecifing format and it can have two available values. 1) Excel 2) Other and then sorting you can use expression similer to this =IIF(Parameters!Test.Value=1, 10000-Fields!OrderYear.Value, Fields!OrderYear.Value) - Chintak (My Blog)

hi, thankyou for your fast reply. i didn't quite get how to do the work around, if you may please explain it in more details please. thanks, JB

Hi jblass, If you are using SSRS 2008 R2, you could use its new feature to control export report's layout by using build-in field RenderFormate you could refer to Robert Bruckner's Advanced Reporting Services Blog at this link http://blogs.msdn.com/b/robertbruckner/archive/2010/05/02/globals-renderformat-aka-renderer-dependent-report-layout.aspx Thanks, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.

thankyou very much for your replies. i'm working with version 2005. guess i'll wait till 2008 is installed. jb.