Community Forums
Results 1 to 3 of 3

Thread: Custom SQL Report Problem

  1. #1
    Join Date
    May 2010
    Location
    Rochester, NY
    Posts
    51

    Custom SQL Report Problem

    I have a custom SQL report I am trying to use in WFM 2013. It works fine in SQL Management Studio. When I walk through adding the report to WFM, I paste the code in and hit Test Query and it says it returns 13 records. When I actually publish the report, it returns no results. Has anyone else run into this problem?

  2. #2
    Join Date
    Oct 2007
    Location
    Schaumburg, IL
    Posts
    317
    One thing to try is making sure that the aliases do not have spaces and not enclosed in double quotes. So, something like Select column_name as 'abc def' from table should be replaced to select column_name as abc_def from table.

    Hope this helps.

    Thanks!
    Alpesh
    Flexera Software Technical Support

  3. #3
    Join Date
    May 2010
    Location
    Rochester, NY
    Posts
    51
    I have a number of custom SQL reports that do use the format Select xxx AS 'Column Title' and the column titles are enclosed in single quotes. These all work fine. For some reason, this one report did not work that way. Removing the quotes and spaces from the AS clause did get the report to work, but I am confused on what made it different in this instance.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •