Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How to print database?

Posted on 2004-08-10
9
Medium Priority
?
176 Views
Last Modified: 2010-04-05
I'm using mysql database and how can i print it easly?
0
Comment
Question by:selas
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +2
9 Comments
 
LVL 12

Expert Comment

by:Ivanov_G
ID: 11760845
you will have to redefine your question... what exactly you want to print ?
0
 
LVL 17

Expert Comment

by:Wim ten Brink
ID: 11760963
1) Use a report writer. Rave Reports, QuickReports, QuickReports, they're all nice report generators.

2) Write your own report generator, walking through all the data you need and printing it to the printer. A helluvajob but very satisfying once it's done. Then another helluvajob if you change a field type in your table.

3) At http://delphi.icm.edu.pl/authors/a0000237.htm you can find DSP75 which is the Data Structure Printer. This can print structures of many different databases. You need an ODBC driver for MySQL in this case, though.
0
 
LVL 12

Expert Comment

by:esoftbg
ID: 11763372
download an example from:
page:        http://www.geocities.com/esoftbg/
  link:        Q_21088064.zip
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 4

Expert Comment

by:Greg Rowland
ID: 11765555
Printer.BeginDoc;

procedure TApPrintChecksf.myTextSimple( myString: String; x, y: Real);
var
 PixX, PixY, Size: Integer;

begin
 Printer.Canvas.Font.Color := clBlack;
 Printer.Canvas.Brush.Color := clWhite;
 Size := Printer.Canvas.Font.Size;
 PixX := Round((x + myX)* PrinterDPIx) - xMargin;
 PixY := Round(((y + myY) * PrinterDPIy) - (Size * 1.5) - yMargin);

 Printer.Canvas.TextOut( PixX, PixY, myString);


end;

  Printer.EndDoc;

0
 

Author Comment

by:selas
ID: 11770870
i cant find quickreport on my Delphi 7
where can i download it?
0
 
LVL 17

Accepted Solution

by:
Wim ten Brink earned 2000 total points
ID: 11772342
QuickReports is a commercial product and has been replaced by the Rave Report designer since QuickReports wasn't performing that well. QuickReports is still inside Delphi 7, though. Delphi 7 does not automatically install Quick Report components.

Here's what to do to get the QuickReports components on the Delphi 7 Component Palette. You need to install the QuickReports package (dclqrt70.bpl). In Delphi, select Component | Install Packages. Click Add and select the file dclqrt70.bpl (found in the Delphi7\Bin directory). Click Open and then click OK.
0
 
LVL 4

Expert Comment

by:Greg Rowland
ID: 11772433
Quick reports are more trouble than they’re worth. After committing a lot of time becoming familiar with the components, it was found that column totals on tabular reports were incorrect.

We are now using “Microsoft SQL Reports Services” with a high degree off success. It is rumored that “Microsoft SQL Reports Services Version 2” will support none server environments.
0
 

Author Comment

by:selas
ID: 11773772
where can i find Microsoft SQL Reports Services?
0
 
LVL 4

Expert Comment

by:Greg Rowland
ID: 11773878
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

662 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question