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.