Home› General
ReportBuilder 22.06 now available including Delphi 12.2 support!
New Blog Posts: Merging Reports - Part 1 and Part 2

Order by problem

rbuserrbuser
edited April 2006 in General
Hi all,

I am trying to create a report to display auctions and their bids.
My problem is that the report ignores whatever I put as the order by of
the bids queries. After trying different ways this is where my report is
even though I'm no longer sure if this the right way to achieve what I
want:
-I have 4 queries: q1 to q4
-q1 is the master table with key field being AuctionNo
-q2 to q4 are expected to retrieve 3 types of bids from a table called
Bids with key fields being AuctionNo, BidNo
-Four dbpipelines are attached to these queries
-dbPipeline of the q2 to q4 have their MasterDataPipeline set to the
dbPipeline of the auction
-MasterLinkField of the child pipelines are set to AuctionNo->AuctionNo
-In the report I set up a group based on the AuctionNo field of the
auction pipeline
-Then I have 3 subreports in the detail band to display the records of
q2, q3 qnd q4
-The order by of the q2 to q4 are different from each other but it
doesn't matter because the report always orders the result by BidNo and
none of my order bys specify BidNo

Any help is very much appreciated
Thanks



--- posted by geoForum on http://delphi.newswhat.com

Comments

  • rbuserrbuser
    edited April 2006
    Ignore this message. Problem's solved. I had IndexFieldNames set
    to "AuctionNo;BidNo". I got rid of Bid_No and it is now ordering by
    correctly.



    --- posted by geoForum on http://delphi.newswhat.com
This discussion has been closed.