Maximum number of sub reports in an Access report
Posted on 2004-04-26
I had a problem many moons ago including over 100 sub reports in a Microsoft Access report. I can't remember what the symptom was but I think the report excluded any sub reports over a particular limit when I tried to print it out. I have been given a spec for a report that requires 120 aggregate count values e.g. select count(user) from users where gender = "M". None of the count values are made up of others therefore I cannot add count logic to the parent report itself, sub reports are the only way I know how.
Does anybody know if this limit still exists and if so if there is a way around it? I am using Access 2000.
Any help greatly appreciated.