There are so many tangents involved here
so I could be completely off base...
Identify the fields you use to link report to
subreport (Master/Child fields).
If you open the View in both DSN and DSN-less
connections, is there a difference in "padding" for
any of the fields you identified above?
When you set up DSN, you check/uncheck 2 boxes
Use ANSI quoted identifiers
Use ANSI Nulls, Padding and Warnings
however you check/uncheck those boxes, try
adding those settings to your DSN-less connection
Or...try basing your recordsources of report and
subreport on queries that TRIM any text Master/Child
Like I said, I could be way off base. It is just that I
had a complicated report/subreport once where the
subreport started showing up blank and t *** the
Master/Child text fields solved it.