Skip to Content
author's profile photo Former Member
Former Member

Crystal Report - Parameters List

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 15, 2010 at 12:24 PM

    Hi Zahid,

    Are you using JAVA viewer for viewing the Crystal Reports?

    Try using a different viewer in BOXI.

    Regards

    Sumit

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 30, 2010 at 03:23 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.