Monday, February 13, 2012

Always show Subreport (need to always show Background Color)

I have tried adding a second dataset so that my subreport always returns a result, but this has not worked yet. I need a subreport to always show because the row is in Gainsboro background color and when there is no data, half the row is Gainsboro and half is White.

Any ideas?

make sure your query is returning a row, even if it is blank, or at least return a empty value if your result set is empty.

if mydataset.count (or whatever) =0 then

return " "

end if

you could check for this in your sql statement or query.

No comments:

Post a Comment