Report Designer VFP9  
Author Message
katzeyy





PostPosted: Sat Feb 25 10:41:53 CST 2006 Top

Exchange Servers >> Report Designer VFP9

Hi All,

I've been using Crystal Reports with my VFP apps for many years now and
have become a bit rusty using the standard report designer. In fact,
I've not used the standard designer since v6 or v7. What I need to do
is print a field in a diffrent colour, depending on its value. For
example, if field1 = "UK", print it in red, otherwise print it in blue.
Is there any way of doing this in the standard report designer easily?
I realise I could have 2 text objects overlayed for the same field and
use the Print When option to show/hide the relevant field, but was
hoping there is an easier way to do what I want?

TIA

Justin

Exchange Server5  
 
 
Fred





PostPosted: Sat Feb 25 10:41:53 CST 2006 Top

Exchange Servers >> Report Designer VFP9 With VFP9 you should take a look at report listeners. Or you could do it
the old way and have 2 overlapping fields in the different colors using the
"Print When" to control which one is seen.

--
Fred
Microsoft Visual FoxPro MVP




> Hi All,
>
> I've been using Crystal Reports with my VFP apps for many years now and
> have become a bit rusty using the standard report designer. In fact,
> I've not used the standard designer since v6 or v7. What I need to do
> is print a field in a diffrent colour, depending on its value. For
> example, if field1 = "UK", print it in red, otherwise print it in blue.
> Is there any way of doing this in the standard report designer easily?
> I realise I could have 2 text objects overlayed for the same field and
> use the Print When option to show/hide the relevant field, but was
> hoping there is an easier way to do what I want?
>
> TIA
>
> Justin
>


 
 
jndb72





PostPosted: Sat Feb 25 13:38:01 CST 2006 Top

Exchange Servers >> Report Designer VFP9

> With VFP9 you should take a look at report listeners. Or you could do it
> the old way and have 2 overlapping fields in the different colors using the
> "Print When" to control which one is seen.
>
> --
> Fred
> Microsoft Visual FoxPro MVP
>
>


> > Hi All,
> >
> > I've been using Crystal Reports with my VFP apps for many years now and
> > have become a bit rusty using the standard report designer. In fact,
> > I've not used the standard designer since v6 or v7. What I need to do
> > is print a field in a diffrent colour, depending on its value. For
> > example, if field1 = "UK", print it in red, otherwise print it in blue.
> > Is there any way of doing this in the standard report designer easily?
> > I realise I could have 2 text objects overlayed for the same field and
> > use the Print When option to show/hide the relevant field, but was
> > hoping there is an easier way to do what I want?
> >
> > TIA
> >
> > Justin
> >

Thanks Fred,

I was trying to get away from having overlapping fields if I could help
it, simply because I have so many fields on the report that it could
get quite messy. Off the top of your head do you know if what I want to
do is possible with report listeners as I've not used them before?

Cheers

Justin

 
 
jndb72





PostPosted: Sat Feb 25 14:16:18 CST 2006 Top

Exchange Servers >> Report Designer VFP9



> > With VFP9 you should take a look at report listeners. Or you could do it
> > the old way and have 2 overlapping fields in the different colors using the
> > "Print When" to control which one is seen.
> >
> > --
> > Fred
> > Microsoft Visual FoxPro MVP
> >
> >


> > > Hi All,
> > >
> > > I've been using Crystal Reports with my VFP apps for many years now and
> > > have become a bit rusty using the standard report designer. In fact,
> > > I've not used the standard designer since v6 or v7. What I need to do
> > > is print a field in a diffrent colour, depending on its value. For
> > > example, if field1 = "UK", print it in red, otherwise print it in blue.
> > > Is there any way of doing this in the standard report designer easily?
> > > I realise I could have 2 text objects overlayed for the same field and
> > > use the Print When option to show/hide the relevant field, but was
> > > hoping there is an easier way to do what I want?
> > >
> > > TIA
> > >
> > > Justin
> > >
>
> Thanks Fred,
>
> I was trying to get away from having overlapping fields if I could help
> it, simply because I have so many fields on the report that it could
> get quite messy. Off the top of your head do you know if what I want to
> do is possible with report listeners as I've not used them before?
>
> Cheers
>
> Justin

Just took a look at the solutions examples in VFP9. The report listner
in the example more or less does what I want. Thanks for the pointer
Fred.

Cheers

Justin