Joins not working
 
Notifications
Clear all

Joins not working

13 Posts
2 Users
0 Likes
141 Views
Oladayo Oduntan
Posts: 6
Topic starter
(@oladayo-oduntan)
Active Member
Joined: 1 month ago

Hello,

 

I am facing the issues.

 

Please see below:

 

image
image

 

 

Regards,

 Oladayo Oduntan

12 Replies
Dotnet Report
Posts: 28
Admin
(@admin)
Member
Joined: 10 months ago

Hi Oladayo

 

Thanks for sending the screenshots. For the first one, you actually need to setup the joins both ways. 

 

So I do see that you have the join between these tables setup one, but you have to add the join highlighted below as well:

 

Table Name

Field Name

Type

Table Name

Join Field Name

OptometristFirms

Id

INNER

VisualAssessmentResults

OptometristFirmId

VisualAssessmentResults

OptometristFirmId

INNER

OptometristFirms

Id

 

And you would have to do it for other joins you add as well. 

 

As for the second issue, I'm guessing you get that when you do a stored procedure search. In the reportservice.asmx, can you please put a break point on SearchProcedure method, and step in to it to see what the error is. Also, check the browser inspector, and let me know if you see an exception there. 

 

Thanks

dotnet Report Team

Reply
Oladayo Oduntan
Posts: 6
Topic starter
(@oladayo-oduntan)
Active Member
Joined: 1 month ago

Hello,

See below issue

1.       Join works now but on export to excel throws this error

Please set the ExcelPackage.LicenseContext property. See      https://epplussoftware.com/developers/licenseexception

 

OfficeOpenXml.LicenseException

  HResult=0x80131500

  Message=Please set the ExcelPackage.LicenseContext property. See      https://epplussoftware.com/developers/licenseexception

  Source=EPPlus

  StackTrace:

   at OfficeOpenXml.ExcelPackage.get_Workbook()

   at OfficeOpenXml.ExcelPackage.CreateBlankWb()

   at OfficeOpenXml.ExcelPackage.ConstructNewFile(String password)

   at OfficeOpenXml.ExcelPackage..ctor()

   at DVLA.UI.Models.DotNetReportHelper.GetExcelFile(String reportSql, String connectKey, String reportName, Boolean allExpanded, List`1 expandSqls, List`1 columns) in C:\Projects\DVLA\VisualAssessmentTest\DVLA.UI\Models\DotNetReportModel.cs:line 492

   at DVLA.UI.Controllers.DotNetReportController.DownloadExcel(String reportSql, String connectKey, String reportName, Boolean allExpanded, String expandSqls, String columnDetails) in C:\Projects\DVLA\VisualAssessmentTest\DVLA.UI\Controllers\DotNetReportController.cs:line 479

   at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters)

   at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)

   at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)

   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c.<BeginInvokeSynchronousActionMethod>b__9_0(IAsyncResult asyncResult, ActionInvocation innerInvokeState)

   at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult)

   at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResultBase`1.End()

   at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)

   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass11_0.<InvokeActionMethodFilterAsynchronouslyRecursive>b__0()

   at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass11_2.<InvokeActionMethodFilterAsynchronouslyRecursive>b__2()

2.       where is the reportservice.asmx. Anyways, I trace it to this function “SearchProcedure” but is not hitting the controller in debug

 

 

image

 

Regards,

Oladayo Oduntan

 

Reply
Dotnet Report
Posts: 28
Admin
(@admin)
Member
Joined: 10 months ago

OK great, thanks. Please see below

 

1. For the excel export error, make sure the nuget package version for EPPLus is 4.5.3.2 (has to be 4.xx and below, cannot be 5.xx):

 

 <package id="EPPlus" version="4.5.3.2" targetFramework="net461" />

 

2. For this, yes sorry, I mixed up the version. Please do the following, in dotnetsetup.js file, look for "searchStoredProcedure", and change the url from "/Setup/SearchProcedure" to "/DotnetSetup/SearchProcedure". See highlighted below:

 

    self.searchStoredProcedure = function () {

        if (!self.searchProcedureTerm()) {

            toastr.error('Please enter a term to search stored procs');

            return;

        }

 

        ajaxcall({

            url: "/DotnetSetup/SearchProcedure",

            type: 'POST',

            data: JSON.stringify({

 

 

Please let me know if this resolves both issues. 

 

Thanks

dotnet Report Team

Reply
Oladayo Oduntan
Posts: 6
Topic starter
(@oladayo-oduntan)
Active Member
Joined: 1 month ago

Hi again,

 

1.       The excel error is still the same after modify as described

2.       The Search stored procedure throwing new error, one when the stored procedure is not found then the below error when found

 

image

 

Throwing error at this point(break point) below:

 

image

 

Oladayo Oduntan

Reply
Page 1 / 3
Share: