ADP filtering reports w/ SQL SvrExpress

[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.

 

[Sylvain Lafontaine]

I've just made some tests and yes, it seems that you are right: the live
report feature of Access 2007 with ad hoc queries and sorting doesn't seem
to work at all with ADP. Maybe in the next service pack, if we are lucky.

 

[Tom van Stiphout]

On Fri, 30 Nov 2007 10:56:38 -0500, "John Kraus"

Microsoft acknowledged this to be a problem here:
http://blogs.msdn.com/clintcovington/archive/tags/Access+2007/default.aspx

Ironically the Q in QFE stands for Quick.

For now you'll have to stay with Access 2003, or Access 2007 full
version. The A2007 runtime has other serious problems, e.g. these:
http://www.tech-archive.net/Archive...ic.access.adp.sqlserver/2007-09/msg00084.html
http://www.tech-archive.net/Archive...ic.access.adp.sqlserver/2007-09/msg00085.html

-Tom.

 

[John Kraus]

Sylvain,
Thanks for the confirmation of my observation. It isn't good news but at
least I know that it isn't something I omitted or didn't comprehend. As you
say, I hope this will get fixed in a service pack. It is a great feature
that adds immensly to the value of this software.

John K.

 

[amg51]

I have found in the Access Run Time that all Record sources bound to Stored
Procedures fail
(Combo Boxes, Forms, Reports etc ). They work if you change to a View.