rickesilaw
Programmer
The samples given in VFP show rather simple generation of html from report - I have a report where data is gathered from several tables, some of report data comes from set relation - is it possible to send all this to html?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
creating html from report 1
- Thread starter rickesilaw
- Start date
- Status
Hi rickesilaw
I believe that FRX2Any ( is the tool you need. It can convert your reports into set of formats: HTML, Word, Excel, PDF, XML, BMP. First rate product, steady updates with added features, first rate support. Highly recommend it.
HTH
I believe that FRX2Any ( is the tool you need. It can convert your reports into set of formats: HTML, Word, Excel, PDF, XML, BMP. First rate product, steady updates with added features, first rate support. Highly recommend it.
HTH
Mike Lewis
Programmer
rickesilaw,
I agree with MChary. The VFP sample would probably work in your case, but it is very simplistic and does not produce great output. FRX2ANY will do the job much better.
Mike
Mike Lewis
Edinburgh, Scotland
I agree with MChary. The VFP sample would probably work in your case, but it is very simplistic and does not produce great output. FRX2ANY will do the job much better.
Mike
Mike Lewis
Edinburgh, Scotland
- Thread starter
- #4
rickesilaw
Programmer
we tried this software - output was ok but not really useful - for instance the excel data could not be edited (was in some kind of block format). It was close with pdf and html but not always 100% - I haven't tried it lateley (about 6 months) so I will check for update and let you know if any improvements
Mike Lewis
Programmer
Thanks for the feedback, Rickesilaw.
Mike
Mike Lewis
Edinburgh, Scotland
Mike
Mike Lewis
Edinburgh, Scotland
I don not know which version of FRX2Any you use, but latest FRX2Any version is 08.09.02. This version has 3 kind of Excel outputs. One of them called FULL CELL IMPLEMENTATION - all your FIELDS and LABELS will be placed into Excel cells, so, you will be able to do additional calculations in your output afterwards.
And I believe that output quality, since that version you have, are much improved.
Murad Tchary
And I believe that output quality, since that version you have, are much improved.
Murad Tchary
- Thread starter
- #7
rickesilaw
Programmer
Thx - I will get latest version and let you know. The excel feature you described was not in version we had so...
I agree with rickesilaw. I downloaded the trial version of frx2any. Although the output looks impressive. It is not dynamic to change such as excel, and the HTML version cut-off the right side of the report. (maybe a setting on my part - ?) and did not seem practical.
Am I missing something, or is the product overrated?
Jim Osieczonek
Delta Business Group, LLC
Am I missing something, or is the product overrated?
Jim Osieczonek
Delta Business Group, LLC
Mike Lewis
Programmer
I don't have any problems producing an editable worksheet with Frx2Any.
Mike
Mike Lewis
Edinburgh, Scotland
Mike
Mike Lewis
Edinburgh, Scotland
I probably didn't make myself clear. I never said I couldn't edit it. I could.
However, when I created the sample "invoice" as an excel spreadsheet, I changed some basic values like cost, and quantity, and it did not recalculate the totals.
To me, that is the value of a spreadsheet. Spreadsheets are very dynamic and reflect the current calculations. If if doesn't do that, in my opinion, it's about the same as a report or pdf output with maybe a slight exception that you can edit headers, etc.
Am I missing something? Did the totals recalculate for you?
Jim Osieczonek
Delta Business Group, LLC
However, when I created the sample "invoice" as an excel spreadsheet, I changed some basic values like cost, and quantity, and it did not recalculate the totals.
To me, that is the value of a spreadsheet. Spreadsheets are very dynamic and reflect the current calculations. If if doesn't do that, in my opinion, it's about the same as a report or pdf output with maybe a slight exception that you can edit headers, etc.
Am I missing something? Did the totals recalculate for you?
Jim Osieczonek
Delta Business Group, LLC
Mike Lewis
Programmer
Jim,
I changed some basic values like cost, and quantity, and it did not recalculate the totals.
Have I got this right? You successfully exported the report, but Excel fails to recalc?
Sorry if this sounds obvious, but have you checked the auto recalc option is enabled within Excel? What happens when you hit the Recalc key?
Mike
Mike Lewis
Edinburgh, Scotland
I changed some basic values like cost, and quantity, and it did not recalculate the totals.
Have I got this right? You successfully exported the report, but Excel fails to recalc?
Sorry if this sounds obvious, but have you checked the auto recalc option is enabled within Excel? What happens when you hit the Recalc key?
Mike
Mike Lewis
Edinburgh, Scotland
Hi Mike,
Yes, I think you understand my concern about it not recalculating the data.
I have auto calc on. I even created a small formula at the bottom of the spreadsheet frx2any created. It adds 2 cells for a total. The total cell (with the formula) is very dynamic and changes when I change the values I am adding.
This is easy to test. Just create the sample invoice report using frx2any and save it as a spreadsheet.
Mchary,
I get the feeling you may think I am being a bit picky, but again, in my opinion the value of a spreadsheet is that it is dynamic to change and allows the user to do what-if type of analysis.
Check out the silly OLE sample I have posted for others. Notice, I actually build the formlua for totals at the bottom. It is more difficult to do that than just store a hard number as a total, but then it wouldn't be very dynamic.
I am not saying the output doesn't look cool. It does, but if it's not dynamic it doesn't fit my needs.
thread184-694105
Jim Osieczonek
Delta Business Group, LLC
Yes, I think you understand my concern about it not recalculating the data.
I have auto calc on. I even created a small formula at the bottom of the spreadsheet frx2any created. It adds 2 cells for a total. The total cell (with the formula) is very dynamic and changes when I change the values I am adding.
This is easy to test. Just create the sample invoice report using frx2any and save it as a spreadsheet.
Mchary,
I get the feeling you may think I am being a bit picky, but again, in my opinion the value of a spreadsheet is that it is dynamic to change and allows the user to do what-if type of analysis.
Check out the silly OLE sample I have posted for others. Notice, I actually build the formlua for totals at the bottom. It is more difficult to do that than just store a hard number as a total, but then it wouldn't be very dynamic.
I am not saying the output doesn't look cool. It does, but if it's not dynamic it doesn't fit my needs.
thread184-694105
Jim Osieczonek
Delta Business Group, LLC
- Thread starter
- #13
rickesilaw
Programmer
Hi Jim/Mike
I would like dynamic as well but to be fair the FRX2ANY people have continued to make improvements so I would suggest you put it on a wish list to them. I am going to test their latest version and will update all on this link.
I would like dynamic as well but to be fair the FRX2ANY people have continued to make improvements so I would suggest you put it on a wish list to them. I am going to test their latest version and will update all on this link.
rickesilaw -- Good point.
I don't mean to sound like it's not a cool product, because it is. It is a nice piece of programming and obviously a lot of hours to make it work. I played around with several of the samples and they are quite impressive.
If they make a few more improvement it will catch my attention more.
Jim Osieczonek
Delta Business Group, LLC
I don't mean to sound like it's not a cool product, because it is. It is a nice piece of programming and obviously a lot of hours to make it work. I played around with several of the samples and they are quite impressive.
If they make a few more improvement it will catch my attention more.
Jim Osieczonek
Delta Business Group, LLC
-
1
- #15
craigsboyd
IS-IT--Management
I found XFRX to be a much better solution. Their documentation is somewhat lacking, but I could answer any questions you may have regarding the product since i have figured out most of it through trial and error. I use it in my projects and have created a function that allows a screen to come up giving the user the option of "Quick Preview" (vfp regular preview, "Searchable Preview" (xfrx preview - very nice find functionality and toolbar enhancement), "Export" (word, excel, pdf, html). Since most of the discussion in this thread has been about html, I can tell you that I have found the html to be nearly flawless in reproducing reports. In case anyone is wondering, I am not allied or associated with the makers of XFRX in any other way than being a consumer, a very pleased consumer. The price is much less than FRX2ANY also, though I will give the nod to FRX2ANY for supporting more formats than XFRX.
Slighthaze = NULL
craig1442@mchsi.com
Slighthaze = NULL
craig1442@mchsi.com
"Whom computers would destroy, they must first drive mad." - Anon
Good summary - sound pretty honest and non-bias - giving both products positive plug. Worth an * for the helpful analysis.
Jim Osieczonek
Delta Business Group, LLC
Jim Osieczonek
Delta Business Group, LLC
- Status
