Hi
I have a new challenge. How do I allow NULLs in SSRS type reports when I have drop-down query-based parameters?
James
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
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
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!
Marty:
Thank you. That worked perfectly.