Crystal Reports

[harshak_b]

Crystal Reports Not Refreshing

Hello Every one

I am getting data from table and showing it thru Crystal Reports.
I have a form in VB based on the list selected from List Box the the table gets filled.
I empty the table before inserting new data.
when I call Action=1 I get old records.
I have to close it and open it again.

Suppose I change the Items in the list I emtpy the table andI fill the the table with new Items
,but I have to close n open it again.
I am using Cystal Reports 4.6

Somebody Please help me.Its urgent

[Kishore A R]

Hai,

As you get the report printed correctly when you close and open the form, it seems the data is not saved before you close the form. Try the following.

1. Commit all transactions before you print report.

2. Discard saved data by using DiscardSavedData method of crystal report control before issuing 'action=1'.

3. Open crystal report and make sure 'Save Data with report' option in File menu is not selected.

4. Verify database by selecting Verify Database option in Database menu.

I think only the first one is really important. Anyway try others also.

All the best.

Kishore.

[mihirpatel83]

I am facing the same problem....I have tried evrything....bt its not working...

Evrytime when i close my vbproject and open it again my report prints blank its only subsequent loadin of reports are printed properly

I have checked the discardSavedData option bt tat checkbox doesnt remain checked after i load the report. I have tried writing the code ie CR.DiscardSavedData = True
Also, I Save data With Report is uncheckd.....

Doing all this still i am facing the same problem...