Sunday, February 19, 2012

Chart borders not hiding when no data is returned

I do not have much experience with reporting services or Visual Studio.
I'm trying to upgrade some reports from reporting services 2000 to
reporting services 2005. One of the reports I'm working on contains 5
charts. In the 2000 environment when no data is returned for a single
chart, the chart is not displayed and the next chart that contains data
is "moved up" in the display. In 2005 when no data is returned for a
chart, a blank chart (basically an outline) is displayed. So may I end
up seeing a chart or two, then a blank area, and then another chart
instead of seeing all charts that return data displayed sequentially.
I hope that wasn't too confusing and that someone may be able to help
me with this.I want to clear this up a little... bascially I'm getting blank charts
as placeholders in the report. If no data is returned then I do not
want an empty chart /placeholder... instead I want charts with data to
shift up.|||Use an expression on the Visibility --> Hidden property for the chart
and test for rows returned, something like:
=IIF(rownumber("YourQuery") = 0, True, False)
I've also hit this same issue after upgrading reports from RS2000 to
RS2005.
Matt A
Rabbit wrote:
> I want to clear this up a little... bascially I'm getting blank charts
> as placeholders in the report. If no data is returned then I do not
> want an empty chart /placeholder... instead I want charts with data to
> shift up.

No comments:

Post a Comment