Sorting for DataReport?

[weisi]

Hi, Im using a datareport for my report. I have the following fields in my report, "index", "name", "age" and "height". What I need is that the user are able to sort the reports, which means that they can select by "index" and "age" from and to. Is there any ways I can be able to do this?

[MartinLiss]

Moved.

[KGComputers]

Are you using MS access as your backend?

[weisi]

Are you using MS access as your backend?

Yes.

[KGComputers]

Hi,

Try creating a queries in your database and apply the criteria for sorting for index and age...Then in your data report, use the queries as your record source...

[weisi]

Mind if you can show examples? Thanks alot!

[KGComputers]

Hi....

I assume that you will be producing two reports. First is sorted by index and second is sorted by age..Just simply apply the appropriate sorting criteria in the query design view.The first query (qryindex) refer to the field index then choose the appropriate sorting criteria. Same with the query for the sorting the age..In your data environment simply add the queries/stored procedures...

[weisi]

So I write the queries in my report form? Please show any code on queries if you don't mind.

[KGComputers]

HI,

In my case the queries should be created in MS Access database window...I would normally do this to avoid too much coding..Have you tried creating queries in the MS Access database window?

[weisi]

How do I do that? Please advice!

[weisi]

HI,

In my case the queries should be created in MS Access database window...I would normally do this to avoid too much coding..Have you tried creating queries in the MS Access database window?

Please advice...

[KGComputers]

Hi,,,

So I write the queries in my report form? Please show any code on queries if you don't mind

Queries are normally done in query design view of MS Access.Just simply drag the fields of a particular table to the query design view... I assume you have some background on MS Access...Am I correct on this?

What version of access are you currently working on?

You may try searching on MS access help on how to create queries in ms access....

[weisi]

My database is in access 97.

[KGComputers]

Hi,,,


Have you tried making simple data reports in your projects using the data environment designer?

[weisi]

Hi....

I did a couple of report already. But its all standard report whereby I fix the field in the report. eg. index, age and height.