How to Overcome Flickering Effect

Hello Friend,

I am using Data Reports.. Dynamically I am setting the where condition using a parameter value in the Command Object. When I issue the Refresh Method of the Data Report it is causing a flickering effect , which is spoiling the outcome.
I tried in all possible ways like making the Report visible false .. and then making it true, next calling the doevents , and also calling the Sleep API for some milliseconds.. But finally none of them worked out.. Can u help me out in this regard..

This is very very urgent..

Regards

Prasad

[Dr_Michael]

I don't know if this is an answer to your question, but try to use "where" into filter property...

Michael Vlastos
Automation Engineer
Company Modus SA
Development Department

Hello Dr. Michael,

Thank u for ur prompt reply...

I declared my query in Command Object as follows

parameters param1 long ; select status,clerking_date,system_codes,cstr(description),problem_status,present from history_examination_view where clerking_date = param1

After this I am passing my argument to the parameter as follows

DataEnv.Commands("HISTORY_EXAMINATION_VIEW_Grouping").Parameters("Param1").Value = consultdate

DataEnv.Commands("HISTORY_EXAMINATION_VIEW_Grouping").Execute

If DataEnv.rsHISTORY_EXAMINATION_VIEW_Grouping.State = adStateClosed Then

DataEnv.rsHISTORY_EXAMINATION_VIEW_Grouping.Open

Else

DataEnv.rsHISTORY_EXAMINATION_VIEW_Grouping.Requery

End If

HistExamReport.Refresh


Here the refresh method is creating the flickering effect .. How to overcome this..

Please let me know immediately

Regards

Prasad

[Dr_Michael]

Try something like this:

if DataEnv.Commands("HISTORY_EXAMINATION_VIEW_Grouping").State = adStateOpen then
DataEnv.Commands("HISTORY_EXAMINATION_VIEW_Grouping").Requery
end if
DataEnv.Commands("HISTORY_EXAMINATION_VIEW_Grouping").filter="..." 'here you write the where statement






Michael Vlastos
Automation Engineer
Company Modus SA
Development Department

[Dr_Michael]

if DataEnv.rsHISTORY_EXAMINATION_VIEW_Grouping.State = adStateOpen then
DataEnv.rsHISTORY_EXAMINATION_VIEW_Grouping.Requery
end if
DataEnv.rsHISTORY_EXAMINATION_VIEW_Grouping.filter="..." 'here you write the where statement









Michael Vlastos
Automation Engineer
Company Modus SA
Development Department

Hello Dr. Michael,

I tried as u said .. This is my piece of code written

If DataEnv.rsHISTORY_EXAMINATION_VIEW_Grouping.State = adStateOpen Then

DataEnv.rsHISTORY_EXAMINATION_VIEW_Grouping.Requery

End If

DataEnv.rsHISTORY_EXAMINATION_VIEW_Grouping.Filter = "Clerking_Date = " & consultdate

Now when I executed the report it was not refreshing the report with the filter
condition.. so I included the Refresh method of the Data Report

HistExamReport.Refresh

After this has been written it is causing the flickering effect , but the output is exactly what I want .. It is getting filtered.. No problem about the output.. But still the problem is persistent.. How to overcome this..

Please once again just look into this ..

Regards

Prasad

[Dr_Michael]

Try NOT to include Refresh method. Although you think it doesn't refresh, I think it DOES. In order to test it, make the .exe file and run the exe. Is it right now or not?

Michael Vlastos
Automation Engineer
Company Modus SA
Development Department

Dear Mr. Michael,

As U said there is one Bug with Data Reports.. I think it may be for some reason.. But what i observed it unless the Refresh method is called the filter condition is not going to get affected..

How about coming on MSN Messenger my email-id is ([email protected]) .. If u have ur hotmail account please send it in ur next mail..

Thank U for ur kind interaction.

Expecting u on MSN

Bye

Prasad