TQuickRep order lookup field dataset

Posted on 2009-02-19
Last Modified: 2013-11-22
Hello everyone!!

I have a TQuickRep who I pass some datasets related between them to...and in one dataset, the one goes in rbDetail band, I have a field which is a lookup field representing an integer I use to order the data as I want..
Is there a way to order in the rbDetail band the data basing on that integer's lookup field that I could put as invisible?...

Thanks to everyone!!

P.S.: I can't modify the dataset because if I put JOINs in these dataset which are BatchOptimistic I couldn't do inserts or modifies to the data.
Question by:npuleio
    LVL 36

    Expert Comment

    by:Geert Gruwez
    put the order by in the query

    Author Comment

    Even if the dataset is BatchOptimistic?.....
    LVL 36

    Expert Comment

    by:Geert Gruwez
    depends on the database type, which you didn't mention ...
    LVL 14

    Expert Comment

    QuickReports is going to order your detail band the way that the data are ordered. If you cannot change the order of the data in your dataset (as Geert suggested)  then you will have to stage the data in a list first, sort the list and then report on that list.
    That will take longer to process, as preprocessing is necessary and it will require QuickReports Pro because you will need a TQuickAbstractRep component to report from a list rather than a dataset.
    If this approach is something you are interested in trying just say so and I will elaborate on the technique.

    LVL 36

    Accepted Solution

    or use a VirtualTable from
    or use a TClientDataset ...

    Author Closing Comment

    Good suggest: I used a TClientDataSet to solve myu issue and it worked perfectly :-)

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    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 Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    729 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now