If you have to use only 1 parameter, change your date parameter to a text parameter. Then they can freehand in their date, or the word null or empty...

I would try using an Execute SQL Task instead of a dataflow

It is pretty convoluted but here is how:

http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/69546/

slimchance99 (8/19/2011)

---

I have a user report request that required the date field paremeter to return records where the date is >= somedate or return records where the date is NULL.

I...

Breathe

Cast it...

In that case you should just be able to add a row group on your MngrID column and a visibility toggle.

See if this helps

http://devmau5.wordpress.com/2010/03/25/the-getdate-of-mdx/

ashok.theagarajan (8/18/2011)

---

Hi Everyone

I have an input column in an Excel Source, which is of type DT_NTEXT. Inside the data, there is a delimiter text which says "<Break Here>".

I have to...

keywestfl9 (8/17/2011)

---

When i try to export i get Document Map and each node under Document Map as separate Sheet; how do i avoid and get it in one single output

Please...

I don't think you can.

At first glance I thought just make your table self referencing, and do a group on the Manager ID. But then I realized...

Source control software may allow you to do something like this, but other than a manually maintained textbox I don't think there is anything out of the box.

I would do one thing first. Take your source, you can test all your different configurations, and just route it to a Row Count transform and nothing else and...

Let's go to the instant replay

Thanks, good question