Category Drop-Down List for Date Range Parameters 1

[DarkAngel]

Crystal Reports 2008
BusinessObjects Enterprise XI 3.1
MS SQL Server 2005 (SQL Server 9.0.4035)

In CR2008, is it possible to select a date range parameter based on a category in a drop down list? Would like to add a couple of date range prompts which are based on a selected type of date. Something like

http://www.knoxville.org/events/

where you pick a category then enter date range (with date picker or manually). I understand how this would work if there is a field called category.

In my case, the dates are stored in several different tables which can be linked together. There is no field called category.

Drop-down list values for Category_1 and Category_2 would be: Invoice Date, Order Date, Payment Date, Return Date, Ship Date

paramCategory_1 paramStartDate_1 paramEndDate_1

paramCategory_2 paramStartDate_2 paramEndDate_2

This would be a more streamlined presentation than having five separate date range prompts.

Thank you for any direction,
DA

 

[briangriffin]

Let's start with one category/date range - you can add others later.

First parameter is titled Category - make custom values false, and put in the category values.

Second parameter is Date Range - allow range values.

The real work occurs in the selection criteria - it would be something like this:


if {?Category} = "Category Value 1", then

{whatever the appropriate date field is} = {?Date Range}

else

if {?Category} = "Category Value 2", then

{whatever the appropriate date field is} = {?Date Range}

else

etc. etc.

 

[DarkAngel]

Thank you Brian, this works great!