Cari Blog Ini

16 April 2013

How To Refresh or Get Latest Column When Create A Report



Apply To:
* Crystal Report 9.2
* Microsoft Access 2010


Problem:

How To Refresh or Get Latest Column When Create A Report







Step - Step :


1. Example First Layout of Report





2.
Then The Table "Temp_RiskLocation_List", already update,

and there is a column that remove from the that Table, 




3.
Problem:
How To Refresh The Table "Temp_RiskLocation_List",
that already at to Report File "AN-09-002-01.rpt"


4.
Go to Report File "AN-09-002-01.rpt".

Choose menu "Database > Verify Database"




Then will display a message

"The database file "Temp_RiskLocation_List" has changed. Proceeding to fix up the report!". 

And click "OK".


Then click "OK" for message "The database is now up to date".


5. And the results, you will get the latest of column. 



Source:
Andoko Chandra