I'm sorry but I forgot to mention a few other nice features about R&R that maybe someday will be in the native VFP report designer.
1. Multi-scan detail bands. You can have two or more children related to the parent and you can have the child records scanned in the detail band one right after the other. This is very easy to do in R&R.
2. You have lines within each band (including the detail band) that you can place a print condition for the entire line. For example, if you don't want a blank line if the field on the line is blank, you can set a condition on the line not to print the line if the field is blank. The condition can be based off of any calculated field that returns a logical.
These are two "biggies" that I can think of off the top of my head. I sure hope the SQL version is faster because I really like all of the features R&R has. I have been using it since my Clipper days and it has saved me countless hours of work, not to mention the ease to create really complex reports.
James
>Thanks for the detail info... > >Regards, >Farouk Yew Abdullah > > >> >>>Thanks all for the feedback. Looks like not many R&R defendars??? >>> >>>Regards, >>>Farouk Yew Abdullah >>> >>> >>>> >>>>>Hi all, >>>>> >>>>>Can anyone who has change from Foxfire to R&R tell me whether the change >>>is worthwhile? If can please me know the pros and cons after moving to >R&R. >>>Thanks in advance.... >>>>> >>>>>Regards, >>>>>Farouk Yew Abdullah >>>>>Visual Solutions (M) Sdn. Bhd. >>>>>Malaysia >>>> >>>>Farouk, R&R doesn't use Rushmore, as Tony said, and it doesn't have other >>>Foxfire! attributes like multiple user lists, a data dictionary so fields >>>are shown with your own descriptive name instead of field names, etc. etc. >>>> >>>>HTH >> >>Farouk, >> >>I'm sorry I didn't get back with you when you posted this on the Promatrix >support forum. I have been using R&R for several years. The lastest >version (version 8) has an OCX control you just place on your form, set >properteies, and run. It works very well on a stand-alone application with >not a whole lot of records. As others have mentioned, it does not use >Rushmore. It does, however, have a data dictionary that you can provide >descriptive field names. >> >>On a network with large tables, R&R is very slow. I replaced a report that >runs from a single record report from the parent table with a native VFP >report and there is no comparison. The native VFP report ran exptremely >fast compared to the same R&R report. It is almost as though R&R uses a >filter to query the data. >> >>I have ordered the other Wall Data product called Arppegio. It is the SQL >version of R&R. They say it has the same report designer as the xbase >version of R&R. >> >>I have also just purchased FoxFire because I need the capability in a >different application for the user to create their own reports and mailing >labels. You cannot do this with R&R (unless the user purchased their own >copy of R&R). One of the only things I don't like about FoxFire compared to >R&R is that R&R's runtime can be distributed royality free where FoxFire >charges licensing fees. I wish FoxFire could be distributed royality free >like a majority of all the other developer tools out there. >> >>HTH, >> >>James
James Moore Owner/Developer Ministry Tracking Software, Inc. www.youthtrack.com
