Hi
I am having a report which has calculated controls.
1. Is there any way I can filter the reported based on the value in calculated controls.
2. Also when I am exporting the report to Excel, the calculated controls do not get exported. Is there a way of achieving it.

Basically, I want to view specific records depending on value of calculated controls.

Thanx

When you make a report based on a query, you can there insert a criteria. From iff functions to simple codes as < and >.

I Hope this answers the questions you have

Good Luck

Thanx for the reply.
Actually I have based my report on a query. But I also have added some controls onto the report.
Now I want to view records based on values in these controls, the criteria for which cannot be specified in the query. For eg. I want to see records for value > 1000 only.

Hi sjaresh,

If you type > or < 100 in your creteria this will work I am sure of it. However if you want to make this an option and only apply this criteria when a user chooses so. Than just ask me and i develope the code for you so you can use it.

Kind regards,

Justin van der Raaf
Pictures2life

Hi Justin
Thanx for the reply.
Actually I want to view records based on the values in one of the calculated controls which I have brought on to the report. Thus this cannot be specified in a query.
Also if I specify any criteria in the visible property of the control, this will apply only for the control and not for the entrie record.
I hope I have been able to explain what I want.
I am also not sure whether such a thing is possible in a report.

Anyway thanx for your time

regards

Rajesh Iyer