Elham_Seif
asked on
How to "right to left" a report in crystal report?
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.
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.
ASKER
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.
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.
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
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
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.
else
rpt = LoadReport("Report1.rpt");
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.
else
rpt = LoadReport("Report1.rpt");
ASKER
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
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
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
ASKER
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?
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?
ASKER
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?
"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?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
I thank two experts participating the discution. I wish more experts would give their points of views.
Not sure if there's a way to dynamically position the columns like that.