on 09-15-2010 9:57 AM
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
BOE won't run the command to get the list of values, it waits for all parameters and then runs the report. Only option is to use a LOV to populate the list.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Zahid,
Are you using JAVA viewer for viewing the Crystal Reports?
Try using a different viewer in BOXI.
Regards
Sumit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.