Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

QuickReport 1.1 Problems

Posted on 1998-01-15
6
Medium Priority
?
332 Views
Last Modified: 2013-11-22
I'm having problems with two things when printing reports.  First, the DBMemo adds 6-7 lines of blank space when printing and runs into the next band.  To be more specific, I have a Paradox memo field, which is right above the detaillink band.  If the Memo's data gets too long, it will stretch down the page (which it should) but it doesn't 'push' the detailband further down the page - so it writes 'over' the detaillink band.  Is this a bug? and how do I fix it (without moving to QR2).


Secondly, I can't figure out how to align DBText fields so that one field doesn't print over another in the QR Labels template. Below is the layout & problem.

FName LName       --------------> Layout
Address
City, State Zip

Jim Sample    ------------>Prints ok because he has a short name
123 Anywhere
Miami , FL 33333

StephaJohnson  -----------> Fields overlap due to long names
53773 Anywhere
San AntoniTX 30089     ------> Here too!

I don't want to set a fixed width field because I'd have the exact opposite problem - too much space in-between fields.
0
Comment
Question by:d4jaj1
[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
  • 3
6 Comments
 
LVL 8

Accepted Solution

by:
ZifNab earned 200 total points
ID: 1356863
I can't give you an answer for the first at the moment. Look at QR wabpage for answer or look for an update of QR.

 Or the detailbands and the detaillinkband linked to each other?

Second, do this :

 1. remove DBFName and DBLName
 2. instead place a normal text field (non DB) (e.g. TextName)
 3. In the beforeprint of the band, write this :
 
    TextName := DBFName + ' ' + DBLName;

    where DBFName (=datafield of fName)
          DBLName (=datafield of lName = Table1.FieldbyName('LName').AsString

 This is the only solution to your problem, I think.
   
0
 
LVL 3

Author Comment

by:d4jaj1
ID: 1356864
I'm using the latest version of QR for D2, (version 1.1) and the Detail Band & Detail Link are linked correctly.  Does this happen to you?

As for the second problem, I don't think I really understannd your code.  My example below compiles ok, but doesn'tt print out the name.

procedure TQRLabelsForm.DetailBeforePrint(var PrintBand: Boolean);
var
 fn,ln:    string;
begin
 fn := Table1.FieldbyName('FirstName').AsString;
 ln := Table1.FieldbyName('LastName').AsString;
 edit1.text := fn + ' ' + ln;
end;

0
 
LVL 8

Expert Comment

by:ZifNab
ID: 1356865
I use QR 2.0j

edit1.text has to be a label component on your qr-form :

qrLabel1.caption := fn+' '+ln;
                         
0
Independent Software Vendors: 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!

 
LVL 3

Author Comment

by:d4jaj1
ID: 1356866
Okay, I just installed QR2 and it doesn't allow me to change the width in the multi-column report (Labels).  It appears the report takes the page Width and divides it by the total # of columns to get the column length.  Even if I chnage the Width in teh Properties dialog box, QR changes it back.  Is there a way to fix this.  I know I can use the ColumnSpace to shorten the width, but that adds space inbetween the labels.

To make my question more clear, can I:

Create a 3 column report with, each column 1 inch wide and left justified on the page (the columns left justified, not the text in the columns).

Thanks.
0
 
LVL 8

Expert Comment

by:ZifNab
ID: 1356867
That I don't know.
Maybe make page width 3 inches.
Or put 3 labels of 1 inch each next to each other and manually fill them.
0
 
LVL 3

Author Comment

by:d4jaj1
ID: 1356868
Make the page width 3 inches is the answer, however, you will have to calculate the Left Margins, Column Space, # of columns manually to generate a correct page width to really make a customized report.
0

Featured Post

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

636 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