Report Query Question

Good day all,

I am trying to figure out why I can't a couple of reports to run.  I know part of the problem is that our database does not use the OOTB Part ItemType.  Our Parts List is a document ItemType and it links (weirdly) to our Part.  I have this report that I don't understand what it is trying to do.  Thanks for any help you can provide.

Name:  s_IPL

Label:  Indentured Parts List

Type:  Item

Location:  Service

Target:  Window

Report Query:

np:top_part_id=<xsl:value-of select="@id"/>&amp;rs:Format=EXCELOPENXML

  • From what I have been reading, the Query is referencing a SQL report.  Are all of the SQL reports supposed to show in the SQL section?  I can't get the Report Manager to open, so I am going to have to look into that a bit more.

    Does the Report Manager have to be accessed from the SQL server or is it designed to be accessed from a users computer (admin)?

  • Hi Nathan,

    before working with the Report Manager, check if you can access the report server in your environment at all. You should be able to open it in your browser when you know the correct address (e.g. localhost/reports or whatever was specified in your company). There you should find the available reports AND a database connection element were you specify your connection to Innovator.

  • Our SQL server is behind a firewall.  I have not been able to access it directly. 

Reply Children