Skip to Content

recordselectionformula not settable under vs2013 and windows 10

Mar 30, 2017 at 07:33 PM


avatar image
Former Member

I have visual studio 2013 with crystal report for Vs and crystal report 2013.Under windows 7 always works fine

I've recenty bought a new windows 10 64 bit pc and reinstalled all software. Recordselection formula seems not to work. In some cases the selection in not applied and ALWAYS from then IDE of visual studio recordslectionforlmula does not keep the filter I set, I always see an empty string.

Any idea?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Best Answer
Dell Stinnett-Christy Apr 27, 2017 at 06:02 PM

Windows 10 was not supported until, I believe, SP15 of CR for VS. The current SP is 19 and SP20 is due out soon. If you need to work with Windows 10, you'll need to upgrade the version of the CR for VS that is used to develop the application that's running reports. You cannot just install the new runtime and run an application created with an older version of the SDK.


10 |10000 characters needed characters left characters exceeded
Don Williams
Apr 03, 2017 at 05:37 PM

It should work fine, if it fails it could be your database connection is not correct and failing.

Try this:

// Record selection formula with comments included can only be retrieve via RAS
CrystalDecisions.ReportAppServer.DataDefModel.ISCRFilter myRecordSelectionWithComments; // = new CrystalDecisions.ReportAppServer.DataDefModel.;
myRecordSelectionWithComments = rptClientDoc.DataDefController.DataDefinition.RecordFilter;
if (myRecordSelectionWithComments.FreeEditingText != null)
//myRecordSelectionWithComments.FreeEditingText = rptClientDoc.DataDefController.RecordFilterController.GetFormulaText();
btnRecordSelectionForm.Text = "\nWith Comments:\n" + myRecordSelectionWithComments.FreeEditingText.ToString();
btnRecordSelectionForm.AppendText("\nWithout Comments:\n" + rpt.RecordSelectionFormula.ToString());
//myRecordSelectionWithComments.FreeEditingText = "{TStat.TArt_Cod} = \"A823/001\"";
//rpt.RecordSelectionFormula = "{TStat.TArt_Cod} = \"A823/001\"";
//IsRpt = false;
btnRecordSelectionForm.Text = "No Record Selection formula";

//rpt.RecordSelectionFormula = @"(if {rpt_PI_Reports;1.pi_mu_report} = 'sum' then uppercase(trim({rpt_PI_Reports;1.contractor})) <> 'UNCOMMITTED: ADDON' else {rpt_PI_Reports;1.pi_number} <> '9999999') and {rpt_pi_reports;1.tenant_id} in [2873,2884,2889,2891,2893,2894,2901,2909,2910,2911,2912,2913,2914,2915,2916,2917,2943,2944,2945,3379,3380,2946,2971,2972,2994,2997,2998,2999,3005,3006,3025,3026,3027,3028,3032,3033,3038,3039,3046,3047,3048,3049,3050,3051,3063,3089,3090,3098,3099,3100,3120,3137,3138,3165,3168,3170,3171,3190,3194,3195,3204,3205,3246,3247,3248,3255,3256,3262,3263,3265,3266,3272,3273,3277,3278,3293,3294,3295,3296,3298,3300,3301,3306,3317,3325,3326,3327,3330,3331,3336,3337,3338,3341,3346,3347,3360,3361,3364,3376,3377,3378]";
//btnRecordSelectionForm.Text = rpt.RecordSelectionFormula.ToString();


10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Apr 21, 2017 at 04:26 PM

It's a bug of the last released.

I've reinstalled Windows 8.1 and the full package of visual studio and sap because I belived it was a problem with the new os.

So, new fresh os with no other software

Same resul: selection formula is ignored and from the visual studio debugger the selectionformula property is Always emply and no way to set any values.

So I removed sap and install and old version CRforVS_13_0_12 .With this one all works fine.

So upgraded to the last version and the problem came out again. Remove and reinstall 13_0_12 and work fine again.

Then I restored Windows 10 from previuous backup, remove CRforVs, install versione 13_0_12 and even under Windows 10 works fine.

So I am quiet sure it's a bug...

10 |10000 characters needed characters left characters exceeded