Question Re: Record Selection Formula in Technology Q&A

Record Selection Formula

Former Member — Mon, 22 Nov 2010 10:30:47 GMT

Record Selection Formula is not working or in the Beta or the Release of Crystal. NET 2010 in runtime, at design time the report filtered properly, but at runtime when loading the report provides no filtering. Something like Cab_Albaran.Id_Albaran = is omitted when launching the report from VB.NET.

In Crystal for. NET 2008 work properly.

Any solution?

Re: Record Selection Formula

former_member11696 — Mon, 22 Nov 2010 15:10:03 GMT

Works fine for me.

What code are you using?

I'm doing either way:

rpt.RecordSelectionFormula = @"{Customer.Customer ID} < 60; // report engine

rcd.DataDefController.RecordFilterController.SetFormulaText(@"{Customer.Customer ID} < 60; // RAS

Thank you

Don

Re: Record Selection Formula

Former Member — Wed, 24 Nov 2010 10:45:38 GMT

Thanks for your reply, the code is in VB.NET and the instruction is Report.DataDefinition.RecordSelectionFormula = "{Cab_Albaran.Id_Albaran} = 32205" and completely ignores what is the same instructions that I am using in VS2005 and VS2008, but from VS2010 with the new crystal reports (Beta or Release) does not work ...

It may be some kind of error in Crystal Reports ..?

Thank you for your attention.

Re: Record Selection Formula

Former Member — Wed, 24 Nov 2010 15:43:42 GMT

I understand that this is in CR2010, but see if the KBase [1204895 - Selection formula is ignored when using Crystal Reports 2008 and VS .NET 2005|http://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes_boj/sdn_oss_boj_dev/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/scn_bosap/notes%7B6163636573733d36393736354636443646363436353344333933393338323636393736354637333631373036453646373436353733354636453735364436323635373233443330333033303331333233303334333833393335%7D.do] helps.

Ludek

Got Enhancement ideas? Try the [SAP Idea Place|https://ideas.sap.com/community/products_and_solutions/crystalreports]

Re: Record Selection Formula

Former Member — Wed, 24 Nov 2010 17:26:41 GMT

Perfect! Is working properly, thank you!

Re: Record Selection Formula

former_member11696 — Wed, 24 Nov 2010 18:51:42 GMT

Hello,

Can you clarify this for us? Did you use the Kbase article or my code to fix the problem?

Thank you

Don

Re: Record Selection Formula

Former Member — Wed, 24 Nov 2010 19:01:43 GMT

I settled with the guidelines of the Kbase article, eliminating the lines of initialization.

Thanks again.

Re: Record Selection Formula

Former Member — Tue, 17 May 2011 21:09:55 GMT

I am not able to access this KB, can you please help. I get a 404 error.

Re: Record Selection Formula

Former Member — Tue, 17 May 2011 21:16:29 GMT

Enter the KB number in the search box at the top right corner of this web page. That will return the KB.

- Ludek

Re: Record Selection Formula

Former Member — Sun, 29 May 2011 22:21:54 GMT

I'm also having the same issue with Record Selection. And, I also am unable to access the KB article and receive a 404 error. Entering the KB number in the search box returns 4 references -- all pointing to forum articles and none pointing to the actual KB article. Fortunately, one of the forum articles seems to give the secret answer of commenting out two lines in the designer file (viewer.SelectionFormula and viewer.ViewTimeSelectionFormula).

DaveL5

Re: Record Selection Formula

Former Member — Mon, 30 May 2011 14:20:49 GMT

Here is a copy of the KB:

Symptom

When upgrading a VS .NET application to use Crystal Reports 2008 in Visual Studio .NET 2005, the selection formula (.RecordSelectionFormula) is ignored.

Cause

In Visual Studio .NET 2005, when the Crystal Windows Form Viewer is added to a Windows Form, the auto-generated code adds two lines of code that set the selection formula to an empty string (""). The viewer's SelectionFormula and ViewTimeSelectionFormula are set to "" by default, thus, the application will ignore selection formulas, be it in the report designer or passed to the report at runtime.

Resolution

To resolve the issue, follow these steps:

Expand Form1.vb|cs to show Form1.Designer.vb|cs.

Double-click on Form1.Designer.vb|cs to show it's code.

In the InitializeComponent method, you will find code where the CrystalReportViewer1 properties are set.

Comment out or delete the following two lines:

this.crystalReportViewer.SelectionFormula = ""

this.crystalReportViewer.ViewTimeSelectionFormula = ""

- Ludek

Re: Record Selection Formula

Former Member — Mon, 23 Jan 2012 18:42:17 GMT

Worked!

Thanks a lot!