Skip to Content
0
Former Member
Sep 15, 2010 at 08:57 AM

Crystal Report - Parameters List

14 Views

Hi All,

I created a report in Crystal basing on two SQL commands - command1 and command2.

The command1 is fetching the employees data while the command2 is being used just

as a source for departments drop down list. When I run the report in Crystal,

it appears with a drop down list of all departments. I select a department and

click the OK button to get the results.

This works fine when I save the report on my C:\ drive but when I save the report

on my BOXI server, the drop down list disappears. When I run/refresh the report, it comes

up with a box to type in the department number instead of a drop down list.

I have seen the cascading prompt and data connection in Business View Manager and they look

fine. I have also tried to setup username and password with "never prompt" option. But it

does not make any difference on the report.

Could somebody help me in this regard?

Regards,

Zahid