Home rbuser Comments
New Blog Posts: Merging Reports - Part 1 and Part 2

rbuser

About

Username
rbuser
Joined
Visits
1
Last Active
Roles
Member

Comments

  • I won't be upgrade for a while still, but it's good to know that it is
    fixed. I thought about using the PageStyle band, but the pages are dynamic
    meaning that it may not fill the entire page and I wanted the line to stop
    once the repo…
  • Nard,

    Because Isaac has a memo in his detail band, confining the number of bands
    does not ensure that his columns are equal lengths. My suggestion is based
    on the assumption that he wants to control the number or rows of text…
  • Isaac,

    The example you give shows that you want 4 rows of text per column.
    Assuming that each row is 0.25" in height, the total height of all detail
    bands printed is 2". If the page size allows for more detail bands then
  • Bob,

    My report prints as follows:

    Column 1 Column 2
    Row 1 Data Row 1
    Data Row 1 Data Row
    1 Data Row 1 Data
    Row 2 Data
    Row 3 Data
    Row 4 Data
    Row 5 Data

    It shoul…
  • Isaac,

    Any chance that with the band set to dynamic, all the data fits in the first
    column before it needs to wrap into the second column? If this is the case,
    you can constrain the page range that the band uses and this will…
  • Ok.

    Can you think of any reason when using top to bottom that all information
    shows up in the first column only?

  • I tried dynamic before using the top to bottom format, but all six rows
    appear in the first column and nothing in the second. The text does wrap
    correctly.

    So I changed the format to left to right which properly prints the value…
  • I belieive we are using RB 8.02 (timestamp on source files). We are using
    Delphi 7.

    I had a problem when loading a template that I thought might have something
    to do with the TppReport instance being on a DataModule. The pro…
  • Hey man, thanks for that.
    I didnt know what the TabSheets were called so I had to use the
    ActivePageIndex property. But it still worked, cheers.
  • I found the solution. As described in many replies. Use runtime packages. I
    did the following:

    In the projects option I checked the 'Build with runtime packages'. Deleted
    every thing in the Input line that becomes visible and …
  • My TeeChart 4.04 Wrapper is in Delphi 6 format. Can I get the same files in
    Delphi 7 format some where?

    /Brian
  • Hi Nico,

    Thanks, this sounds better!
    Bye
    Nicola

    Nico Cizik (Digital Metaphors) ha scritto:
  • Bob,

    Thanks for your suggestion.
    I already tried a similar approach, but I had to add a real table or
    field in our database, and I don't liked it very much.
    So I was looking for a kind of "not-dataview" approach, something…
  • Nicola,

    One approach is to create a dataview in DADE that is just there to allow
    you to create autosearch fields (i.e., never attached to a report object).
    Add a table from your database that has the appropriate field types s…
  • Hello Nico

    It seems that TppReport.Parameters can only be written by code
    or is there any way to define them from the report designer?

    For me the process should be;

    1. the user which writes the report also defin…
  • Hi, Nico

    Thanks.

    Is there any way inside of report to check the field value and change the
    color.

    for example,

    I create a variable field called OverDue

    Can I do this way through calculation…
  • Nard Moseley (Digital Metaphors) wrote:


    Of course.


    But the problem seems to be that if we have a Master-Detail relation,
    where the Master are the suppliers and the Detail are articles and
    associated total …
  • Well, thank you Bob. With that solution it works (some part). I added the
    the total price (sum(invoice.Total)) and one variable to make some
    calculations, and everything works fine. Now, the problem is that I want to
    add two more f…
  • Isildo,

    This is an SQL and not an RB issue. The following is a possible solution
    based on what you have told us:

    SELECT invoice.StockCode, vendor.Code,
    SUM(invoice.Quantity)
    FROM invoice invoice
  • The problem is that I have two tables to build the report. The first one is
    the vendor's references, which have the
    vendor code and the product code, this table stores the items that each
    vendor supplies. One vendor can supply more …
  • Isildo,

    I believe that Nard is trying to tell you that RB does not, unlike other
    reporting products, do any sorting. The SQL Select statement is all you
    have available. If you can live with a design time sort order, use DADE…
  • Well, of course I can do that in SQL (grouping, etc.), but the problem is to
    put that in a good visual approach for the user. I can do
    a SQL to show what I want, but it will repeat de supplier each line, and
    other fields. Is there a…
  • Nico Cizik (Digital Metaphors) wrote:


    As far as I can understand, Isildo don't want any RB internal sorting
    but visual ways, by using RAP, which translates into SQL order by, and
    you are saying that he can not order by a c…
  • This is how my report looks like:

    Product Total Qty Total Price
    ----------------------------------------------------------------
    Supplier: 1-Supplier xxx

    xpto - produ…
  • Mark,

    With v9, the mailmerge option on the RTF object allows you to choose your
    database fields and format them while editing the object. From RAP, use the
    LoadFromFile method to file the object from a RTF file.

    --…
  • Don,

    Nard's suggestion probably covers your situation and just in case you are
    using only a single dataview, ensure that the join between your tables is a
    left outer.

    --

    Bob

  • Hi Nard,
    thanks for reply ( i've immediately saved!!!)

    Paolo Fenelli
    AC SOFTWARE HOUSE
    NAPLES
    ITALY
  • Thanks for the idea but no go. Its still previewing perfectly but printing
    as a square white block over my background...

    glenn

  • Glenn,

    Send the rich text object to the back and you should be OK.

    --

    Bob

  • My fault. I had opened the form from the original project folder to look at
    something and was making my change to that form instead of the one inside my
    program module. Sorry for the trouble...


    glenn