Report.RecordSelectionFormula

[Former Member]

Dear Sir,

I am facing a strange issue with regards to RecordSelectionFormula, that is when I try to assign a filter to it, its not updated. I have code as below

string filter;

filter = "({vw_ReportMemberTrxAll.TrxTypeId} = '1')";  

myDoc.RecordSelectionFormula = filter;

After I assign filter to RecordSelectionFormula its still remains empty, the RecordSelectionFormula is not updated and does not give any error.

My environment is : VS 2015, Windows 10, Asp.Net, C#.

Where else the same code works in other project in VS 2013 on another computer.

[former_member11696 · Accepted solution]

Moved to .NET forum.

Try the formula in CR Designer to validate it does work.

Don

[charles_gagnon]

Hello,

   You will need to do something like this:

Dim objFilter As New CrystalDecisions.ReportAppServer.DataDefModel.Filter()

        objFilter.FreeEditingText = "New Formula"

v_objRptDoc.DataDefController.RecordFilterController.Modify(objFilter)

Thanks.

Charles