Hi there,
I am using crystal 11 with SQL server, I have a created a report with ODBC having dynamic parameter, I need to create two dynamic parameters in such a manner that second parameter’s data values should depends on the value of first one. I mean second parameter should be the dependent parameter of the first one. i.e.
First parameter is Customer and second parameter is Customer contact names, If I select customer ‘Verizon’ then it should show only the list of contact list of Verizon in the second drop down list.
My second problem is I have created a report with dynamic parameter but whenever I refresh my report it always give me menu to enter backend database ID and password. When I do the same report with static parameter it only says one time when I verify my database. I don’t want to see ODBC-database ID and Password on each refress.
I will appreciate if somebody will help me to resolve these iseues.
Maulae.
I am using crystal 11 with SQL server, I have a created a report with ODBC having dynamic parameter, I need to create two dynamic parameters in such a manner that second parameter’s data values should depends on the value of first one. I mean second parameter should be the dependent parameter of the first one. i.e.
First parameter is Customer and second parameter is Customer contact names, If I select customer ‘Verizon’ then it should show only the list of contact list of Verizon in the second drop down list.
My second problem is I have created a report with dynamic parameter but whenever I refresh my report it always give me menu to enter backend database ID and password. When I do the same report with static parameter it only says one time when I verify my database. I don’t want to see ODBC-database ID and Password on each refress.
I will appreciate if somebody will help me to resolve these iseues.
Maulae.