TQuickRep order lookup field dataset

Posted on 2009-02-19
Medium Priority
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
  • 3
  • 2
LVL 38

Expert Comment

by:Geert Gruwez
ID: 23692126
put the order by in the query

Author Comment

ID: 23692239
Even if the dataset is BatchOptimistic?.....
LVL 38

Expert Comment

by:Geert Gruwez
ID: 23692251
depends on the database type, which you didn't mention ...
Industry Leaders: 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 14

Expert Comment

ID: 23692342
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 38

Accepted Solution

Geert Gruwez earned 500 total points
ID: 23698763
or use a VirtualTable from www.devart.com
or use a TClientDataset ...

Author Closing Comment

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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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…
This is an update to some code that someone else posted on Experts Exchange. It is an alternate approach, I think a little easier to use, & makes sure that things like the Task Bar will update.
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

571 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