• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 197
  • Last Modified:

How to print database?

I'm using mysql database and how can i print it easly?
0
selas
Asked:
selas
  • 3
  • 2
  • 2
  • +2
1 Solution
 
Ivanov_GCommented:
you will have to redefine your question... what exactly you want to print ?
0
 
Wim ten BrinkSelf-employed developerCommented:
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
 
esoftbgCommented:
download an example from:
page:        http://www.geocities.com/esoftbg/
  link:        Q_21088064.zip
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
Greg RowlandSoftware Designer, SysDBA, WebMaster OwnerCommented:
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
 
selasAuthor Commented:
i cant find quickreport on my Delphi 7
where can i download it?
0
 
Wim ten BrinkSelf-employed developerCommented:
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
 
Greg RowlandSoftware Designer, SysDBA, WebMaster OwnerCommented:
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
 
selasAuthor Commented:
where can i find Microsoft SQL Reports Services?
0
 
Greg RowlandSoftware Designer, SysDBA, WebMaster OwnerCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 3
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now