Show MS-Access-Report in Qt ?

Andy314

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 ?

mrjj

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

aliks-os

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

Andy314

@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

Andy314

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

aliks-os

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?

Andy314

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.

aliks-os

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.