cancel
Showing results for 
Search instead for 
Did you mean: 

recordselectionformula not settable under vs2013 and windows 10

0 Kudos

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?

Accepted Solutions (1)

Accepted Solutions (1)

DellSC
Active Contributor
0 Kudos

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.

-Dell

Answers (2)

Answers (2)

0 Kudos

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...

0 Kudos

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("\n\n");
btnRecordSelectionForm.AppendText("\nWithout Comments:\n" + rpt.RecordSelectionFormula.ToString());
btnRecordSelectionForm.AppendText("\n");
//myRecordSelectionWithComments.FreeEditingText = "{TStat.TArt_Cod} = \"A823/001\"";
//rpt.RecordSelectionFormula = "{TStat.TArt_Cod} = \"A823/001\"";
//IsRpt = false;
}
else
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();

Don