11/25/2024 5:38:40 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.
|
|
|
|
Report seems to 'Cache' data, is not reflecting updated information
Posted: 06 Jan 09 3:51 PM
|
Really strange issue. I am creating a report using Application.BasicFunctions.GetCrystalReport, saving it to a PDF and then attaching the file. Everything works fine the first time I run the report but when invoking the report a second time after updating some data I do not see the updates in the reports. If I do a Ctrl-F refresh and invoke the report again I get the correct data. It's like it is using the same RDC object until it is killed via refresh.
Code that generates the report (SLX 7.2.2):
If FSType = "Final" then
Set CRXReport = Application.BasicFunctions.GetCrystalReport("Child:FabSpec")
Else
Set CRXReport = Application.BasicFunctions.GetCrystalReport("Child:FabSpec Draft")
End If
Dim strSelectionFormula
strSelectionFormula = "{C_FABSPEC.C_FABSPECID} = '" & ebFABSPecID.Text & "'"
CRXReport.RecordSelectionFormula = strSelectionFormula
CRXReport.ExportOptions.DestinationType = 1
CRXReport.ExportOptions.DiskFileName = strReportFile
CRXReport.ExportOptions.FormatType = 31
CRXReport.Export False
Set CRXReport = Nothing
|
|
|
| |
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|