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

Scheduling Reports with Optional Range Parameter

I am using the BI platform SDK to schedule Crystal reports for end-users. Previously, all parameters in the Crystal reports are required and end-user must specify values for each of them. Recently, we'd like to allow end-users to leave some parameter values blank.The Crystal reports have been updated so the parameters are now optional.

For parameter that does allow range values, we have no problem handling blank values. For range parameter, we are also able to schedule the report if both the start and end value of the range is either populated or left blank.

The problematic scenario is when the user specifies either the start or end value, but not both. I tried something like the following to populate the ReportParameterRangeValue object:

ReportParameterRangeValue rangeValue = ReportParameterObject.CreateRangeValue(); rangeValue.ToValue.Value = "DATE(2016,1,1)"; rangeValue.IncludesLowerBound = true; rangeValue.HasNoUpperBound = true;

However, I am getting the following error in BusinessObjects for that scheduled instance:

Error in File ~tmp2e5c913485b01d2.rpt: Invalid PE_RI_* combination in parameter rangeinfo specifier.

Does anyone have any suggestions on what I might be missing? Or if there is any documentation published on how to work with optional range parameters (the SAP examples I've seen usually deal with more simple parameter scenarios).

Thanks,

Edward

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Oct 06, 2016 at 01:38 PM

    I usually split them up into separate "Start" and "End" parameters instead of using ranges.

    -Dell

    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.