My users wanted an opportunity report modified with a Product subreport. Before I started building a new report, I went to the prebuilt ones and previewed the Product report that's already in the system. Oddly, though we have lots of opportunities in with lots of products, nothing (absolutely NOTHING) came up.
I have a second database, different division, with much more data in it, so I pulled it up and tried the product report there and still got nothing.
Has anyone run into this problem, and if you have, do you have an idea? The database is running fine otherwise; both are, actually, so I don't think it's a schema/index problem or anything like that.
The opportunity/product reports do work, in fact I wrote several of the reports. Without examining your database it's difficult to say what might be the problem. One thing, opportunities that aren't linked to a contact record won't be included in any of the opportunity reports.
