Automated printing

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
billg
Posts: 4
Joined: Mon 23 Dec 2013 13:26

Automated printing

Post by billg » Tue 11 Mar 2014 20:54

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.

alexa
Devart Team
Posts: 2789
Joined: Fri 24 Jun 2011 14:17

Re: Automated printing

Post by alexa » Wed 12 Mar 2014 11:51

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.

billg
Posts: 4
Joined: Mon 23 Dec 2013 13:26

Re: Automated printing

Post by billg » Mon 17 Mar 2014 22:25

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.

alexa
Devart Team
Posts: 2789
Joined: Fri 24 Jun 2011 14:17

Re: Automated printing

Post by alexa » Thu 20 Mar 2014 08:33

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

Renzi
Posts: 13
Joined: Mon 06 Aug 2018 22:49

Re: Automated printing

Post by Renzi » Sat 10 Aug 2019 12:45

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?

alexa
Devart Team
Posts: 2789
Joined: Fri 24 Jun 2011 14:17

Re: Automated printing

Post by alexa » Mon 12 Aug 2019 08:59

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.

Post Reply