We have begun to use reporting services to develop reports for Innovator. However, in trying to get really useful reports, I need to use subreports in order to get the data to display (e.g. I have mulitple references to identities and need to display each identity name, so use a subreport to return the name for each reference. etc.) And we have files (in this case jpeg pictures) that need to display - and that is through a subreport as well.
Well, I get this report to function just fine in Visual Studio, then upload into Report services. In both cases, the report returns to the screen just as I planned it (that's success, right!) . So then, when I create the report in innovator to link to report services report, in PDF format, most (but not all) of the subreports don't appear in the location of the report where they were defined in Visual Studio, but they all show up grouped together on a second page (this report is a one-page report - an 8D report format ). So I changed the the format to HTML 4.0 and the subreports now come back in their proper positions, but the pictures don't display. The pictures were retrieved from the vault within the select statement of the sql. They show up fine in PDF.
Is there some trick to get the subreports to show up in PDF in their proper places when using the Innovator link?