Generating param from .xls with > 1000 rows

[huytonscouser]

I have .xls input file, 1 column, ~3500 rows, that changes daily.

Serial-dev name
"192603520-3666",
"192603520-3668",
"192603520-3669",
"192603520-366A",
"192603520-366B",
"192603520-366C",
.
.
.



Currently i break up the column into batches of 1000, and prepare a formula like:-


If {SRMARRAY.ARRAYALIAS}+"-" +{SRMARRAYDEVICE.ARRAYDEVICENAME}
=["192603520-3666",
"192603520-3668",
///1st 1000 rows

]
THEN "Yes"

ELSE IF {SRMARRAY.ARRAYALIAS}+"-" +{SRMARRAYDEVICE.ARRAYDEVICENAME}
=["192603520-4021",
"192603520-4023"
// next 1000 rows
]
THEN "Yes"

ELSE IF {SRMARRAY.ARRAYALIAS}+"-" +{SRMARRAYDEVICE.ARRAYDEVICENAME}
=["192603520-9821",
"192603520-9822",
/// next 1000 rows
]

THEN "Yes"

ELSE "No"


Is there a way to build a param directly from .xls that contains all 3500 rows ? or am i limited
to array size of 1000.
My goal would be to prepare the input param? , and then link it to a sub-report.

underlying db is Oracle 10g.

 

[CoSpringsGuy]

would it be feasible to split your data in excel
Excel Column2 Excel column3
192603520 3666
192603520 3668
192603520 3669
192603520 366A
192603520 366B
192603520 366C
use that as a table and link (left outer join) to your oracle table?



_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection

 

[huytonscouser]

Yes, i've tried that but its so incredibly slow, thats why i tried to create a formula.

Thanks.