[b]Dynamic cascading parameter[/b] 1

[abcraj75]

Hi,
can anyone help me with cascading dynamic parameter in Crystal Reports 2008. I am using a cascading parameter (2 prompts in one parameter screen) namely; param1 (string) for "name" field and param2 (datetime) for "date" field. Both the fields, name and date are from the same table "price". In the record selection formula I equated both parameters to the respective fields, i.e.

{?Param1- NAME}={PRICES.NAME}and
{?Param2-DATE}={PRICES._DATE};

The cascading prompt opens with both the prompts, but the problem is the first prompt (param1) displays only 5 record values instead of 20. I also tried to use the formula in it:
Local StringVar a := "";
Local NumberVar i;
For i := 1 To Ubound({?Param1-NAME}) Do
(a := a + ", " + {?Param1-NAME});
a

But now there is a error "invalid string function.

I cannot decipher what the problem is can someone suggest how I could have all the records displayed in the first cascading prompt? Thanks

 

[lbass]

Please do not start multiple threads on the same topic.

-LB

 

[abcraj75]

Sorry can you pls help me with my issue

 

[abcraj75]

PLEASE IGNORE THIS THREAD.... I AM NEW TO THE WORLD OF FORUM AND THREADS. KINDLY REPLY TO THE OTHER THREAD ONLY...PLEASE