Hi.
I've developed and run report successfully in the Crystal Report XI, consisting a main and four sub-report. When I upload the .rpt to the server (Central Management Console) and run the report, it complains,
"
Error in File SUMMARY REPORT: Error in formula
. 'Local NumberVar tmpCntInv; ' This field name is not known. Details:
errorKind"
----------------------
In the main report, I did normal table join and allow Crystal Report to generate the relevant SQL. However in the sub-report, I use "Add Command" function to input my own SQL statement. Below is the situation I've tested:
Scenario 1:
SELECT "TABLE1"."FIELD1" FROM "SUBFIX"."TABLE1" "TABLE1" WHERE "TABLE1"."FIELD1" = {?input1}
(Main Report (CR generated SQL))
Select field2 from table2 where field2 = {?input1}
(Sub-Report (custom SQL from Add Command))
[Failed to work... above error is displayed]
Scenario 2:
SELECT "TABLE1"."FIELD1" FROM "SUBFIX"."TABLE1" "TABLE1" WHERE
"TABLE1"."FIELD1" = {?input1}
(Main Report (CR generated
SQL))
SELECT "TABLE2"."FIELD2" FROM "SUBFIX"."TABLE2" "TABLE2" WHERE
"TABLE2"."FIELD2" = {?input1}
(Sub-Report (CR generated SQL))
[Things are working fine...]
Appreciate if anyone is able to help in this matter...