Print Page | Close Window

refresh report data (CR 8.5)

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=2828
Printed Date: 18 Apr 2025 at 10:49pm


Topic: refresh report data (CR 8.5)
Posted By: botaxpu
Subject: refresh report data (CR 8.5)
Date Posted: 05 Apr 2008 at 4:24am
Hi,
My english bad.. LOL

I have a problem,
i can export rpt to pdf using php..
but when i enter a new record to my database..
the report was not update..
untill i enter crystal report and press F5..

Here is my code :
<?php
$COM_Object = "CrystalRuntime.Application.8.5";
$my_report = "C:\\appserv\\www\\crp\\Report1.rpt";
$my_pdf = "C:\\appserv\www\\crp\\test1.pdf";

$crapp= New COM($COM_Object) or die("Unable to Create Object");
$creport = $crapp->OpenReport($my_report, 1);
$creport->ReadRecords(); // attention!

$creport->ExportOptions->DiskFileName=$my_pdf;
$creport->ExportOptions->PDFExportAllPages=true;
$creport->ExportOptions->DestinationType=1; // Export to File
$creport->ExportOptions->FormatType=31; // Type: PDF
$creport->Export(false);

$creport = null;
$crapp = null;

print "...done";
?>
I have heard that crystal report 8-latest..
doesn't have option auto refresh report data
I have heard that Crystal Report 7 much better in this case..(have option refresh report data when try to load database)...
is that right??

Please help me Guys.. Ouch

Thanx...


Print Page | Close Window