Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Columns from right to left
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00978171
Message ID:
00978238
Vues:
57
>Does any one know if there is a way to run reports with more than one column and the columns should appear from right to left (Hebrew chracters as well as pages go from right to left)?
>
>For a long time I have been asked to design column reports from right to left and i told the ones who asked for it that they must live with it the way it is (from left to right).
>
>Recently I was asked again to do research on it cause may be today we have more features than in the past.
>
>Any answer (even negotive) would be greatly appreciated.

Dave,

I think it is possible to put a layout translation layer between your current report data source and the report. For example:
*lets say you have a table (namely table1) with one field the following records:
a
b
c
d
e
f
h
i
j
k
l
m
*and it prints on a two columns as follows
	Page1
a	d
b	e
c  	f
	Page2
h	k
i	l
j	m
*but you would like it as follows
Page1
d		a
e		b
f		c

Page2
k		h
l		i
m		j
* so as to get the desired result on the report, create a second updatable cursor 
* with three fields as follows 
* using this command: 
select field1, ;
   0000 as columnfield, ;
   0000 as pagefield ;
   from table1 ;
   into cursor cursor1 readwrite

* Then mark the column and page field accordingly as follows
field1  columnfield  pagefield
a       2			1
b       2			1
c       2			1
d       1			1
e       1			1
f       1			1
h       2			2
i       2			2
j       2			2
k       1			2
l       1			2
m       1			2

SELECT * from cursor1 ORDER BY pagefield,columnfield INTO CURSOR cursor1 
* now the records are order in this way
field1  columnfield  pagefield
d       1			1
e       1			1
f       1			1
a       2			1
b       2			1
c       2			1
k       1			2
l       1			2
m       1			2
h       2			2
i       2			2
j       2			2
* when run the same report based on this cursor you will get desired result in your 
* report as follows:
Page1
d		a
e		b
f		c

Page2
k		h
l		i
m		j

This is just a demonstration of the principle that I am trying to convey.
I think you can do it if find a way to create this translation layer based on the specific need of your report.
The key is to determine the number columns on a page and the number of rows on a page, then you can mark the records appropriatly and get the desired result.
Hope this helps!
Dawa Tsering


"Do not let any unwholesome talk come out of your mouths,
but only what is helpful for building others up according to their needs,
that it may benefit those who listen."

- Ephesians 4:29-30 NIV

Dare to Question -- Care to Answer

Time is like water in a sponge, as long as you are willing you can always squeeze some.

--Lu Xun, Father of Modern Chinese Literature

Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform