Show MS-Access-Report in Qt ?



  • For Qt exists not really a powerful reporting-tool, compared to Micrcosoft-Access. Therefore I use Access for complex reports. I figured out how to control Access from outside to show here a external report page. But this is really a professional way. I it possible to embed (show) one or more Access reports in a QDialog directly.
    Has someone found a solution ?


  • Qt Champions 2016

    Hi
    Will all end users of your app have Access Installed?

    The actual Report windows seems not be exported
    https://msdn.microsoft.com/en-us/library/office/ff192120.aspx
    So not sure its possible in any easy way.

    There might be a way using
    Microsoft Report Viewer as they used (2009-ish) to export the drawing areas as
    com object, but i am not sure if 1) still the case 2) works with Access rapports.

    https://www.microsoft.com/en-us/download/details.aspx?id=45496



  • There is a third party report toolkit for Qt. Please check QtRPT



  • @mrjj said in Show MS-Access-Report in Qt ?:

    Hi
    Will all end users of your app have Access Installed?

    If only runtime is need is best - but if Access (for 100 €) is needed it is ok, too.

    The actual Report windows seems not be exported
    https://msdn.microsoft.com/en-us/library/office/ff192120.aspx
    So not sure its possible in any easy way.

    There might be a way using
    Microsoft Report Viewer as they used (2009-ish) to export the drawing areas as
    com object, but i am not sure if 1) still the case 2) works with Access rapports.

    It seem Sql-Server is needed, but I will check it.

    https://www.microsoft.com/en-us/download/details.aspx?id=45496



  • Hi @aliks-os ,
    do you have experiences with it?
    Is it possible to collect multiple SubReport to one Report

    For example:

    Report0 - total report
       Report1-sub of 0                      Report2-sub of 0
                                                   Report3 -  Sub of Report2                                                
                                                  (resizes vertical by its context and moves Report4 to bottom)
       Report 4-sub of 0
    


  • I am a developer of QtRPT.
    There is a possible to make some grouping of any field by some value.
    And final result will be as you show me

    Did you look at the examples of the report at main page?



  • Hi @aliks-os ,
    the features of grouping is clear, but that is not what I need and what is the real power of Access. The Reports can be independent Subreport which I can put to any place on a report - put them side by side (horizontal !) with a frame around it, etc. The height of a Subreport increases depending of its content and shifts all element below this subreport.

    Simple Example: I have 2 independent lists which I put in 2 SubReports.

    List1                 List2
    Element1         Element1
    Element2         Element2
                              Element3
    

    I dont know how to make this with grouping.

    The shown examples are very simple reports, I dont know if it shows the full power of QtRpt.



  • yes, there is not sub-reports system in it. In this case the planning of report construction is different from Access. First of all, I'd like to ask you, what source of yours data? Is it a SQL DB? if yes, you can write a SQL query, which result will contains a data of both lists. Or you want to get data from XML? or you want data from application after processing?

    If you don't want use a SQL query - you can write a own logic on Qt/C++ and draw elements in that order that needed for you. In any case, you should read API, documentation of QtRPT and understand what it can and what you want to do.


Log in to reply
 

Looks like your connection to Qt Forum was lost, please wait while we try to reconnect.