DanaHallenbeck
IS-IT--Management
I am using Crystal's web reports (CR8), and found that you cannot have a dropdown for multiple values in a parameter over the web unless you are using ASP. Therefore, I am trying to allow folks to enter the parameter values separated by commas. I have tried to do this with the following while loop:
pos2 := 0;
pos1 := 1;
while pos2<>pos1 do
(
if instr(pos2 + 1, {?State}, "," <> 0 then
(
pos2 := instr(pos2+1,{?State},","
state := right({?State}, pos2 - pos1);
pos1 := pos2 + 1;
)
else
(
state := right({?State}, (len({?State}) - (pos2 + 1)));
pos1 := pos2;
);
);
This is taken from some VB code I have used before. I always seem to get a zero-length string error whenever I refresh the data. Any ideas?
pos2 := 0;
pos1 := 1;
while pos2<>pos1 do
(
if instr(pos2 + 1, {?State}, "," <> 0 then
(
pos2 := instr(pos2+1,{?State},","
state := right({?State}, pos2 - pos1);
pos1 := pos2 + 1;
)
else
(
state := right({?State}, (len({?State}) - (pos2 + 1)));
pos1 := pos2;
);
);
This is taken from some VB code I have used before. I always seem to get a zero-length string error whenever I refresh the data. Any ideas?