How to Allow NULL in SSRS with drop-downs

If I understand you correct, Take your query that populates the drop down and add a union to it. Such as below.

Select

                ID,

                Description

From Tr_season

Union

Select

                Null as ID,

                '<none> as Description

Hope this is what you are looking for.

Marty Jones

Director of Information Services

Omaha Performing Arts
1200 Douglas Street

Omaha, Nebraska 68102

P 402.661.8469

Marty.Jones@omahaperformingarts.org

www.omahaperformingarts.org

For tickets, call Ticket Omaha at 402.345.0606

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of James Fairfield
Sent: Thursday, September 08, 2011 12:21 PM
To: Martin A. Jones
Subject: [Tessitura Technical Forum] How to Allow NULL in SSRS with drop-downs

Hi

I have a new challenge.  How do I allow NULLs in SSRS type reports when I have drop-down query-based parameters?

James

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!