VFP 9 Reports v's Crystal

I have a series of reports in VFP 7 that have a large number of fields
in the cursor they are based upon. Segments of these fields are printed
in specific detail bands on the report.

They are a little difficult to maintain and also present some paging
issues.

I am considering moving them to use either Crystal Reports or the VFP 9
report writer.

The typical format of these reports are:

report header

detail band 1

detail band 2

detail band 3

report footer

The data in the detail bands all have a key field that references the
data in the report header and are simply linked so a query like select *
from table where linknumber = header.linknumber would get the data
required.

Are reports like this easily implemented in VFP 9? Will I be able to
get rid of my monolithic cursors?


thanks

Craig
Thu Aug 17 15:45:06 CDT 2006

Yes, Parent to multiple child reports are easily done in VFP 9...but also in
Crystal. Crystal also the ability to do parent-child-grandchild-etc, graphs,
export and more. Pick the tool that solves your needs best, but don't mix
the two in the same application.

--
Craig Berntson
MCSD, Visual FoxPro MVP
www.craigberntson.com
Salt Lake City Fox User Group
www.slcfox.org
www.foxcentral.net


"Peter Huish" <huish@ozemail.com.au> wrote in message
news:MPG.1f4e4af34d432e9f989848@news.easynews.com...
>
> I have a series of reports in VFP 7 that have a large number of fields
> in the cursor they are based upon. Segments of these fields are printed
> in specific detail bands on the report.
>
> They are a little difficult to maintain and also present some paging
> issues.
>
> I am considering moving them to use either Crystal Reports or the VFP 9
> report writer.
>
> The typical format of these reports are:
>
> report header
>
> detail band 1
>
> detail band 2
>
> detail band 3
>
> report footer
>
> The data in the detail bands all have a key field that references the
> data in the report header and are simply linked so a query like select *
> from table where linknumber = header.linknumber would get the data
> required.
>
> Are reports like this easily implemented in VFP 9? Will I be able to
> get rid of my monolithic cursors?
>
>
> thanks