Blank Report >> Dictionary Tab>> New Data Source >> Retrieved column and parameters from stored procedure not correct

[Anas]

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.

Screenshot 2024-03-30 at 5.48.08 AM.png (389.68 KiB) Viewed 1266 times

The Data Type which is coming as Int32 in the above call is getting displayed as String as shown below

Screenshot 2024-03-30 at 5.49.46 AM.png (363.91 KiB) Viewed 1266 times

Same goes with Size also

Screenshot 2024-03-30 at 5.51.00 AM.png (438.11 KiB) Viewed 1266 times

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

Screenshot 2024-03-30 at 5.52.18 AM.png (299.47 KiB) Viewed 1266 times

Can you please let me know how to fix this issue.

[Max Shamanov]

Hello,

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

Thank you.

[Anas]

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,

[Max Shamanov]

Hello,

We need some additional time to investigate the issue.

Thank you.

[Anas]

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

[Max Shamanov]

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.

[Anas]

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

image (1).png (111.54 KiB) Viewed 11 times

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"

image.png (147.83 KiB) Viewed 11 times

image (1).png (40.87 KiB) Viewed 11 times

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,

[Max Shamanov]

Hello,

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

Thank you.