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


QReports ...

Posted on 1998-11-08
Medium Priority
Last Modified: 2010-04-04
I want to print the contents of a table in Qreports, however I want to print certain record fields as "blank" depending on the value of other fields in the same record.

Anyone tell me (perhaps in general terms) how I might go about this.

Question by:cavalry
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
LVL 27

Expert Comment

ID: 1346151
hi cavalry,

use the event onprint of the field you want to manipulate. Maybe you must use a QRLabel-Component to do this.


Expert Comment

ID: 1346152
In the BeforePrint Event of your Detail band put somthing like this.

if MyTable.FieldByName('MyConditionField').As(some var type) = SomeValue then
  QRLabel1.Caption := 'Blank'
  QRLabel.Caption := MyTable.FieldByName('MyDataField').AsString


Accepted Solution

glabax earned 20 total points
ID: 1346153
You can put the field in the white color

if condition then

in the beforePrint event of your detail band.

Of course if you use a color printer with black paper, it doesn't work !!

Featured Post

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

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

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

721 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