开发者

In Access 2003 Report, how to hide some detail rows?

开发者 https://www.devze.com 2023-03-15 12:33 出处:网络
I\'m working up an MS Access report.This report is grouped and has a details section.But some of these details rows don\'t need to be shown.How do I hide the details sections if, for example, \"[field

I'm working up an MS Access report. This report is grouped and has a details section. But some of these details rows don't need to be shown. How do I hide the details sections if, for example, "[fieldx] = 'foo'"?

(In Crystal Reports, there's a place where you can write custom criteria to su开发者_如何学编程ppress these kinds of things. I can't find an equivalent functionality here in Access).


As David suggested, you could pass WHERE condition to the report:

Function OpenReport(filterValue As String)

DoCmd.Close acReport, "ReportName"
DoCmd.OpenReport "ReportName", acViewReport, "", "[SomeFieldName]<>'" & filterValue & "'", acNormal

End Function
0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号