We help IT Professionals succeed at work.

Data Report

TinasheC
TinasheC asked
on
My data report is producing the same data everytine, dispite that the base table changes the data, for example if i produce report based on the base table with three records, my program is adding say 500 records more to the table, unload  the report and load it again, to my surprise the report still have the other 3 records (and they do not exist in the base table), I am using the microsft ole provider for odbc to connect to  my db.
Comment
Watch Question

Suat OzgurWeb / Application Developer
CERTIFIED EXPERT

Commented:
I suggest checking this link.

http://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=11826699

Also suggest not using Data Reports for complicated report designs.

regards
suat
Commented:
i had the same problem
my solution:

Public Sub ShowErrors()


If deReportEngine.rscmErrorLog.State <> 0 Then
  deReportEngine.rscmErrorLog.Close
End If

deReportEngine.cmErrorLog
deReportEngine.rscmErrorLog.Requery

rptError.Refresh
rptError.Show vbModal
Unload rptError
Set rptError = Nothing
Exit_:
  Exit Sub
Error_:
  Dim luError As guError
  luError = ErrToUDT
  Call CatchError(luError, "CReports", "ShowErrors")
  Resume Exit_

End Sub
Suat OzgurWeb / Application Developer
CERTIFIED EXPERT

Commented:
TinasheC, do you think asking more or closing this question if you got the idea?

suat

Explore More ContentExplore courses, solutions, and other research materials related to this topic.