fbpx
Welcome, Guest
Username: Password: Remember me
This public forum is meant for questions and discussions about Visual FoxPro
  • Page:
  • 1

TOPIC:

Reporting 30 Oct 2019 13:20 #11524

  • David Martin's Avatar

  • David Martin

  • Topic Author


  • Posts: 5
  • Maybe I have missed this somewhere ... how is reporting going to be handled?

    Please Log in or Create an account to join the conversation.

    Reporting 30 Oct 2019 15:54 #11525

  • Chris's Avatar

  • Chris


  • Posts: 2110
  • Either by posting the report here, or using the "Tickets" button at the top-right of this website to open the report directly in GitHub. It helps reporting it here first if it's some matter that's worth discussing with other members first.
    XSharp Development Team
    chris(at)xsharp.eu

    Please Log in or Create an account to join the conversation.

    Reporting 30 Oct 2019 17:38 #11528

  • FoxProMatt's Avatar

  • FoxProMatt


  • Posts: 409
  • Chris - I believe they are asking about Report generating in a VFP app. Report designer? Viewer? etc...

    Please Log in or Create an account to join the conversation.

    Reporting 30 Oct 2019 18:31 #11532

  • lumberjack's Avatar

  • lumberjack


  • Posts: 693
  • Matt,

    FoxProMatt_MattSlay wrote: Chris - I believe they are asking about Report generating in a VFP app. Report designer? Viewer? etc...

    I think you are correct.

    Robert already mentioned ReportPro as alternative and potentially make it read the VFP report files. The other option might be to try and compile the FoxyPreviewer with X# once all the VFP syntax/runtime features are implemented in X#?
    ______________________
    Johan Nel
    George, South Africa

    Please Log in or Create an account to join the conversation.

    Reporting 30 Oct 2019 19:43 #11533

  • FoxProMatt's Avatar

  • FoxProMatt


  • Posts: 409
  • Hi IvyLeagueSoftware -

    I can tell you from a reply Robert gave me in the VFP FOX Supporter forum that he thinks their Report Pro tool can be made to work with VFP reports.

    Link to thread here: www.xsharp.info/forum/private-vfp/1449-f...by-doug-hennig#10661

    Please Log in or Create an account to join the conversation.

    Reporting 30 Oct 2019 20:59 #11534

  • mainhatten's Avatar

  • mainhatten


  • Posts: 139
  • FoxProMatt_MattSlay wrote: I can tell you from a reply Robert gave me in the VFP FOX Supporter forum that he thinks their Report Pro tool can be made to work with VFP reports.
    Link to thread here: www.xsharp.info/forum/private-vfp/1449-f...by-doug-hennig#10661

    not able to read private... but why not recompile the "stock" report handling added in vfp 9. which can be set as "Reportbehaviou 90" first? Sources to ReportOutput and Reportviewer (as well as ReportBuilder) are included in vfp. Is GDIPlus unable to run outside Win32/Win64 and foxyPreviewer has less difficulties running on Mono/Xamarin for Android ? PDF certainly more important than 12 years ago, but I guess foxyPreviewer will be harder to port...

    mused about the topic in:
    www.xsharp.info/forum/public-vfp/1533-fo...atibility-list#11395

    regards
    thomas

    att: readme and license from vfp reporting "90",seems permissive enough (IANAL!)
    Attachments:

    Please Log in or Create an account to join the conversation.

    Reporting 30 Oct 2019 21:15 #11535

  • Chris's Avatar

  • Chris


  • Posts: 2110
  • FoxProMatt_MattSlay wrote: Chris - I believe they are asking about Report generating in a VFP app. Report designer? Viewer? etc...


    Oops, right, thanks! :blush:
    XSharp Development Team
    chris(at)xsharp.eu

    Please Log in or Create an account to join the conversation.

    Reporting 30 Oct 2019 21:29 #11537

  • David Martin's Avatar

  • David Martin

  • Topic Author


  • Posts: 5
  • Thanks for the replys Guys.

    Please Log in or Create an account to join the conversation.

    Reporting in VFP | FoxPro 30 Oct 2019 22:42 #11538

  • FoxProMatt's Avatar

  • FoxProMatt


  • Posts: 409
  • MainHatten said:
    .

    .. why not recompile the "stock" report handling added in vfp 9. ? Sources to ReportOutput and Reportviewer (as well as ReportBuilder) are included in vfp.


    So, I did some looking around for these "Sources" and I see that indeed the VFP Reporting pieces are implemented in plain old VFP code, and are included with Microsoft's Visual FoxPro installation in a bundle they call "XSource", and I believe they open-sourced this XSource to the community when they announced they were not going to continue VFP (this may need to be verified). There is XSource.zip in the Visual FoxPro \Tools\XSource directory.
    .

    Reporting Apps is part of "XSource", the source files for various Visual FoxPro components. The license governing XSource can be found in the XSource_EULA.txt included with all of the XSource releases.


    Next I discovered that Doug Hennig has put the VFP Reporting source code from XSource in a GitHub repo, and it has had many updates and revisions since the production release. So, anyone working with this should start from Dougs repo, not the one that shipped with VFP.

    Here is the repo: github.com/VFPX/ReportingApps

    I took a quick look at the source code it all appears in VFP code (PRGs and VCXs), and X#.VFP seems to be on a path to fully implement VFP code support, so this could look very promising, for someone to get this VFP report engine running in X# in pretty much the same way it runs in VFP.

    Probably the most mysterious part of this is the _GDIPlus.vcx library that is part of the VFP installation.

    The VFP Help file says this about _GDIPlux.vcx:
    .

    The GDI Plus API Wrapper Foundation class library, _GDIPlus.vcx, contains a collection of classes that wrap GDI+ Flat API functionality for use in Visual FoxPro. You can use these classes to add GDI+ features to forms and reports.


    So, maybe _GDIPlus.cvx is just wrapper code around Windows "stuff" and maybe once the code is finally down that GDI+ level, it can still run from X#, but I am not sure about that.

    Please Log in or Create an account to join the conversation.

    Last edit: by FoxProMatt.

    Reporting in VFP | FoxPro 31 Oct 2019 02:08 #11543

  • FoxProMatt's Avatar

  • FoxProMatt


  • Posts: 409
  • Well, I have now learned that the source code provided through XSource is only run time items to build a report, preview the report, and then output the report.

    There is no Report Designer; that is part of the VFP IDE, so that means there’s no way to create new, or edit existing FoxPro reports unless someone makes a new designer for it.

    And since Report Pro already has a designer, it sure seems like the obvious path is simply for Robert to attempt migrating FoxPro reports to Report Pro.

    Please Log in or Create an account to join the conversation.

    Reporting in VFP | FoxPro 31 Oct 2019 02:46 #11544

  • mainhatten's Avatar

  • mainhatten


  • Posts: 139
  • FoxProMatt_MattSlay wrote: So, I did some looking around for these "Sources"... There is XSource.zip in the Visual FoxPro \Tools\XSource directory.

    Ooops - should I be more explicit in defining location ? Had surmized you being around here for some time plus an "old fox" this was common knowledge... If no need for speed on your side just ask if I am not clear enough ;-)
    .

    Next I discovered that Doug Hennig has put the VFP Reporting source code from XSource in a GitHub repo, and it has had many updates and revisions since the production release. So, anyone working with this should start from Dougs repo, not the one that shipped with VFP.
    Here is the repo: github.com/VFPX/ReportingApps

    Yes, by all means get the version of vfpX - I referred to vfp install first as licensing terms are best read there, before embarking on that route with enhanced code - remember the hoopla with Whil and installing runtimes in Linux?

    Probably the most mysterious part of this is the _GDIPlus.vcx library that is part of the VFP installation.
    The VFP Help file says this about _GDIPlux.vcx:
    .

    The GDI Plus API Wrapper Foundation class library, _GDIPlus.vcx, contains a collection of classes that wrap GDI+ Flat API functionality for use in Visual FoxPro. You can use these classes to add GDI+ features to forms and reports.

    So, maybe _GDIPlus.cvx is just wrapper code around Windows "stuff" and maybe once the code is finally down that GDI+ level, it can still run from X#, but I am not sure about that.

    AFAIR it is a Windows dll, seems there is at least a libgdiplus for Mono, but nothing for Android
    www.mono-project.com/docs/gui/libgdiplus/

    Please Log in or Create an account to join the conversation.

    Last edit: by mainhatten.

    Reporting in VFP | FoxPro 31 Oct 2019 03:21 #11545

  • lumberjack's Avatar

  • lumberjack


  • Posts: 693
  • Matt,

    FoxProMatt_MattSlay wrote: why not recompile the "stock" report handling added in vfp 9. ? Sources to ReportOutput and Reportviewer (as well as ReportBuilder) are included in vfp.

    So, maybe _GDIPlus.cvx is just wrapper code around Windows "stuff" and maybe once the code is finally down that GDI+ level, it can still run from X#, but I am not sure about that.

    We can probably drop the GDI stuff, .NET got the System.Drawing.Graphics and System.Drawing.Printing.PrintDocument classes.

    I for one already have a Printing class wrapped around this in .NET. What is missing on my side is the GUI Designer, since I use a Data-driven approach. I am sure with what is available in ReportPro, what I have done, and also Phil Hepburn, who did a series called BestPrint, we can relatively quickly bundle these together to support Reporting. Not only in X# but .NET in general.

    So in essence, if we can read the VFP Report repo, it can be "interpreted" already by what is available.
    ______________________
    Johan Nel
    George, South Africa

    Please Log in or Create an account to join the conversation.

    Reporting in VFP | FoxPro 31 Oct 2019 03:38 #11546

  • lumberjack's Avatar

  • lumberjack


  • Posts: 693
  • Here are the core of all of my Report work. It emulates the ReportPro methods:



    ______________________
    Johan Nel
    George, South Africa
    Attachments:

    Please Log in or Create an account to join the conversation.

    Reporting 03 Nov 2019 15:44 #11574

  • David Martin's Avatar

  • David Martin

  • Topic Author


  • Posts: 5
  • Is there somewhere that tells us about ReportPro 2/3?

    Please Log in or Create an account to join the conversation.

    Reporting 04 Nov 2019 02:08 #11575

  • lumberjack's Avatar

  • lumberjack


  • Posts: 693
  • ivyleaguesoftware wrote: Is there somewhere that tells us about ReportPro 2/3?

    I have found this link: ReportPro documentation
    ______________________
    Johan Nel
    George, South Africa

    Please Log in or Create an account to join the conversation.

    Reporting 04 Nov 2019 05:36 #11576

  • wriedmann's Avatar

  • wriedmann


  • Posts: 2336
  • Hello,

    Is there somewhere that tells us about ReportPro 2/3?


    ReportPro was produced by the software company DataPro as Reportwriter for Visual Objects and written in Visual Objects itself. The version 2 used the VO GUI classes for the designer and the preview and is AFAIK the most used reporting tool in the Visual Objects world.
    Then DataPro released their own string typed version of GUI classes that could replace the VO GUI classes and based their Report Writer on it: ReportPro 3 exposed an ActiveX for the designer and the preview and DataPro planned to expand their market beyond the Visual Objects market.
    Now, the X# development team has taken over the support for this reporting tool (Robert knows the sources very well), and so they have a working report writer that can be adapted to changing needs without the need to rewrite one.
    Wolfgang
    Wolfgang Riedmann
    Meran, South Tyrol, Italy

    www.riedmann.it - docs.xsharp.it

    Please Log in or Create an account to join the conversation.

    Reporting 04 Nov 2019 14:37 #11583

  • David Martin's Avatar

  • David Martin

  • Topic Author


  • Posts: 5
  • Thanks for the information guys.

    Please Log in or Create an account to join the conversation.

    Reporting 08 Feb 2020 23:23 #13124

  • DexterZ's Avatar

  • DexterZ


  • Posts: 28
  • ATM here's my work around to run FoxyPreviewer "inside" winform.

    1. Install VFP9 runtime only.
    2. Still the report designing of FRX needs to be done in VFP T_T.
    3. Call or host the reporting inside Winform app using Process.

    It looks seamless and integrated inside Winform application ^_^y
    No other languages can run like a Fox! long live xBase!
    Dexter Zamora, Manila
    ManagedDbf.Blogspot.com/
    Attachments:

    Please Log in or Create an account to join the conversation.

    Reporting 09 Feb 2020 08:06 #13125

  • RRG4XS's Avatar

  • RRG4XS


  • Posts: 23
  • Hello, in the past I have produced „ a lot of paper“. But after a while I solved it different : maybe doesn’t work for everbody as it is not a one fits for all solution...

    1. Offer data which can be handled in other apps ( maybe office with ms query )
    2. Export the data as Json, xml, or... and let another app do it.
    3. If you need „live reporting „ : everybody has a browser, so produce html code which is then be handled static , dynamic with a appserver and a Webserver.
    4. If you need labels ( I have a non profit app for sport ), use the sdk of the label printer - Im using brother for almost 10 years now... -
    5. I made a prototype based on elastic stack , where Kibana is the report engine. Input is json generated by a vfp app, uploaded by logstash into a. Lucerne db.
    6. As I have also Xojo,,, but stuck with vfp, I got in a bundle Valtentina, which is more than reporting ... : I know there a re much more options on the market, some are free, for some you have to pay..
    7. Is a report really needed : I alway try to push my date into complete workflows... But ... my usecase is build and releamanagemt in large projects, to fill the gap between daily business with workflow automation and enterprise tools..
    8. Do you really need static reports ? Maybe u can offer apps, changes in workflows ....

    Just some ideas, hope they are useful.

    BR Rainer

    Please Log in or Create an account to join the conversation.

    Last edit: by RRG4XS.
    • Page:
    • 1