We help IT Professionals succeed at work.

TQuickRep order lookup field dataset

npuleio
npuleio asked
on
Medium Priority
514 Views
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!!
Luigi

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.
Comment
Watch Question

Geert GOracle dba
CERTIFIED EXPERT
Top Expert 2009

Commented:
put the order by in the query

Author

Commented:
Even if the dataset is BatchOptimistic?.....
Geert GOracle dba
CERTIFIED EXPERT
Top Expert 2009

Commented:
depends on the database type, which you didn't mention ...
CERTIFIED EXPERT

Commented:
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.


Oracle dba
CERTIFIED EXPERT
Top Expert 2009
Commented:
or use a VirtualTable from www.devart.com
or use a TClientDataset ...

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Good suggest: I used a TClientDataSet to solve myu issue and it worked perfectly :-)
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.