I created a nice matrix report and it works great when the parameter I pass
 returns some records, however when no records are returned the matrix simply
 does not render at all leaving a big empty hole where that part of the report
 should appear.
 The matrix has static row heading that I want to always appear even if no
 data appears in the columns, even better if there was a way to set a default
 value to the columns in case no data is returned say 0s. This is an example
 of my matrix.
 Static Heading
 Column Group
 Cars
 people
 animals
 So, Cars, People, and Animals are static row headings and the values fill in
 next to them for the column groupings. Now, if no records are returned I
 would still like to have the static column heading and static row heading to
 appear even if there is no data to display. How is that done?
 ThanksTry setting something in the NoRows property - like display a message "no
data for this timeframe" or something and I think that will make your
headings show in addition to the message. I have used this for tables ...
havent tried it with a matrix but I would think it should work.
"Ramez" wrote:
> I created a nice matrix report and it works great when the parameter I pass
> returns some records, however when no records are returned the matrix simply
> does not render at all leaving a big empty hole where that part of the report
> should appear.
> The matrix has static row heading that I want to always appear even if no
> data appears in the columns, even better if there was a way to set a default
> value to the columns in case no data is returned say 0s. This is an example
> of my matrix.
> Static Heading
> Column Group
> Cars
> people
> animals
>
> So, Cars, People, and Animals are static row headings and the values fill in
> next to them for the column groupings. Now, if no records are returned I
> would still like to have the static column heading and static row heading to
> appear even if there is no data to display. How is that done?
> Thanks
>
>
>
Subscribe to:
Post Comments (Atom)
 
No comments:
Post a Comment