Stimulsoft Business Intelligence System | Forum

Hi All,
In Custom Reports – New – Blank Report – Dictionary tab – Expand Data Sources – Right click on ‘Database Connection’ – New Data Source – In the New Data Source window, retrieve columns and parameters from the Stored procedure – The columns and Parameters are not retrieved properly.
Basically the Data Type is coming wrong when it should retrieve as Int32 it is retrieving it as String and also the Size is also getting displayed wrongly.
Please refer to the below screenshots for the same. The Data Type which is coming as Int32 in the above call is getting displayed as String as shown below Same goes with Size also And here is what we get in Size i.e 0 is getting displayed which is wrong as you can see in the above call the value is 4 Can you please let me know how to fix this issue.

Hello,

Could you please clarify what version and product you are using?
We need some additional time to investigate the issue.

Thank you.

Hi Max,
We are using Stimulsoft REport Js product and its version is "stimulsoft-reports-js": "^2023.2.3"
Sure please take your time.

Thanks,

Hello,

We need some additional time to investigate the issue.

Thank you.

Hi Max,
Thanks for your reply.
Sure please take your time.

Hello,

We were unable to reproduce the problem on the latest release build with the data type for columns and parameters.
As for the size of the parameters you get, you have to configure it yourself.

Thank you.

Hi Max,
In the latest version "stimulsoft-reports-js": "^2024.2.6"
This issue is fixed when we are using the stored procedure but it is not fixed for the Sql Query
Please check this image when we are using Sql Query int data type is coming as String Also there is a new issue that has cropped up in the latest release when we are using a simple SQL query data is not getting retrieved it was working well in this release "stimulsoft-reports-js": "^2023.2.3"
In the latest version now we are not even able to display the data that was getting displayed earlier in the old release. "stimulsoft-reports-js": "^2023.2.3"

Thanks,

Hello,

We couldn't reproduce the problem on the latest release version.
Pelase check the attached image.

Thank you.

Hi Max,
Thanks for your reply.
Can you please send the sample codebase for the above example whose screenshot you have added.

Thanks,

Hello,

You can find it here:
https://learn.microsoft.com/en-us/dotne ... -databases

Thank you.