J
John Kraus
I have an Access 2007 DB that I am migrating to an ADP using SQL Server
Express. All my tables, forms SPs etc are done and all is working dandy ( I
am duly impressed at how nice this stuff works).
I have moved on to making the necessary reports and have run into a small
problem. In the native Access 2007 reports I can right click on report
objects and filter the dickens out of the more complex reports. This adhoc
filtering is very convenient and my users like it. I want to have the same
functionality with the ADP app. As it stands now, right clicking on a report
element (date, text etc) brings up the context menu for filtering but it is
greyed out. The obvious question then, is how do I do this and make the
filtering behavior broadly available on reports. I only need this for a
small number of reports. Most of them don't require it. Sales persons
especially like this because they can so easily zero in on a single
customer, date range, state or city. The reports in question are driven from
SPs and all the data displays precisely as needed. I just need the ad hoc
filtering available on reports of native Acces 2007.
Thanks for any guidance on this.
John K.
Express. All my tables, forms SPs etc are done and all is working dandy ( I
am duly impressed at how nice this stuff works).
I have moved on to making the necessary reports and have run into a small
problem. In the native Access 2007 reports I can right click on report
objects and filter the dickens out of the more complex reports. This adhoc
filtering is very convenient and my users like it. I want to have the same
functionality with the ADP app. As it stands now, right clicking on a report
element (date, text etc) brings up the context menu for filtering but it is
greyed out. The obvious question then, is how do I do this and make the
filtering behavior broadly available on reports. I only need this for a
small number of reports. Most of them don't require it. Sales persons
especially like this because they can so easily zero in on a single
customer, date range, state or city. The reports in question are driven from
SPs and all the data displays precisely as needed. I just need the ad hoc
filtering available on reports of native Acces 2007.
Thanks for any guidance on this.
John K.