suppressing a quarterly sub report
Hi. We run STD 2008. Is there a way to suppress a sub report and its bookmark if the date passed is not a quarter ending month? We run lots of reports monthly but like to see a QTD sub report added to certain sections with its own bookmark in certain months.
May 30th, 2012 10:58am

You could set the visibility of the subreport to hide on months that are not quarter end (3,6,9,12).
Free Windows Admin Tool Kit Click here and download it now
May 30th, 2012 11:08am

we tried this expression in the visibility property under hidden expression and it doesnt seem to work in a non R2 environment. I'll try to get more and clearer info and post here. =IIF(Parameters!Month.Value <>6 OR Parameters!Month.Value <>9 OR Parameters!Month.Value <>12, True, False) The error generated while report is generating says: An error occured during local report processing. The hidden expression for the subreport 'x' contains an error. Object '/some guid/...rem' has been disconnected or does not exist at the server. I see some old posts that suggest this is a client problem only. I also see a place (very old) where the bug can be voted as important. And some suggestions about calling Customer Support if the problem is occuring in a pre R2 product. None of this will help me.
May 30th, 2012 5:01pm

thx Mike. The problem occurs on the client side only (VS). So I'm thinking that the old posts about this being a bug are correct. Do you agree?
Free Windows Admin Tool Kit Click here and download it now
June 8th, 2012 9:39am

Hi db042188, From the error message, it seems that the Month parameter in the main report a multi-value parameter, right? If so, the criteria Parameters!Month.Value<>6 is invalid because the value of the multi-value parameter is an array. At this time, I suggest that you go to the subreport, add a filter to the subreport so that the report only displays the data for the target month. If you have any questions, please feel free to let me know. Regards, Mike Yin
June 9th, 2012 6:24am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics