Hi,
We've been stepping through the installation manuals relatively smoothly until pg 22 of the Aras Innovator Microsoft Reporting Services Guide For use with Microsoft SQL Server 2005. We entered the following string:
select first_name,last_name,email,telephone from innovator.userorder by last_name
and received the error:
There is an error in the query. Incorrect syntax near the keyword 'user'.
We also tried the string:
select first_name,last_name,email,telephone from [user]order by last_name
There is an error in the query. Invalid object name 'user'.
Any help would be greatly appreciated.
Thanks,
Jesse
Hi.
Please, try
select first_name,last_name,email,telephone from innovator.[user]order by last_name
Hope it helps,
SamsAn.
Thanks! That worked great.
We completed the new report and followed the steps to deploy the report. However, when we attempted to run the report from within Innovator we hit another snag. We created the new Innovator Report Item and did have the new option for the User Report under the Reports pull-down menu. When the report is selected from the menu only a blank window opens.
Any thoughts on why the report is not displaying from within Innovator?
Thank you,
I guess several reasons. Do you have the appropriate software (Acrobat Reader, Excel) installed and enabled in IE? Does your report return non-empty data? Please, note that the blank window may contain xml and it is just hidden by the browser. RMB, View Source to view the real content. Is the content empty?
It is a PDF report and Adobe Acrobat is installed and functioning inside IE. The source code from the blank window is:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><HTML><HEAD><META http-equiv=Content-Type content="text/html; charset=windows-1252"></HEAD><BODY></BODY></HTML>
Please, make sure that your report returns non-empty data.
You may test the report inside the visual studio during adding/modifying.
Yes, the report returns non-empty data as seen from visual studio and report services.
I am getting this Error Message : There is an error in the query. Invalid object name 'innovator.user'.
I first used this string:
I have been doing a step by step in the installation manual on Page 22. Then I seen your soloution and tried to change the string by putting innovator.[user] in place, and got another query error messeage.
There is an error in the query. Invalid object name "innovator.user'.
Any help would be much appricated.
Thank you.
Andrew