SubReport HasData Problem

[jv2]

whoops... didnt notice the link thingy...
it worked for me when I tested it... but it was because I was logged in to the file upload thing
open the page http://www14.brinkster.com/jv2jv2/ then open http://www14.brinkster.com/jv2jv2/stationeryDB.zip in another window hehehe sorry... cant be bothered to do a page with a link right now

 

[jv2]

please please please somebody come up with a nice workaround for this issue... Im dying here!!!!
C'mon Rich... Been looking at your posts elsewhere... You're a smart cookie... I know you can do it

 

[Rich]

Aside from not being able to figure out what does what in your db I can't see anything wrong with the HasData on your Report.
It would appear to be returning 1

 

[jv2]

haha... yeah Im sure it's a bit of a mess.. but it does what it's supposed to do...
but hmm... so it returns a value for you... very interesting... so in other words there doesnt seem to be anything wrong with it if opened in a newer version of access... but here Im still getting #name? which is really bugging me, since I have used the HasData method before and had it working fine...

 

[John Merline]

If anyone is still having problems with this issue (as I was), the correct syntax is:

=IIf([Reports]![Name of Main Report].[Report]![Name of Subreport].[Report].[HasData],value if true,value if false)

HasData must be preceded by the 'Report' identifier in order to function, otherwise Access will throw the #Name? error