Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Stefan Wuebbe
  Where is Stefan Wuebbe?
 Hamburg
 Germany
 Stefan Wuebbe
 To: Barry Lupton
  Where is Barry Lupton?
 Coventry
 United Kingdom
 Barry Lupton
 Tags
Subject: RE: Alternate fonts in detail line
Thread ID: 310781 Message ID: 310820 # Views: 51 # Ratings: 2
Version: Visual FoxPro 9 Category: Reports and Printers
Date: Saturday, June 25, 2011 10:58:49 AM         
   


> >
> > Hi Barry,
> >
> > With ReportBehavior 90 in Vfp9, the following works for me:
> > In a report field's properties dialog, "Dynamics" tab, add conditions, name them somehow, and in each condition add an expression like "myColumn=1", "myColumn=2" and so on (w/o quotes in the dialog), and determine a different Font for each of them.
> > So that the font would be data-driven, and the content of "myColumn" could be a Scan-and-Replace result.
> >
> >
CREATE CURSOR temp (col1 I, ledger I)
> > FOR i = 1 TO 10
> > 	INSERT INTO temp (col1) VALUES (i)
> > ENDFOR
> > lnLedger = 1
> > SCAN
> > 	REPLACE ledger WITH m.lnledger IN temp
> > 	lnLedger = IIF(m.lnledger<5, m.lnledger+1, 1)
> > ENDSCAN
> > BROWSE
> > 

> >
> >
> >
> > hth
> > -Stefan
>
> Thanks for your help with this, Stefan. I'm not sure what ReportBehaviour 90 is. Could you expand a bit?
>

You're welcome, and sorry, I meant
SET REPORTBEHAVIOR 90 && American English :-)


> If I've got your idea right, the suggestion is to print responses in two or more columns, with each column having a different font. Is that correct?
>

Right, that's exactly how I would probably do it in Vfp8 and earlier, or if I had to use ReportBehavior 80 in VFP9 for some reasons.

> I can picture doing that by using landscape page orientation instead of portrait, but I guess the line length would prove a bit limiting if I moved to more than two columns.
>

The single report "fields" would be all at the same position in the Report Designer though (so that it would be a pain in the neck to edit them at design time).

With ReportBehavior 90, I'd probably use the new "Dynamics" properties, visually designing a kind-of "Do Case" block, see also the screenshot at the bottom of this posting and this attached FRX/FRT example:
https://www.foxite.com/uploads/8cd6b776-1319-4d1d-a8de-3639ed6f7c55.zip

It behaves differently when you toggle "Set ReportBehavior 80|90" in the Command Window before previewing it.



hth
-Stefan





ENTIRE THREAD

Alternate fonts in detail line Posted by Barry Lupton @ 6/24/2011 11:38:45 AM
RE: Alternate fonts in detail line Posted by Stefan Wuebbe @ 6/24/2011 12:58:55 PM
RE: Alternate fonts in detail line Posted by Barry Lupton @ 6/24/2011 1:32:31 PM
RE: Alternate fonts in detail line Posted by Stefan Wuebbe @ 6/25/2011 10:58:49 AM
RE: Alternate fonts in detail line Posted by Barry Lupton @ 6/26/2011 11:04:11 PM
RE: Alternate fonts in detail line Posted by Barry Lupton @ 6/29/2011 1:46:16 PM