Well, which is it?

Had to read it carefully, and consider the implications. Good question. Thanks.

You might try setting up a member for Lat and one for Lon and then put the non empty there, and then use the member(s) in your query

Don't show what? An entire column, an entire row, or simply the data in the field?

douglane4 (9/17/2010)

---

Go to the tablix properties and under the No Rows section, type whatever message you want to display in the NoRowsMessage property. This will hide the table completely...

You misunderstand. I am not talking about the Group Properties dialog. I am talking about the grouping pane.

In VS2008 the grouping pane is typically a thin horizontal pane...

Just taking a stab in the dark. Is it possible that you have a negative number in your result set?

Is the result set free form text, or a tablix/matrix?

I spent over 10 years working as a generalist in IT. I have really specialized in SQL Server and SQL Server BI over the last few years. This...

douglane4 (9/17/2010)

---

I think dbowlin has a good solution. If the consumer is picky about appearances, you can add an empty group footer with no borders. The tablix will render...

Are you trying to expand and collapse a column, or trying to show or not show data depending on the result?

Good one. I didn't even think of using a member. Like I said my MDX is pretty rusty. But I think you nailed it, a member with...

Rain....Hoping for sun later. Forecast says maybe.

Good question. Round is a function with a few gotchas that it is important to know about and understand. Thanks.

My MDX is very rusty, I don't think I can write the correct code without experimenting with the source but I would consider adding something like

ParallelPeriod(Week,1,[DimDate].[Calendar].CurrentMember)

Good luck.