asked on

sorting records at runtime for vb datareport

I have a data report that I have created using data designer with data environment in vb thats select three fields from the same database table. Spaceno, rent, Name. By default when showing the report the space no is sorted(ascending order). How can I program where a user can sort by the name at run time. The user will select that they want to sort by name using a drop down box. I know I can create a seperate report sorted by name and one sorted by spaceno but if the user can select at runtime that would be great.

ASKER CERTIFIED SOLUTION

rsriprac

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

CvD

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

CvD

I don't agree with you on this, since rsriprac doesn't supply a solution to the question asked. Captain27 asks for a interactive solution in runtime and I am the only one providing him with that solution. Rsriprac provides a static solution on compiletime, containing several forms and thus reports.

Vaya con Dios,
CvD

rsriprac

I disagree CvD, it prefectly answers the question. It is only ONE form (I said 'a form') that calls multiple reports. This works prefectly fine so that "user can select at runtime".

I'm sorry but you are wrong about my answer.

-Ram

CvD

Ok, you might be correct there. Some remarks though...

The solution you provide was what the user was able to do already.
Quote: "I know I can create a seperate report sorted by name and one sorted by spaceno but if the user can select at runtime that would be great."

The solution I am providing aims at just what the questioneer wants. A solution at runtime, without the need of creating different reports.

But then again, Im not gonna fight you over 25 points.

Vaya con Dios,
CvD