Parameter for Picking from Two Different Types of Date Ranges

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2008 Development » Parameter for Picking from Two Different...

Parameter for Picking from Two Different Types of Date Ranges

Rate Topic

Display Mode

Topic Options

Author

Message

service 87594

Posted Monday, March 11, 2013 3:47 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, March 20, 2013 8:55 AM
Points: 2, Visits: 26

Hello all,

I'm trying to set two - optional parameters - one for calendar year and one for sales year. The user needs to pick dates that are either a Calendar Year or a Sales Year. The code works in the query allowing a null value for either but not both, but when run in the report, it wants paramaters for both.

Here's the dataset code:

...and (YearVal In (@CalYear) or FYearShortVal In (@SalesYear))

Parameters are both set to multivalue and allow blank value. The available values are hand entered (specify values) - for example - in the Sales Year, the first label is 09/10 and the text value is 09/10, etc. for five entries, Calendar Year is similar - 2009, 2009, etc. I tried adding a blank label and empty value (not null or 0) to each of the value lists, but that didn't work either.

What am I missing?

Thank you.

JNM

Post #1429514

mikehunsaker

Posted Wednesday, March 20, 2013 8:36 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 11:32 AM
Points: 26, Visits: 178

Could you use the ISNULL function like:

...and (YearVal In (ISNULL(@CalYear, 0)) or FYearShortVal In (ISNULL(@SalesYear,0)))

Post #1433257

« Prev Topic | Next Topic »

Permissions