Page 1 of 1

Automated printing

Posted: Tue 11 Mar 2014 20:54
by billg
This is very simple common task that I cannot find a way to do. I simply need to print the output of a .rdb to a specific printer programmatically. I do not see the documentation on how to do this. This is the only reason we purchased the software.

Re: Automated printing

Posted: Wed 12 Mar 2014 11:51
by alexa
You can define a printer for a .rdb report as follows:

1. Set the focus on the .rdb document.
2. Navigate to the 'Properties' tool window.
3. Select an item of type 'Report' in the dropdown menu.
4. Click the down-arrow against the 'Printer Name' field and select a printer.

To print a report, click the corresponding button on the toolbar of the report.

Re: Automated printing

Posted: Mon 17 Mar 2014 22:25
by billg
alexa wrote:You can define a printer for a .rdb report as follows:

1. Set the focus on the .rdb document.
2. Navigate to the 'Properties' tool window.
3. Select an item of type 'Report' in the dropdown menu.
4. Click the down-arrow against the 'Printer Name' field and select a printer.

To print a report, click the corresponding button on the toolbar of the report.
This solution seems to require user interaction. I need to perform these steps programmatically. The report and printer never change. Just the data in the report changes which the .rdb file takes care of just fine. Our software needs to print the report when necessary without any user interaction. Please let me know how to accomplish this.

Re: Automated printing

Posted: Thu 20 Mar 2014 08:33
by alexa
You can call the command line interface of dbForge from your application. For this, you have to follow the procedure:

1. Design a *.rdb data report file with the GUI of dbForge Studio for MySQL.
2. Generate a report by calling the command line interface of dbForge from your application, for example:

Code: Select all

C:\Program Files\Devart\dbForge Studio for MySQL>dbforgemysql.com  /datareport /reportfile:"D:\ReportFile.rdb" /format:PDF /result folder:"D:\output\"
3. Print the resulting report with your application.

You can execute the following command in the command line prompt for help:
C:\Program Files\Devart\dbForge Studio for MySQL>dbforgemysql.com /datareport /?

Please also see the 'Data Report' section in the product's Help documentation and the following articles on our website:

http://blogs.devart.com/dbforge/how-to- ... ndows.html
http://www.devart.com/dbforge/mysql/stu ... ackup.html
http://www.devart.com/dbforge/sql/studi ... ivery.html

The 'How to create simple Data Report using dbForge Studio for Oracle?' demo video on the web page for another our product may be also helpful http://www.devart.com/dbforge/oracle/st ... -more.html

Re: Automated printing

Posted: Sat 10 Aug 2019 12:45
by Renzi
You have not answered the question. Your solution requires user interaction. I need to perform these steps programmatically without prompts and user interaction. Is there some command line function that will just print out the report directly?

Re: Automated printing

Posted: Mon 12 Aug 2019 08:59
by alexa
There is no such a possibility. Though, you can vote for the following suggestion on the UserVoice forum https://devart.uservoice.com/forums/772 ... -command-l

We collect and analyze the information from this forum in order to make a proper roadmap for the future product releases.