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