dhenning - Tuesday, June 12, 2007 10:01 AM:
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?
SamsAn - Tuesday, June 12, 2007 10:35 AM:
Hi.
Several inaccuracies had been observed in Reporting Service when a report had a subreport. There were no general ways to avoid the inaccuracies.
The used tricks:
1. Use 2005 environment (some inaccuracies are caused by bugs in Reporting Services for MS SQL Server 2000).
2. Some special trick, like: use smaller font for the first page to have the subreport result of the first page too (of course, it may be ugly).
dhenning - Tuesday, June 12, 2007 1:02 PM:
Sam:
Thanks for your pointers. This led me to a number of things which with each step made me see some other things. But the long and short of it, even though the Virtual Studio environment would display it fine, and the Report Services Manager would display it right, and the Report Services manager export to PDF would put it out right, when I went to the Innovator link it didn't. It turns out - at least from my experience with this - is that the Report Properties in the Virtual Studio environment need to be a bit bigger than what seems to be needed. (Add page width plus left margin plus right margin to be real page width, etc.) So instead of 11 x 8.5 (letter landscape) I needed to make the Report Properties 13 x 8.5 and then everything (all subreports, fields, etc.) fell into the right place on the output through the Innovator link.
