Skip to Content
avatar image
Former Member

Dynmaic Cascading Prompts - Populate parameter prompt with only values in date range

Hi Everyone,

I want to create a dynamic cascading prompt in CR 2011. I should have the 'date Range' and then the 'Test List' as prompts. Theres's a column "Date" in the table- which has the date values. I want to create a prompt where I can set up a Date Range(TO and FROM date from CalendaR) and Then according to that Date Range I should get the Particular Test Lists ranging in that date range. How do I achieve that? Please help me out.

Thank you.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 24, 2012 at 11:54 PM

    Hi,

    To have a list of values for the "Particular Tests: based on a date range you can create a date range in the Business View, then create a List of Values (LOV) of that Business View for the "Particluar Tests"

    Below are the general steps on how to do so:

    == In the Business View Manager ==

    1. In the Business View Manager, create a Data Connection to your data source.

    2. Create a Data Foundation based off the Data Connection created in step 1.

    3. In the Data Foundation, create a data range parameter.

    4. Then create a filter on the data range.

    5. Apply rights to the filter. ( If you do not, then the filter will not apply, and therefore you will not be prompted by the data range )

    6. Create a Business Element on the Data Foundation

    7. Create a Business View off the Business Element created.

    8. Create a List of Values off the Business View, and select the database fields that you want a List of Values.

    == In Crystal Reports ==

    9. In Crystal Reports, create a report

    10. Connect to the BusinessObjects Enterprise repository.

    11. Create a new parameter, and set your parameter to be dynamic.

    12. In the parameter window, then select the list of values (LOV) you created.

    13. Add your parameter to the report Record Selection formula.

    Now, when refreshing the report it will first prompt you for the data range, which is coming from the filter in the data foundation, then the second prompt will be your parameter with a dynamic list of values based on that date range.

    Hope this help!

    Patrick

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 24, 2012 at 11:50 PM

    Hi Sridhar,

    You cannot create Dynamic Cascading Prompts on Date Ranges.

    The only workaround is to create a command object with the 'start date' and 'end date' as parameters.

    This will bring in a filtered result set in CR. Then, you can create a dynamic parameter for the 'TestList' from the Field Explorer.

    So, everytime you refresh the report, you will first be prompted for the dates and then you'll get the option to select the TestList. This is not exactly as you would like it to be, however it's still another way to achieve this.

    I would also suggest that you create an Enhancement Request at http://ideas.sap.com.

    - Abhilash

    Follow us on Twitter

    Got Enhancement ideas? Try the SAP Idea Place

    Share Your Knowledge in SCN Topic Spaces

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Noel Scheaffer

      Hi Noel,

      Atlast found a way to do it. Used Patricks idea to do it. Create the Dynamic Cascading prompts without having the date parameters created in the report(remove them even from the command) and publish the report it into the BI server. Once you do this all the elements like Dataconnection, datafoundation, business view, etc will be created for that particular Dynamic prompt automatically when you publish the report to BI server.

      Close the report(very important).

      Log into the Business view manager. Go and find the DataFoundation element for the Dynamic Cascading prompt you created.

      Open the data foundation, create a Date Range Parameter.

      create a filter to that date range something like this {Command.field}={?Date Range}. Save it.

      Right click the filter and say Add rights. Like Patrick said this is very important orlese it wont prompt for date range.

      After adding that , save it again it will update all the elements for that dynamic cascading prompt. Now go and run the report and make sure the parameter in the report is pointing out to the same prompt which you updated now. And you will see it working like a magic.

      Hope it helps.

      --TC--