Skip to content
Joins not working
 
Notifications
Clear all

Joins not working

14 Posts
3 Users
0 Likes
2,889 Views
Posts: 33
Admin
(@admin)
Member
Joined: 3 years ago

Hey Oladayo 

 

Not sure why it's giving you an exception, for the EPPlus, maybe you can uninstall that package and try to reinstall it again. And for stored proc, I can't tell what the error is. 

 

I recorded a short video showing you how it looks like on my end:

 

Let's setup another troubleshooting meeting if you can't get this resolved. That would probably be the best way to resolve it. You can setup a meeting on this link: 

   https://calendly.com/dotnetreport/razisyed

Reply
Posts: 6
Topic starter
(@oladayo-oduntan)
Active Member
Joined: 2 years ago

Hello again,

 

Excel is working now, I uninstall 4.5.3.2 and install 4.5.3.3

 

For search stored procedure, I put a try catch, that particular stored procedure was throwing “A TOP or FETCH clause contains an invalid value.” 

Then for the below code, I added “if (dt == nullcontinue;” after line 394

.

image

 

Oladayo Oduntan

 

 

Reply
Posts: 33
Admin
(@admin)
Member
Joined: 3 years ago

Hi Oladayo

 

Ok great, so that's good progress. So this error seems to be specifically with the stored procedure you are searching and trying to add from your database. 

 

Can you please send me the value for "cmd.CommandText" it's trying to execute. Also, the stored proc you are looking for, does it exist and does it have any parameters?

 

Thanks

dotnet Report Team

 

Reply
Posts: 33
Admin
(@admin)
Member
Joined: 3 years ago

Hi Oladayo, We got your request to extend the trial this morning. No worries at all, we'll extend the trial by 2 weeks, till 8/12/2022. 

 

Also, please let me know if all the technical issues are resolved yet or not. Please feel free to email back with any questions/issues. 

 

Thanks

dotnet Report Team

Reply
Posts: 6
Topic starter
(@oladayo-oduntan)
Active Member
Joined: 2 years ago

Hello ,

 

Thanks for extending the trial period, yes at the moment I have no technical issues, all issues relating to report intrgration have been resolved. It is just that customizing the report incur issues due to the fact that the existing application relies on old jquery, javascript, bootstrap and css files, some are custom javascript and css files that are breaking and needs to be upgraded and fixed.

I will get back to you should I encounter any issues.

 

Regards,

Oladayo Oduntan

Reply
Page 2 / 3
Share: