Re: frx to xls

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Bill
I should say that request is doable. Well, with third party tool such FRX2Any - www.frx2any.com
FRX2Any Report Converter Engine / FRX2Any Report Listener Engine (last can be used only in VFP 9) both have an Excel module, which allows you to convert FoxPro report into Excel file keeping original FRX layout. All report's Fields and Labels will be placed in Excel Cells (there few output modes), which will allow your users to do additional manipulations with the report output.

Regards
Marat
"swdev2" <wsanders@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:%23b0Rj3OTGHA.1608@xxxxxxxxxxxxxxxxxxxxxxx
Yo Yo Hoe -
If a user gives you a request for WYSIWYG report-like transfer to an excel spreadsheet file - go back and tell their boss he/she is stupid and prone to making uniformed programming requests.

Althought it's NICE to be able to do that - it is totally more work than it is worth - like writing up 4000 lines of C Code to make a new mouse pointer.

you have
1. data in vfp
2. report in vfp with nice visual things
3. visual layout of visual storage in excel
4. excel cells
5. excel 'data '

why not skip the vfp report stage altogether, and jump directly to excel 'data' ? then work backwards up the list?
then you can make up an excel template/workspace formatted the way your user wants it.


If Excel is not really an issue (but you wanted to use the abbreviation xls in a sentence for some reason) then what other tools are you use?
What version of VFP? and is this for a UBS customer?

let me know your thoughts.

-- [Bill]
===================
William Sanders / EFG VFP / mySql / MS-SQL
www.efgroup.net/vfpwebhosting
www.terrafox.net www.viasqlserver.net

"tnhoe" <tnhoe@xxxxxxxxxxxx> wrote in message news:441f508a$1_2@xxxxxxxxxxxxxxxxx
Hi,

which is the best tool for REPORT FORM frx TO xls ? I mean WYSIWYG including line/box/fonts,etc.

xfrx ? frx2any ? I have tried Amyuni Converter, but not really convert exactly, and column of data missing too.

plz recommend.

Regards
Hoe

Relevant Pages

  • Re: Web Report to VFP Client
    ... Excel would be easy but then again so would just using the web site. ... Browser ActiveX control in VFP? ... The problem is that the report can have a variable number of columns ...
    (microsoft.public.fox.programmer.exchange)
  • Re: frx to xls
    ... If a user gives you a request for WYSIWYG report-like transfer to an excel spreadsheet file - go back and tell their boss he/she is stupid and prone to making uniformed programming requests. ... report in vfp with nice visual things ... why not skip the vfp report stage altogether, and jump directly to excel 'data'? ...
    (microsoft.public.fox.programmer.exchange)
  • Export of Report to Excel
    ... I have a report which I run which creates a billing report for numerous ... By request of the accounting department, ... I know that there is the ability to export the report to Excel. ...
    (microsoft.public.access.reports)
  • Re: why>?
    ... Just because PDF is more popular than SNP; ... Emailing a dynamic report is easier than emailing PDF files.. ... Excel is ALWAYS less efficient than Access. ... e) multi-user functionality - being able to work on the same report / ...
    (microsoft.public.excel)
  • Re: Need Resource Group in Visual Reports
    ... Because the machine I use with Project 2007 doesn't have Excel 2003 ... showing the same information as the Visual Report in Excel. ... When you said:"I've saved the resource usage cube and transferred ...
    (microsoft.public.project)