Blank Report >> Dictionary Tab>> New Data Source >> Retrieved column and parameters from stored procedure not correct
Blank Report >> Dictionary Tab>> New Data Source >> Retrieved column and parameters from stored procedure not correct
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.
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.
-
- Posts: 824
- Joined: Tue Sep 07, 2021 10:11 am
Re: Blank Report >> Dictionary Tab>> New Data Source >> Retrieved column and parameters from stored procedure not correc
Hello,
Could you please clarify what version and product you are using?
We need some additional time to investigate the issue.
Thank you.
Could you please clarify what version and product you are using?
We need some additional time to investigate the issue.
Thank you.
Re: Blank Report >> Dictionary Tab>> New Data Source >> Retrieved column and parameters from stored procedure not correc
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,
We are using Stimulsoft REport Js product and its version is "stimulsoft-reports-js": "^2023.2.3"
Sure please take your time.
Thanks,
-
- Posts: 824
- Joined: Tue Sep 07, 2021 10:11 am
Re: Blank Report >> Dictionary Tab>> New Data Source >> Retrieved column and parameters from stored procedure not correc
Hello,
We need some additional time to investigate the issue.
Thank you.
We need some additional time to investigate the issue.
Thank you.
Re: Blank Report >> Dictionary Tab>> New Data Source >> Retrieved column and parameters from stored procedure not correc
Hi Max,
Thanks for your reply.
Sure please take your time.
Thanks for your reply.
Sure please take your time.
-
- Posts: 824
- Joined: Tue Sep 07, 2021 10:11 am
Re: Blank Report >> Dictionary Tab>> New Data Source >> Retrieved column and parameters from stored procedure not correc
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.
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.
Re: Blank Report >> Dictionary Tab>> New Data Source >> Retrieved column and parameters from stored procedure not correc
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,
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,
-
- Posts: 824
- Joined: Tue Sep 07, 2021 10:11 am
Re: Blank Report >> Dictionary Tab>> New Data Source >> Retrieved column and parameters from stored procedure not correc
Hello,
We couldn't reproduce the problem on the latest release version.
Pelase check the attached image.
Thank you.
We couldn't reproduce the problem on the latest release version.
Pelase check the attached image.
Thank you.
- Attachments
-
- chrome_CXBlPhhGdp.png (212.81 KiB) Viewed 446 times
Re: Blank Report >> Dictionary Tab>> New Data Source >> Retrieved column and parameters from stored procedure not correc
Hi Max,
Thanks for your reply.
Can you please send the sample codebase for the above example whose screenshot you have added.
Thanks,
Thanks for your reply.
Can you please send the sample codebase for the above example whose screenshot you have added.
Thanks,
-
- Posts: 6458
- Joined: Tue Mar 20, 2018 5:34 am