Skip to Content
avatar image
Former Member

recordselectionformula not settable under vs2013 and windows 10

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    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.


    Add comment
    10|10000 characters needed characters exceeded

  • 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();


    Add comment
    10|10000 characters needed 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...

    Add comment
    10|10000 characters needed characters exceeded