Visual Studio 2010 Upgrade - Record Selection Formula not being applied

[Former Member]

I converted a Windows application that had been developed in VS2005 so that it would run in VS2010. The application contains several Crystal Reports.

What I am finding is that when the reports are run, the parameters window pops up requiring the user to specify the desired parameter values, and after the user does that and clicks OK, the report comes up ignoring the parameter values that pertain to record selection in the report.

For example, the user is asked to choose the invoice type to be displayed. But even if type 1 is chosen, all the types are displayed. I can display the actual type number, eg. 1 in the report, so I know the report is aware of what has been chosen. I can hardcode the choice in the Record Selection Formula, eg, instead of {spNewClientsInvoices;1.InvoiceTypeID} in {?InvoiceTypes} where {?InvoiceTypes} are the invoice types chosen, I can put {spNewClientsInvoices;1.InvoiceTypeID} = 1 and still get all the records, regardless of the their invoice type, appearing.

All the existing reports using record selection, that worked fine with VS2005, have this problem. I have not created a new report to see if the problem occurs in that situation as well.

[former_member183750 · Accepted solution]

I believe the instructions in 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_bi/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/scn_bosap/notes%7B6163636573733d36393736354636443646363436353344333933393338323636393736354637333631373036453646373436353733354636453735364436323635373233443330333033303331333233303334333833393335%7D.do] will help.

- Ludek