Bugs in SQL Filter and Variable screen

hunter · Post by **hunter** » Thu Sep 15, 2011 3:01 am

I am using v2011.2

1. In the Variable dialog, the tooltips are all blank.
Also, If i add a key, value pair, it adds curly brackets {} around the key. This makes it to the source code, which gives compile errors. Does not matter is string or date type:
New System.String() {Stimulsoft.Report.Dictionary.StiDialogInfo.Convert({01/09/2011})}

2. Using SQL Query Filter Engine, If i add a filter, Expression type (Shareholder.Exercise_No = 5), it always gives "Object Reference not set to an instance of an object". A value type works fine. Perhaps is am missing something. I was wanting to use expression types so I could replace the "5" with a variable which the user specifies.

Post by **Ivan** » Fri Sep 16, 2011 7:13 am

Hello,

hunter wrote:1. In the Variable dialog, the tooltips are all blank.

The problem is solved in the official release 2011.2.

hunter wrote:Also, If i add a key, value pair, it adds curly brackets {} around the key. This makes it to the source code, which gives compile errors. Does not matter is string or date type:
New System.String() {Stimulsoft.Report.Dictionary.StiDialogInfo.Convert({01/09/2011})}

We couldn't reproduce this bug.
Can you please send us a sample report template with data, which reproduces the issue?

hunter wrote:2. Using SQL Query Filter Engine, If i add a filter, Expression type (Shareholder.Exercise_No = 5), it always gives "Object Reference not set to an instance of an object". A value type works fine. Perhaps is am missing something. I was wanting to use expression types so I could replace the "5" with a variable which the user specifies.

We couldn't reproduce this bug.
Can you please send us a sample report template with data, which reproduces the issue?

Thank you.

hunter · Post by **hunter** » Mon Sep 19, 2011 12:42 am

Thanks for your support. I am almost got everything i need working. This is my final issues list.

1. The curly bracket issue - i can not duplicate anymore. Must be something i did wrong.

2. Using SQL Query Filter Engine, If i add a filter, Expression type (Shareholder.Exercise_No = 5), it always gives "Object Reference not set to an instance of an object". A value type works fine. I was wanting to use expression types so I could replace the "5" with a variable which the user specifies.

I am attaching a file to this thread called "ShareholderSQLExpressionError.mrt". Change the Report Engine to ReportEngine, and it works fine, SQL Engine gives the error.

3. The other issue I am struggling with is something to do with the variables - i think. The attached report "DivSummaryNoViewer.mrt". This works perfectly in the designer, Preview mode. When run by the Web Viewer or Export to file, it shows a blank page - no error or anything. I think it has to do with the variable being used, but strange how it works in one and not the other.

4. Tip for next version: Add a button in the Edit Data Source window, when columns are retrieved, have Sort columns alphabetically button - (so users have the option to leave as is, or sort).

5. Another tip: In the designer, if there is a SQL error in the data source or where filter - show the error. Currently is does nothing or shows a blank report, which is not helpful.

Post by **HighAley** » Mon Sep 19, 2011 5:40 am

Hello.

Please, send us data for reports template to reproduce your issues.

Thank you.

hunter · Post by **hunter** » Wed Sep 21, 2011 2:35 am

I am attaching the SQL script which has some sample data. The real data comes from a view of many tables, but this simple table of the same name will be sufficient - pls review the sql before you run it and of course, change the sql connection to your db.
I have also attached new reports which i have removed some data sources so i will work with this data.

Post by **HighAley** » Fri Sep 23, 2011 9:08 am

Hello.

hunter wrote:2. Using SQL Query Filter Engine, If i add a filter, Expression type (Shareholder.Exercise_No = 5), it always gives "Object Reference not set to an instance of an object". A value type works fine. I was wanting to use expression types so I could replace the "5" with a variable which the user specifies.

I am attaching a file to this thread called "ShareholderSQLExpressionError.mrt". Change the Report Engine to ReportEngine, and it works fine, SQL Engine gives the error.

The issue is fixed.
Please, check the latest build when it will be available.

hunter wrote:3. The other issue I am struggling with is something to do with the variables - i think. The attached report "DivSummaryNoViewer.mrt". This works perfectly in the designer, Preview mode. When run by the Web Viewer or Export to file, it shows a blank page - no error or anything. I think it has to do with the variable being used, but strange how it works in one and not the other.

Please, try to use expression in the filter of Data Band because variables isn't supported when Field is Value.

hunter wrote:4. Tip for next version: Add a button in the Edit Data Source window, when columns are retrieved, have Sort columns alphabetically button - (so users have the option to leave as is, or sort).

Now we have sort button on Dictionary tab. Please use it.

hunter wrote:5. Another tip: In the designer, if there is a SQL error in the data source or where filter - show the error. Currently is does nothing or shows a blank report, which is not helpful.

The error shows when there are any errors in SQL statement. But in your case it was a bug.

Thank you.