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 1063 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 1063 times

Same goes with Size also

Screenshot 2024-03-30 at 5.51.00 AM.png (438.11 KiB) Viewed 1063 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 1063 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.