I am new to JetReports. Maybe this is a really dumb question but I can't find the answer
My JetReport is connected to Microsoft Dynamics GP.
I can see the table in the Browser,Table Builder, and Report Builder. And the table record count of that specific table is around 300k. I know there are fields in that table. However when I try to see/add the Fields, the list of Fields is empty. When I right click on that table in the browser and choose Drilldown, it shows a single column with many rows but none has value.
There are other tables of the same company that I can see the fields but some have the same problem. It's sorta random. Some small tables like 1 row or 600 rows I still can't see the fields or drilldown.
I turned on the logging and this is the exception that it's throwing
2016-04-26 14.04.27.128 JetDispatcher.ValidateLicense: DataSource:
2016-04-26 14.04.27.131 LicenseManager.GetCurrentUserType: Data source name: Dynamics GP
2016-04-26 14.04.27.135 LicenseManager.GetCurrentUserType: User Type: Designer
2016-04-26 14.04.27.136 FunctionCache.TryFindResult: DesignMode: True
2016-04-26 14.04.27.138 FunctionCache.TryFindResult: Found: False
2016-04-26 14.04.27.138 JetDispatcher.EvaluateJetFunction: a
2016-04-26 14.04.27.141 JetDispatcher.EvaluateDataFunction: Records
2016-04-26 14.04.27.143 DataSourceManager.OpenDataSource(string): Data source name:
2016-04-26 14.04.27.144 DataSourceManager.GetDataSource: Data source name: Dynamics GP
2016-04-26 14.04.27.146 DataSourceManager.OpenDataSource(string): Data soure type: GreatPlains
2016-04-26 14.04.27.147 DataSourceManager.OpenDataSource(IJetDataSource): Data source name: Dynamics GP
2016-04-26 14.04.27.147 DataSourceManager.OpenDataSource(IJetDataSource): Data soure type: GreatPlains
2016-04-26 14.04.27.151 JetDispatcher.OptimizeQuery: Records
2016-04-26 14.04.27.156 JetDispatcher.EvaluateDataFunction: Call Data Source ExecuteQuery
2016-04-26 14.04.27.169 JetDispatcher.EvaluateDataFunction: Finish Data Source ExecuteQuery
2016-04-26 14.04.27.178 ErrorManager.Handle: A Jet Reports error has occurred:
Exception of type 'Jet.Data.Shared.InvalidFieldException' was thrown.
Jet.Data.Shared.InvalidFieldException
at Jet.Data.FieldDictionary.get_Item(String fieldId)
at Jet.Data.Ado.AdoDataSource.d.c(String field)
at System.Linq.Enumerable.WhereSelectListIterator`2.MoveNext()
at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source, Func`2 predicate)
at Jet.Data.Ado.AdoDataSource.a8(TableInfo A_0, SortFieldCollection A_1, List`1 A_2, List`1 A_3)
at Jet.Data.Ado.AdoDataSource.a(ILimitableQuery A_0, Boolean A_1, Boolean& A_2, Boolean& A_3)
at Jet.Data.Ado.AdoDataSource.au(ILimitableQuery A_0)
at Jet.Data.JetDataSource.ExecuteQuery(IQuery query)
at Jet.Data.Ado.AdoDataSource.ExecuteQuery(IQuery query)
at Jet.Data.Ado.GpDataSource.ExecuteQuery(IQuery query)
at Jet.JetDispatcher.a(du A_0, IJetDataSource A_1)
at Jet.JetDispatcher.a(du A_0, Boolean A_1, Boolean A_2)
at Jet.JetDispatcher.f(du A_0, Boolean A_1)
at Jet.JetDispatcher.e(Object[] A_0)
Please help
0 comments
Please sign in to leave a comment.