Executing an existing M.S Access report from Qt
-
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?
-
Hi,
Welcome to forum
You can use QProcess to call external programs.
Thanks,
-
Here is the link
-
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)
"La mort n'est rien, mais vivre vaincu et sans gloire, c'est mourir tous les jours"
~Napoleon BonaparteOn a crusade to banish setIndexWidget() from the holy land of 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)
@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.
