×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

crystal Viewer not refreshing

crystal Viewer not refreshing

crystal Viewer not refreshing

(OP)
I have a report that is viewed by supervisors
There are 3 parameters on this report.
technician name - which is a dropdownlist
start date - text field
end date - text field

the supervisor selects a techicians name from a dropdownlist and enters in a start and end date to view report.  The report shows but when the user attempts to change the technician parameter and view the report the report shows the same data from the previous technician  

RE: crystal Viewer not refreshing

the whole refresh report thing is non functional in my experience, even the report.database.tables[index].dispose() method does didly squat. I solved this by reloading the report when it "hasRecords" or whatever the value is, between capturing the new parameters and relaunching the report. Here is snippet, hope it helps:
 
  if (thisReportChild.HasSavedData)
            {
                thisReportChild = new ReportDocument();

                try
                {
                    thisReportChild.Load(FullFileLocation);
                }
                catch
                {

                }
            }

RE: crystal Viewer not refreshing

just a side note, on my development machine, I was getting an an occational value of true from HasSavedData even on first pass if I was relaunching a debug instance. This indicates that the garbage collector was NOT working, even 20 to thirty seconds later. I was also getting an unhandled exception on shut down of my application. I solved this by setting the reportDocument = null, and explicitly killing the crystal viewers current documnent instance when the form with the viewer closed.  

RE: crystal Viewer not refreshing

also a side note, dont let the report talk to the database. It does it poorly. Get the datatable and hand it to the report.

RE: crystal Viewer not refreshing

You are not telling us what viewer you are using.  Chances are that something is wrong with your code (if you developed the viewer) or that you are using the free Crystal 2008 viewer, which can't refresh.  There are many free/inexpensive 3rd-party viewers that can refresh.

hth,
- Ido

view, export, burst, email, and schedule Crystal Reports.
www.MilletSoftware.com

RE: crystal Viewer not refreshing

@IdoMillet
you are correct, my suggestions assume ABetha is using

CrystalDecisions.CrystalReports.Engine
        and
CrystalDecisions.Windows.Forms.CrystalReportViewer

Cheers
++J

RE: crystal Viewer not refreshing

(OP)
@IdoMillet
I am using the Crystal 2008 viewer  

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close