Executing an existing M.S Access report from Qt

[Trinesh Govender]

Hi Guys

I have many reports already created on M.S access, I would like to call these reports from my program.

How can I accomplish this?

[Pradeep Kumar]

Hi,

Welcome to forum

You can use QProcess to call external programs.

Thanks,

[Pradeep Kumar]

Here is the link

http://doc.qt.io/qt-5/qprocess.html#details

[VRonin]

Unfortunately MS office does not offer a command line interface so QProcess alone can't do it.

Either you create a macro inside Access that launches the report and use QProcess to launch the macro or you link to .Net (using C++/CLI) and use something like this: http://www.codeproject.com/Articles/22195/Print-Microsoft-Access-Reports-from-C (translating from C# to C++/CLI should be pretty straightforward)

[Pradeep Kumar]

@VRonin said in Executing an existing M.S Access report from Qt:

Unfortunately MS office does not offer a command line interface so QProcess alone can't do it.

Either you create a macro inside Access that launches the report and use QProcess to launch the macro or you link to .Net (using C++/CLI) and use something like this: http://www.codeproject.com/Articles/22195/Print-Microsoft-Access-Reports-from-C (translating from C# to C++/CLI should be pretty straightforward)

Information provided is ellaborated and nice, thanks for the info.