Solved

How to print database?

Posted on 2004-08-10
9
163 Views
Last Modified: 2010-04-05
I'm using mysql database and how can i print it easly?
0
Comment
Question by:selas
  • 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
 
LVL 4

Expert Comment

by:SurferJoe
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

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 500 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:SurferJoe
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:SurferJoe
ID: 11773878
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

911 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now