VB Crystal memory issue - VB Crystal Report

VB Crystal Report >> VB Crystal memory issue

by Mohan Kothandasamy » Fri, 22 Apr 2005 23:50:20 GMT

Hi,

I am using Crystal Reports 9.0 with VB 6.

I am using the Crystal Report method
'Report.Database.Tables(1).SetDataSource adoRecordset',
to assign data to sub reports. Please note that the
recordset is a disconnected recordset.

Crystal Report not release the system resources after
executes the report Document.
I have trried all the possible ways to dispose the
objects.

Can anyone help me to solve this problem?

Thanks.
Mohan

Top

I have an issue with Crystal 9. I saved the dsr (from existing Crystal 7 reports) to an .RPT file. I opened the rpt file in Crystal 9 and made some changes (just added space in trailer) and saved the report in Crystal 9. When I import back the rpt into Visual Basic it shows a blank report. I wanted to test one report from Crystal 7 to Crystal 9. Did any one faced the same tune?

Hello Dear I have created a report having 4-5 sub-reports, in a particular subreport, i m getting error message "MEMORY FULL" after crossing certain number of records. Since last 7-days i m trying to remove this problem but till now didnt get any solution. If anybody have any idea, then please provide the solution....... Thanks in Advance Dharmendra Jain XXXX@XXXXX.COM

Greetings, My crystal report consists of the following important fields:- *Sort field *Group field name (boolean field, which I display a count on the footer, therefore should only print TWICE) *Parameter (number used to determine the record selection) When running/previewing within the IDE and typing in the parameter it works fine and displays my data as expected. However when passing in the sort field and the parameter which is used for the record selection criteria into crystal report file/report viewer from my application, it affects the group field footer. It now appears after every single record, as if the new group field has become the unique record id (member id) rather than a deceased field (boolean) which should group the report into TWO halves as set in the report file. It has confused me as the parameters being passed through are not related to the group field in my vb.net code. I was looking into programmatically setting the group field in vb.net but looking at the class structure I don't think it can be set. So to summarise the group field a boolean was expected to print a count in the footer TWICE. Now the group footer is displayed after every single record when run using the app and NOT when using the crystal reports IDE. The only difference between me running the report through the application is that I pass in a sort order. Has anyone experienced a similar issue? Any ideas how to resolve it and/or further debug? Thanks Rob

Within my vb.net application I have viewed a crystal report and programmatically added a sort selection based on the selection of ONE radio button. This selected all the database records (member details), then using a checkbox I wanted a flag to determine if the member was deceased or not. I created a parameter field as type Boolean and then added the following to the record selection -> formula -> {Members.cDeceased} = {?paramDeceased} When testing within the vb.net crystal report layout manager and using the preview it ONLY retrieves rows when the parameter value is FALSE. If I remove the selection formula i.e. the where clause ALL rows are retrieved where deceased is TRUE and FALSE. Note: I did notice when showing SQL query the Boolean values are 0 and 1 whereas if I displayed the integer value of the checkbox in my vb.net application it is 0 and -1. Why can't I retrieve records when the value of deceased is TRUE as 100% positive records exists (as per test above and viewing the data)? Thanks Rob

VB Crystal Report, VB Crystal memory issue

VB Crystal Report >> VB Crystal memory issue