Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Two columns from 2 rows
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00720313
Message ID:
00720323
Views:
9
Hi,

You can combine fields from two records into one record and than print them in report. Something like
SELECT Image, ProductCode, Description, RECNO() AS rn ;
  FROM crsReport ;
  INTO CURSOR crsTemp

SELECT ;
     t1.Image AS Image1, t1.ProductCode AS ProductCode1, t1.Description AS Description1, ;
     t2.Image AS Image2, t2.ProductCode AS ProductCode2, t2.Description AS Description2, ;
  FROM crsTemp t1 ;	
	JOIN crsTemp t2  ON t1.rn = (t2.rn-1) ;	
  WHERE (t1.rn % 2) = 1 ;
  INTO CURSOR  crsNewReport  
>I would like to print 2 records on the same line
>Using the labels write would do it great. However I need a Title at the top of each page.
>
>I have a catalogue to make and the results should be as follows on an 8.5 x 11" page:
>			T I T L E
>
>	IMAGE 1                          IMAGE 2
>    Product code 1                    Product code 2
>    Description 1		      Description 2
>
>	IMAGE 3                          IMAGE 4
>    Product code 3                    Product code 4
>    Description 3		      Description 4
>
>	IMAGE 5                          IMAGE 6
>    Product code 5                    Product code 6
>    Description 5		      Description 6

>Each number is a different record.
>What I am trying to do is having the report writer print the next record on the same line.
>
>Is there any way this can be done without hand writing a report?
>
>Thanks
>
>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform