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

CRS 2008 -Reports with Dynamic Parameters

Hey Fourmies,

I seem to have a problem with reports with parameters.

In the reports developer, when i set up a dynamic parameter and refresh the report, it asks if i want to use current parameter value or to prompt for parameter value when I select the prompt for parameter values if works fine and a pop-up comes up with all the parameter values - i select one or many and all is fine.

When i upload the report into Crystal Reports Server i configure the database options -again fine, when i go into configure the parameters i see a button with Edit, Clear Value and some checkbox.

I click on edit and, as far as im aware a db config prompt is to come up here but it does not, all that comes up is an empty parameters form, i click ok anyway and the report is incorrectly configured.

I open report in InfoView and a pop-up comes up asking to select the parameters from an EMPTY list.

Please does anyone know whats going on here?

CRS2008 Linux version.

Regards....

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Dec 18, 2008 at 05:01 PM

    Not really enough information to tell, but it would appear you are not connecting to the database to run the dynamic LOV query. Maybe this will help get you started -

    When saving a report with dynamic parameters to the enterprise, you are creating a Business View (BV). The BV contains a handful of repository objects, including a data connection that is created solely to run that LOV query. The data connection credentials (user/password) are not saved when you save the report. To view and modify these properties, you will need to use the Business View Manager from a windows machine - it should be part of a client install.

    So beyond the data connection itself (which you should verify works on the server outside the XI application), the dynamic parameters LOV query is run by the Report Application Server (RAS). The RAS runs the query against the database and returns the values. You then select a value from the list, and run the report. So ensure that RAS is up, running, enabled, and the account used to start it has access to whatever database middleware you are using.

    Add a comment
    10|10000 characters needed characters exceeded

    • Alan,

      You should not have to schedule dynamic parameters for success. They can be run on demand. When they are run on demand, they use the Report Application Server. So if there is any need to run processing servers as a domain account in order to access reporting databases, you need to include the RAS in this.

      Dynamic parameters can also be scheduled as you referred to. How often would depend upon how perishable the data for the LOV is. If it is a list of customers that changes every few days or a week, then scheduling to run that often, and using that list would suffice. If it is point of sale information that changes by the minute, I would recommend running it on demand. If it a list of states, I would recommend a static parameter. When you are scheduling an LOV, it then uses the List of Values Server to execute the query.

      Scheduled LOV - LOV server

      Run on demand LOV - Report Application Server

      then on the main report when it runs

      ActiveX, JAVA, DHTML viewer - Crystal Reports Cache Server and Crystal Reports Page Server

      Advanced DHTML viewer - Report Application Server only (does it's own cacheing)

  • author's profile photo Former Member
    Former Member
    Posted on Dec 19, 2008 at 10:35 AM

    Hi,

    Can you try to do the following for the problematic report. However prior to this go to report properties, default settings-> parameters and update the parameters by checking option prompt when viewing.

    1) Go to CMC.

    2) Go to problematic report, right click on it.

    3) Go to refresh option.

    4) Check the options.

    Record selection formula.

    Current and default parameter values.

    Group selection formula.

    Default database logon information.

    Use object repository when refreshing report.

    5) Uncheck the option printer options

    6) Then click on update and refresh the report

    We hope this helps you.

    Regards,

    Add a comment
    10|10000 characters needed characters exceeded

    • I'm not familiar with that issue, but it's impossible to stay on top of everything.

      You are correct. If a dynamic parameter LOV is run on demand, it is processed by the Report Application Server. Your RAS has to be running and enabled, and able to connect to your reporting datasource.

      The List of Values server has only one job - running scheduled dynamic parameter LOVs.

      If I have issues with dynamic parameter LOVs, I typically use the Business View Manager to view the properties of the data connection (<LOV name>_DC), and ensure the database credentials are valid and set to "never prompt". I make sure this is saved, then I go to schedule the LOV as you described. If the LOV status in the Edit window shows a successful instance, I know my LOV works via the List of Values server. Then I clear that instance in the Edit window, and test the LOV to run on demand (using RAS now).

      One thing I've observed, is if you open that LOV Edit window while the LOV is still running, it will fail every time. You cannot run it and edit it at the same time. I assume there is a file lock somewhere preventing that.

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.