Right to Left Report

Question

Right to Left Report

s-387006

SSC Rookie

Points: 44
More actions
July 15, 2007 at 12:34 pm

#179693

Hi
how can i have a report that expands from right to left?

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Gift Peddie SSC Guru Points: 73570 More actions · Answer 1

It is in the Report properties in the drop down properties of the controls in the Reports under International after Calendar is page direction, I am in the US so it default to Left to Right. You can change it to Right to Left. Post again if you will need help, this property is in most of the Controls I have checked.

Kind regards,
Gift Peddie

s-387006 SSC Rookie Points: 44 More actions · Answer 2

Thanks for your reply

I check Report Property both in SQL Server Management Studio & Business Intelligence Development Studio but could not found the property you said.

Plz exactly determine where can I find this property?

Gift Peddie SSC Guru Points: 73570 More actions · Answer 3

You need to be in the Business Intelligence Management Studio and add a Report item and drop a table control on it, you will see the Report properties in Solution Explorer change it to the table and it is under International after Calendar. It is the second item under International

Calendar

Direction LTR(left to right) Change this to RTL(right to left)

WritingMode lr-tb(left to right ) Change to rl-tb(right to left)

Hope this helps.

Kind regards,
Gift Peddie

s-387006 SSC Rookie Points: 44 More actions · Answer 4

I set but still expands left to right.

WritingMode "Indicates whether text is written horizontally or vertically"

Gift Peddie SSC Guru Points: 73570 More actions · Answer 5

It just means you have to do more work, the table comes with textboxes with the same property set all, your report dataset comes with the collation in the dataoption window set it to Arabic and see if you can do the same in the database. When everything in your report is Arabic from collation it will work.

Kind regards,
Gift Peddie

s-387006 SSC Rookie Points: 44 More actions · Answer 6

Did you do this & can you send me a sample?

In HTML the (dir=rtl) fot HTML tag or BODY tag will set the page direction Right To Left. when viewing report in browser, for example MS IE & set the "Right To Left Document" will cause the expansion switches to RTL.

Is there any way to set default Page Direction property for example in IIS?

Gift Peddie SSC Guru Points: 73570 More actions · Answer 7

If I am writing a report that will be rendered in Arabic one of the Right to Left languages I will start with Arabic collation for the tables and columns, use that collation for my stored procedure it is supported in 2005. Then I set that collation in the Report development dataset in the dataoption property, then under international in all the controls in the report set Direction to Right to Left. This means all my data through the development pipeline is in Right to Left orientation. There are some known issues with viewing reports as HTML but why not export to PDF. The links below will help with Right to left setup for VS2005 and Reports HTML problems which are not related to Right to Left rendering. Hope this helps.

http://www.microsoft.com/middleeast/msdn/

http://technet.microsoft.com/en-us/library/ms156511.aspx

Kind regards,
Gift Peddie