Scheduling Reports with Parameters

Is there any way for me to build a report with parameters and then
schedule it to go to different people with different parameters through
Crystal Enterprise? For example, I have a report and the parameter is
client name. I want to schedule it so that on the first of the month,
it’s run for client A and sent to client A, but also have it run for
client B and be sent to client B. Any help would be great! Thanks!!


NHJEN (BOB member since 2006-01-10)

Moving to the XI Scheduler forum.


Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

Has anyone else come by this issue?

I have somethign similar; where the same recipient needs three versions of the report delievered at the same time each week. The reports differ only in the one parameter passed to the report.

I can only set one default param and the schedule wont seem to allow variations on param default based on schedule instance. :frowning:

Any better work-around than triplicating the report on the server. I really want to reduce the clutter.


rfitzgerald (BOB member since 2006-07-17)

Can you not set up 3 recurring instances of the same report, each with a different parameter value selected?


datagal :us: (BOB member since 2005-12-21)

I’ve set the default Param to one value.

How do I set it to another value when scheduling? The only place I can see that I can set the param value is on the Process-Parameters tab of the Central Management Console.

So if I set that (the param default), create a schedule (call it S1); change the param default and then make another schedule (lets call that S2); both S1 and S2 run with the last set param default.

I really hope im just missing somethign simple here.


rfitzgerald (BOB member since 2006-07-17)

Ignore the CMC Scheduler. Go to InfoView, schedule one recurring instance with one param, schedule another with the 2nd param and so on.


datagal :us: (BOB member since 2005-12-21)

I tried that and got:

Server Error in ‘/businessobjects/Enterprise115/InfoView’ Application.
Runtime Error

After clicking OK to accept the selected parameter value.

It is a dynamic drop-down parameter.


rfitzgerald (BOB member since 2006-07-17)

Got the error when?


datagal :us: (BOB member since 2005-12-21)

In InfoView; I browse to the report; click SCHEDULE; pick hourly; Then jump down to Parameters; then click on the one I want to change.

It opens the new dynamic list, I pick the value I want.

Then click OK.

and I get:

Server Error in ‘/businessobjects/Enterprise115/InfoView’ Application.

Exception from HRESULT: 0x8004100D.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x8004100D.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[COMException (0x8004100d): Exception from HRESULT: 0x8004100D.]
CrystalDecisions.ReportAppServer.Prompting.IPromptEngine.processPrompting(IPromptingFeedback feedback) +0
WebDesktop.report_scheduleBody_param.GetProcessPromptingResult(String contextHandle, String values) +98
WebDesktop.report_scheduleBody_param.HandleSetParameter() +81
WebDesktop.report_scheduleBody_param.Page_Load(Object sender, EventArgs e) +374
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +772


rfitzgerald (BOB member since 2006-07-17)

Is the field you’re applying the prompt to in a hierarchy and not the top level? I’ve experienced weird prompt errors when I tried to apply a prompt to a lower level of a hiearchy…


datagal :us: (BOB member since 2005-12-21)

No hierarchy.

The report has two parameters.

One is an interger (number of days). Not even worried about that one; it works just fine in the InfoView scheduler.

The other parameter is a dynamic (non-cascading) single value prompt.


rfitzgerald (BOB member since 2006-07-17)

Sorry… I’m stumped. Maybe someone else will have an idea.


datagal :us: (BOB member since 2005-12-21)