How to "right to left" a report in crystal report?

Elham_Seif
Elham_Seif used Ask the Experts™
on
I created a report in Crystal Report VS 2005.
I set it to show my report in multi columns.
But it always shows the first column on the left and the next column will be shown on the right of it. It's normal when we want our report Left To Right.
But I'd like my report Right To Left. Because it is in Arabic.
I'd like the first column to be shown on the right side of the report and the next column comes on the left of it.
Would you please let me know how to do it.
Any help would be very much appreciated.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Kyle AbrahamsSenior .Net Developer

Commented:
 I would create a duplicate report, then all you need to do is to re-order the columns and set to right justified.

Not sure if there's a way to dynamically position the columns like that.

Author

Commented:
Hi ged325
Since I am new to Crystal Report, would you please send me some sample code about how to do it. My report has only 2 columns and I prefer the second way. I mean changing the position of each column dynamically if possible.
Thanks for your help. I hope I can make it possible with your help.
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
You want the report at to show


Column1    Column2

but sometimes you need it as

Column2    Column1

Crystal can't do that automatically but you could use a formula like for column 2
A similar formula for column1

If {?LanguageParameter} = "Arabic" then
    {Column1Field}
Else
    {Coulmn2Field}

mlmcc
Bootstrap 4: Exploring New Features

Learn how to use and navigate the new features included in Bootstrap 4, the most popular HTML, CSS, and JavaScript framework for developing responsive, mobile-first websites.

Kyle AbrahamsSenior .Net Developer

Commented:
mlmcc once again provides an elegant solution to the problem.  My only issue with that is you're going to have formulas for every heading, every value, every running total, etc.  depending on the complexity of the report.

My way would be to create 2 different reports laid out the way I wanted them, and then from there have the code load the report:

If Session("Language") = "Arabic"
  rpt = LoadReport("arabicReport1.rpt");
else
 rpt = LoadReport("Report1.rpt");

Author

Commented:
Hi Qed325 & mlmcc
My problem is that I can't make the report to be right to left.
To clarify my problem I attached a simple project containing one crystal report.
If you open it in visual studio 2005, you will get a result showing in Image 1(rp1.jpg).
The result I expect my report to show, is shown in image 2(rp2.jpg).
If you can change my report sample to show image 2 and send it back to me, I'll give you the score.

Thanks in advance for your help.


rp1.JPG

Author

Commented:
Sorry I couldn't attach my sample program here. So I uploaded it to rapdishare.com.
Please get the sample code from this address:
http://www.rapidshare.com/files/426556217/reporttest.rar
If you can make it to give the result like image2, please let me know about how to do it or upload the sample code back to rapidshare and let me know the download link.
Thanks for your help.
rp2.JPG
Senior .Net Developer
Commented:
There is a format option under paragraph where you can specifiy right to left.  Does that work for you?
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
The only options in columns is across then down or down then across.

As far as I know you can't get it to do what you want.  You might if you could use the Arabic edition of Crystal.

mlmcc

Author

Commented:
Hi mlmcc
I saw the option "across them down" and "down them across" but that's not what I need.
Is there any arabic version of Crystal?

Author

Commented:
Hi qed325
"There is a format option under paragraph where you can specifiy right to left.  Does that work for you?"

This is for one column but I want the whole section to be Right to Left.
Did you download my code from the link above to see it?
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
The RIGHT TO LEFT is for a specific field.  He needs to do the section that way.

Unfortunately there doesn't appear to be an Arabic edition.  I thought there was.

http://www.businessobjects.com/global/pdf/products/crystalreports/crxi_feat_ver_ed.pdf

mlmcc

Author

Commented:
Actually I didn't get my solution. It seems that I can't Right to Left my report this way!!
I thank two experts participating the discution. I wish more experts would give their points of views.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial