Retrieve columns problem

[VaDRo]

Hello,

We couldn't reproduce the issue.

I'm running OptionsHelper from command line from path
"C:\Program Files (x86)\Stimulsoft Reports.Net 2015.1\Bin\OptionsHelper.exe"
Maybe I should run it from the report manager? If so, please, tell me how to do that.
From other side, please, tell me how to change options from code. I'm running report designer in standalone mode (not from my app). How I could change that option from code?

Thank you for your assistance

[VaDRo]

PS: I removed specified folder with settings. Then I ran OptionsHelper.exe. Exception was the same.

Capture.PNG (55.08 KiB) Viewed 2696 times

[Lech Kulikowski]

Hello,

We have checked several PC and couldn't reproduce the issue.

Could you provide more detailed information - system, framework, etc

Thank you.

[VaDRo]

Hi, Lech.
I'm on the Win10 with Visual Studio 2013. Additionally I have DevExpress 17.2.3 installed. I have version 2015.1 of Stimulsoft.Net.
Additionally I have VS 2015 & VS2017 and SQL Server 2014 on my PC.

[Lech Kulikowski]

Hello,

We couldn't reproduce the issue.

You can set all options in your project and save it:
StiOptions.Save()

Also, please try to check the OptionsHelper from another version and let us know about the result.

Thank you.

[VaDRo]

Ok, I tried to reproduce this thing on trial version of StimulSoft reports, 2018.3.
First of all, I can't find OptionsHelper.exe in folder "C:\Program Files (x86)\Stimulsoft Reports 2018.2.3"
When I opened my report in trial designer (ver.2018) I don't have exception when trying to obtain columns list from stored procedure. But I haven't receive columns from stored procedure too So, problem was gone to silent mode No exception and no columns

BTW: I solved this problem with configuring of StiOptions from code. But it looks strange when you have some issue from 2011 and you still don't have good solution for this problem in 2018

[Lech Kulikowski]

Hello,

> First of all, I can't find OptionsHelper.exe in folder "C:\Program Files (x86)\Stimulsoft Reports 2018.2.3"

OptionHelper was removed in last releases (after 2016.x).

> But it looks strange when you have some issue from 2011 and you still don't have good solution for this problem in 2018

To work with temporary tables in the query, you should use option:
StiOptions.Engine.RetriveColumnsMode = StiRetrieveColumnsMode.KeyInfo;

Thank you.

[VaDRo]

To work with temporary tables in the query, you should use option:
StiOptions.Engine.RetriveColumnsMode = StiRetrieveColumnsMode.KeyInfo;

Thank you.

Dear Lech,
Please let me know how to set this option from Stimulsoft Designer. I'm making design of reports without any additional .net programs

[Lech Kulikowski]

Hello,

Use options.xml file with that option:

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<StiOptionsHelper>
<RetriveColumnsMode type="Stimulsoft.Report.StiOptions+Engine">
<value>0</value>
</RetriveColumnsMode>
</StiOptionsHelper>

Thank you.

[galinaBA]

Hello, I have 2020.5.5 v Stimusoft.
I cant find file OPTIONS.XML in StimulSoft folders.

Could You please explain where I should set this option?

Use options.xml file with that option:

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<StiOptionsHelper>
<RetriveColumnsMode type="Stimulsoft.Report.StiOptions+Engine">
<value>0</value>
</RetriveColumnsMode>
</StiOptionsHelper>