command based report, not recognizing the field COMMAND.SDID(1) in selection formula

[#1]

Hi,

Currently we are using CR.NET 13 SP30 Version. And we upgrading from legacy CR11.5.

For the Selection Formula, we are using following code in CR.NET:

TestReport.DataDefinition.RecordSelectionFormula ="{DOCUMENT.SDID} = {ORDERS.SDID}";

since we have changed the report from multi-tables report to command-based report, setting the selection formula gives error while previewing the report.

Scenario:

Selection formula with multi-table report:

{DOCUMENT.SDID} = {ORDERS.SDID

After converting to command based report, Selection formula with Command-based report:

{COMMAND.SDID} = {COMMAND.SDID(1)}

since DOCUMENT and ORDERS have same field, field name SDID, converted command based report created two fields SDID and SDID(1)

Problem:

while setting the selection formula using command based report, while preview it is not recognizing COMMAND.SDID(1)

Please provide your solution.

Thanks,

Samson

[DellSC · Accepted solution]

You need to give the field that's coming in as SDID(1) an alias - Crystal doesn't recognize field names that include parentheses.

-Dell