joshville - Thursday, May 31, 2007 10:18 AM:
First, my install information. I've installed Innovator and SQL Server Express on my local PC. I've managed to figure out AML a little bit and generate a couple of queries that return the data I want to put in a report. However, I can't seen to get the Designer tab to work as described in the "XSLT Report Tool Users Guide." The included "Approved Vendors" report is pretty similar to one I'm trying to write, so I tried to make an exact copy of it. I created a new report, using all the same properties. I copy/pasted the "Report Query" AML, copy/pasted the data from the "Stylesheet" tab, hit "Apply", and then hit "Run Query" on the Report tab. The data showed up mostly as expected on the Designer tab, except that any cells that didn't contain data had no borders. I can't drag columns around as described in the user's guide, and sometimes the Designer tab will completely lose all its cells. The only way to get them back is to close the whole Report window and reopen it.
Any ideas? Thanks!
RobMcAveney - Thursday, May 31, 2007 12:49 PM:
Hi Josh -
As you've figured out, there are some outstanding issues with the report designer. The workaround for now is to edit the stylesheet directly. The problem with empty cells having no border is something I've seen before as well. It has something to do with whitespace characters being altered in the cut/paste operation. To fix it, edit the stylesheet and replace all instances of "<xsl:text> </xsl:text>" with "<xsl:text> </xsl:text>".
If you plan to do complex reporting, you might also want to look at Microsoft Reporting Services (included with SQL Server). Some other Innovator users have deployed it successfully.
Rob
joshville - Thursday, May 31, 2007 2:21 PM:
Thanks, Rob. With my newness to Innovator, SQL Server, and IIS I was really thinking I'd missed enabling some service or something that was preventing the designer from working right. Guess I'll have to dig into the stylesheet...
-Josh
