Hello,
I am facing the issues.
Please see below:
Regards,
Oladayo Oduntan
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
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
Regards,
Oladayo Oduntan
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
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
Throwing error at this point(break point) below:
Oladayo Oduntan
