Skip to Content

Why can't I add a column to a freehand SQL statement?

The re-introduction of freehand SQL is great and opens up a lot of possibilities. We are on BOE 4.1 SP06 Patch 4.1.

I have run into a situation that seems like a bug, but maybe I am doing something wrong. Once I run a freehand SQL query I am not able to adjust the columns that are returned. I can change the criteria in the where clause, but I cannot add a column.

We have a simple Calendar table in a SQL Server 2014 database that contains various data points about each date going quite a few years into both the past and the future.

When I drop that into a new freehand SQL query...

Everything works as expected. Here is a sample of the first few rows...

Now I want to add another column, DW...

I do not get any errors when I run the query. The new column "DW" shows up in the Available Objects pane. However, you can see the issue starting to appear in that the new column is not in the sample data in the grid on the right.

When I try to add "DW" to my table I get two errors...

1. The report cannot be generated. Please contact your administrator.

2. Unable to get the first page of the current report. Check the validity of your report. (ERR WIJ 20003).

The only way I have found around this issue is to create a new freehand SQL query and rebuild the table in my report based on that new query.

Any thoughts?

Thanks for your help,

Noel

it8hh.png (16.3 kB)
m8j7q.png (27.8 kB)
vljby.png (27.4 kB)
uz0b2.png (27.8 kB)
9ihvp.png (22.4 kB)
kdvso.png (27.8 kB)
hpnq3.png (23.8 kB)
9zkwk.png (39.4 kB)
vq489.png (40.5 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Feb 15, 2018 at 07:48 PM

    Looks like your issue is known issue with your version. Check this KB

    2191510 - Errors appear in Web Intelligence documents based on Free-Hand SQL after conversion from Desktop Intelligence

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.