Hi Koen

I appreciate your assistance which has been very helpful.

I think it has something to do with the ability to set filters at DataSet, Report and perhaps Tablix level too...

Hello

Here is what appears to filter as expected.

In DataSet properties Filter I added in the Expression field =IsNothing(Fields!myField.Value)<>TRUE. Changed type to Boolean, Operator to "=" and Value =true.

Remarkabily with...

Wow I stumbled on the realisation that I can indeed see the underlying SQL query associated with the DataSet if I select the rsd file in Solution Explorer. I...

Fine, but how do you get to edit the SQL query using the interface provided?

In the DataSet propertiesi have a query option however I can do nothing here except Refresh...

Koen Verbeeck (1/16/2015)

---

It seems strange to me that adding a column would cause the table to be dropped. Did you use the ALTER TABLE statement?

In my opinion, the blank column...

I agree Koen it seems strange to require that the table be dropped and I found no advise if this requirement in the many articles I reviewed on how...

Hi

I tried using the DateDiff function but struggled with the syntax. I would be great if the stairway had some examples. I also tried using DateDiff in a...

Hi

I had a similar query and was dismayed that you got no assistance!

Hi

I could not figure this out either, can you share your insight.

I also struggled with - "SELECT b.Id + 9, a.Name + b.name"

As the stairway is a learning tool for...

Very helpful article, most appreciated.

Concerning the statement: - "One reason why you might use the ordinal position in your ORDER BY clause is when the select list column you want...

Sorry, but I don't agree. The interface changes are very substantial and for those learning this would significantly degrade the value of the tutorials. I presume they...