Change the orientation report

[ameedoo3000]

hi
I'm New in VFP9 and I want to know how to turn the direction of the report from right to left as is customary in other languages such as Microsoft Access where I could not change the direction of the report so far ... Please take advantage

 

[JRB-Bldr]

If you mean paper Orientation - Portrait/Landscape then it is in the Page Setup of the Report Form's Properties.

If you mean printing Right-to-Left you might want look at:

Developing Arabic or Right to left reading order Applications using VFP​

https://www.universalthread.com/ShowHeaderArticleOneItem.aspx?ID=39226

Good Luck,
JRB-Bldr

 

[ameedoo3000]

Thank you very much
But my question about the report and how to change the destination from right to left in the case if there is more than one column in the report, how to be a column No. 1 starts from the right instead of the left, followed by the second and the third column, and so on
With my thanks

 

[Mike Lewis]

Ameedoo, welcome to the forum and to VFP. We'll try to answer your question, but you must help us by explaining exactly what you want to know.

You wrote:

But my question about the report and how to change the destination from right to left in the case if there is more than one column in the report,

No it wasn't. In your question, you never mentioned anything about there being more than one column. How were we supposed to guess that? In fact, it's still not all clear what you are asking. Do you simply want to invert the order of the columns ("column No. 1 starts from the right instead of the left")? Or do you want to do Arabic (or other right-to-left languages) within each column?

Also, what exactly are these columns? Most reports contain columns: columns of names or dates or numbers of one kind or another. Is that what you are asking about? Or do you perhaps mean columns like in a newspaper, where the text flows from the bottom of one column to the top of the next?

You see the difficulty. We don't know what is going on in your mind. If you could just compose a question that completely describes your problem, we will do our best to answer it.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[ameedoo3000]

my dear Mike
Very sorry not to clarify my question.
What you want to do is make a report (1), such as report No. (2) This is meant to change the point of the report of (left to right) to (right to left)
And he apologized for the second time not to clarify my question
I should be there in the VFP to do this
Note :
1- The pictures in the attachments taken from the Microsoft Access report .
2- I'm working on VFP9 SP2
Greetings to you

 

[Olaf Doschke]

There also are multi column reports, once you set up columns in the report page layout. You also have the option to start columns from the right instead of left there. Soo the section "Column print order" in the page layout tab. It's usually greyed out (disabled), because you first need to define columns, the default report page layout has one column in regard of report column, that term needs to be taken very precise here. You don't need report columns to have a grid like layout of your data with detail header band having caption labels and detail band containing report fields in whatever order you like, as you can put the field controls as you like.

If you like to set Column print order from Left to Right instead of Top to bottom, you have to first at least define 2 columns by incrementing the column number. But there is no right to left setting for these types of columns. The help says this about the column print order:

Column print order
Specifies whether multi-column layouts are processed from top to bottom or left to right.

Top to bottom
Print records from top to bottom (default).

Left to right
Print records from left to right. Also known as "label style."

That may not give you the choice you want to have, but I don't know how an arabic windows acts on reports in general, maybe the left to right setting will print right to left in the same manner as I assume a report is printed bottom to top by default, even when the setting is top to bottom. So these settings may simply work in reverse order by the Windows being arabic or other right to left handed languages/locales. If not, maybe a mirrored font could be your solution. The main difference on these print order settings is, with the top to bottom setting first a column will be filled fully, before the second (third etc.) is used. The left to right setting switches columns with each report cursor/table record, so it better fits to printing on label sheets with eg 4 columns per row on a sheet. You could work with empty records to push some labels to the right side (literally).

Maybe it would be a good idea to contact your arabic collegue, his contact data is given in the universal thread article and could very well be still good to use.

Bye, Olaf.

If the text/column/page/font orientation isn't handled by VFP nor Windows, perhaps you find a printer driver handling that or you take an arabic printer model from DY perhaps?

 

[ameedoo3000]

Fox Pro program of beautiful good programs fast, but sadly it this is a very important property, especially if the program is not available Arabic, I was hoping that there will be support for this feature by Microsoft, but it was not
Thank you responded to my question
And to the meeting in question

 

[Olaf Doschke]

Is your goal to print labels on a label sheet? What would it matter, if labels are used from top to bottom and left to right, each label still can be printed in arabic fonts with right to left orientation.

VFP supports right-to-left at least on forms and in controls through the righttoleft property, as shown. I can't test how vfp, windows or printers behave with reports, but I am quite certain you can cope with arabic in reports, too. Maybe look for solutions in Steven Blacks INTL Toolkit.

Also some OS settings may be of help. This is rather old and for Win95/98, but should still hold true, though diaslogs have changed much:

https://www.microsoft.com/middleeast/msdn/visualfoxpro.aspx

You have to make some more configurations for non unicode applications, but it might be worth the hassle, if you dislike other programming languages.

Bye, Olaf.

 

[atlopes]

The VFP report engine does not have, by default, the capability to dispose detail bands from right to left, but if the page and band dimensions are fixed and known beforehand, you can prepare the cursor to simulate the behavior, and print it the normal top to bottom way.

For a 2 cols x 3 rows page, a cursor, 1.a, 2.b, 3.c, 4.d, and 5.e, that is printed this way

1.a 4.d
2.b 5.e
3.c

can be rearranged as

1.d 4.a
2.e 5.b
3. 6.c

(in this case, the 3rd row in the cursor must be empty).