Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

help needed in QReport

Posted on 2003-02-21
7
Medium Priority
?
447 Views
Last Modified: 2010-04-04
Hi,

I'm using Delphi 6. I would like to know how to create/draw tables using Qreport. The table will be used to store a how list of data from database. If Qreport cannot do this, what should i go about it?
 
The result would be like printing a excel document with the whole list of names with their addresses with the grids shown.

Please help me. Thank you.
0
Comment
Question by:yanlay
  • 4
  • 3
7 Comments
 
LVL 1

Expert Comment

by:khalil_moghaddam
ID: 7995613
Hi Yanlay,
you can use QuickRep1, it is so easy:

first you must Add a QuickRep to your form, then adjust paper size and bands of your output by double clicking
on it (or right click -> Report Setting)

then set DataSet Property of QuickRep to a dataset pointing to your table, add the needed label (header and footer) component from QReport Tab. If you choose a detail band from Report Setting, you must set your fields in detail bands (QRDBText). each QRDBText will point to a field to your report. each QRDBText has a DataSet Property and a DataField that must be set.
Don't forget the detail band will be repeated on a paper until no more space available, but the other band will be repeated one for a page,
0
 

Author Comment

by:yanlay
ID: 7997077
I actually use Quick report. But I face some difficulties.

Firstly, I use QRShape to draw the table, but when the data exceeded the the length of the vertical lines, the line didn't extend itself. So is there any way I can make those lines extend automatically?

secondly, I could not display the table/column headings on everypage. is it bacause it is in details page?
I try to put it in the column heading, but nothing could be seen when previewed.
0
 
LVL 1

Expert Comment

by:khalil_moghaddam
ID: 8000551
you must put the lines in detail band for extending.
you must pay attention to bands of report. the only part of report which will be extended is detail band.
if u want to add heading on every page u can add page header or title band to your report (not in detail band)
u can change band by double clicking on QuickRep.
you must pay attension to DataSet property of QuickRep! this property must be set.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Author Comment

by:yanlay
ID: 8000994
I have put the lines in the child of the detail band. However, it didin't work.

the layout of my report is something like this:
  __________________________________________
  |                                        |
  |To Mr X,                             XXX|
  |                                        |
  |Below is the table:                     |
  |________________________________________|
  |No| Name | Addr                         |
  |__|______|______________________________|
  |__|______|______________________________|
  |__|______|______________________________|
  |__|______|______________________________|
  |__|______|______________________________|
  |                                        |
  |notice that there are grid lines(horizo |
  |ntal) to distinguish each record. but i |
  |could not do that.                      |
  |                                        |
  |                               XXXXXXXX |
  |________________________________________|

So I hope I have give u a clearer picture? Thus, that is also why I cannot put a page header can I? There are other information above the table.

I hope I am not confusing you. Or maybe I do not understand what you  mean. So sorry =)

0
 
LVL 1

Accepted Solution

by:
khalil_moghaddam earned 150 total points
ID: 8004164
Follow these instruction :

1 - Place  a  QuickRep On your form
2 - Double Click On QuickRep (for Report Setting)
3 - Thick  Page Header, Page Footer And Detail band checkbox, close setting window
4 - Set DataSet Property Of QuickRep To a DataSet Pointing to your table to be reported
this table must be active
5- Place One QRDBText in detail band for each field in your table that must be reported
Set DataSet Property of QRDBTEXT to your dataset property and select datafield property of QRDBTEXT  to your field
add QRShape (for example a line, horizontal or vertical) in detail band

6 - right click on QuickRep and choose Preview. you can see repeated horizontal lines
     
0
 

Author Comment

by:yanlay
ID: 8007149
Oh thank you so mush! at least I can shows all the grids now!!!
Thank you! =)
0
 

Author Comment

by:yanlay
ID: 8007152
Thank you for solving it for me!
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses
Course of the Month15 days, 4 hours left to enroll

577 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