Crystal Server Parameter Selection

Posted on 2012-08-16
Last Modified: 2012-11-09
Does anybody know the process Business Objects goes through when you select different parameters for scheduled instances?  For example:

I have a one report for which I am creating 17 instances, one for each division.  The division is set up as a static parameter in the report.  When I click 'edit' to select the parameter under the schedule option it takes about 50 seconds to change to the drop down where I can choose my parameter.  Once I choose the parameter and then click 'OK' it takes about the same time to change save it so I can click 'Schedule'.

The SQL query that supplies the report takes about the same amount of time to run so I almost feel like the report is being generated each time I schedule a new instance.


I can choose parameters for other reports with no problems so I have isolated it to this particular report.

Question by:lcallah93
    LVL 26

    Accepted Solution

    You're sure it's a static parameter, not dynamic?  The slow behavior of the parameter populating is consistent with dynamic parameters that have to be queried first.

    Also, because your report is based on a SQL Command, were the parameters built inside the command or outside of it in Crystal.  If they were built outside of it, that would explain the problem, because the command would have be fully executed before the parameters become available.  The correct way to use parameters with commands is to create them inside the SQL so they're passed to the database for processing.

    Author Comment

    The SQL Command from which the report is written I did not create.  I will take a look in more detail at a later date to see if rhinok's solution does the trick.  For now, I just waited the minute for each instance.  Everything is running as scheduled so it was just the actual parameter selection that was the issue.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    This video discusses moving either the default database or any database to a new volume.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now