Posted 12 April 2019, 10:48 am EST
- Updated 30 September 2022, 5:45 pm EST
Here’s my dataset query:
SELECT casinoname
,outletname
,tm_name
,fullname
,RoleName
,tm_number
,incidentdatetime
,reason_cutoff
,reason_id
,gender
,ethnicity
,namedescript
,securcalled
,comments
,manager
,datecreated
,createdby
FROM public.vw_incidentreports
WHERE incidentdatetime >= :startdate
AND incidentdatetime <= :enddate
AND casinoname ON (:sites)
order by casinoname, incidentdatetime desc
Parameters are defined…see attached. ‘@’ and ‘:’ prduce the same error.


Exception details:
GrapeCity.ActiveReports.ReportException: An unexpected error occurred. Additional information: ‘No mapping exists from object type System.Object to a known managed provider native type.’ —> System.ArgumentException: No mapping exists from object type System.Object to a known managed provider native type.
at GrapeCity.ActiveReports.Extensions.EnumerableExtensions.MemoizedBuffer
1.#7kY(Boolean& hasValue) at GrapeCity.ActiveReports.Extensions.EnumerableExtensions.MemoizedBuffer
1.<GetEnumerator_>d__30.MoveNext()
at System.Linq.Enumerable.WhereSelectEnumerableIterator
2.MoveNext() at System.Linq.Lookup
2.Create[TSource](IEnumerable
1 source, Func
2 keySelector, Func
2 elementSelector, IEqualityComparer
1 comparer)
at System.Linq.GroupedEnumerable
3.GetEnumerator() at System.Linq.Enumerable.WhereSelectEnumerableIterator
2.MoveNext()
at System.Linq.Buffer
1..ctor(IEnumerable
1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable
1 source) at GrapeCity.ActiveReports.DataProcessing.DataProcessor.<>c__DisplayClass17.#mg1(ExecutionContext exc) at GrapeCity.ActiveReports.DataProcessing.DataProcessor.<>c__DisplayClass10.#8r0(ExecutionContext exc) at GrapeCity.ActiveReports.DataProcessing.DataProcessor.<>c__DisplayClass3b.#U.#sZh.#NE0(#TRZ fn) at System.Linq.Enumerable.WhereSelectArrayIterator
2.MoveNext()
at System.Linq.Buffer
1..ctor(IEnumerable
1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable
1 source) at GrapeCity.ActiveReports.DataProcessing.DataProcessor.<>c__DisplayClass3b.#U.#sZh.#FB0() at GrapeCity.ActiveReports.DataTree
1.Scope.get_Regions()
at GrapeCity.ActiveReports.DataProcessing.DataTreeGenerator.<>c__DisplayClass3e.
#U.
#wRi.
#PE0()
at GrapeCity.ActiveReports.DataTree
1.Scope.get_Regions() at GrapeCity.ActiveReports.DataTree
1.Scope.get_IsEmpty()
at GrapeCity.ActiveReports.Rendering.Data.DataScopeBase.
#BHA(Content content, Scope scope, Int32 index)
at GrapeCity.ActiveReports.Rendering.Data.DataScopeBase.
#BHA(String name)
at
#wxA.
#UzA.Create(ReportRenderingContext reportRenderingContext, ReportItem rdlItem, IDataScopeInternal currentDataContext)
at GrapeCity.ActiveReports.Rendering.ReportRenderingContext.<>c__DisplayClass10.
#f20(ReportItem item)
at System.Linq.Enumerable.WhereSelectEnumerableIterator
2.MoveNext() at System.Linq.Enumerable.WhereSelectEnumerableIterator
2.MoveNext()
at System.Linq.Enumerable.d__59
1.MoveNext() at System.Linq.Buffer
1…ctor(IEnumerable
1 source) at System.Linq.OrderedEnumerable
1.d__1.MoveNext()
at System.Linq.Enumerable.d__5
2.MoveNext() at System.Linq.Buffer
1…ctor(IEnumerable
1 source) at System.Linq.Enumerable.ToArray[TSource](IEnumerable
1 source)
at GrapeCity.ActiveReports.Layout.L2.CanvasImpl.
#n3V[T](IEnumerable
1 canvasItems) at GrapeCity.ActiveReports.Layout.L2.#AY(IEnumerable
1 canvasItems, Boolean galleyMode, Object item, Int32 width, Int32 height, Boolean consumeWhiteSpace)
at GrapeCity.ActiveReports.Layout.L2.
#AY(IEnumerable
1 canvasItems, Boolean galleyMode, Object item, Int32 width, Int32 height, Boolean canShrink, Boolean canGrow, Boolean consumeWhiteSpace) at GrapeCity.ActiveReports.Layout.ReportCanvasLayout.#AY(IEnumerable
1 items,
#saR context, Object item, Int32 width, Int32 height, Boolean canShrink, Boolean canGrow, Boolean consumeWhiteSpace)
at GrapeCity.ActiveReports.Layout.ReportImpl.
#QaX(
#saR context, IBody body, Object item, Size
1 contentSize, Nullable
1 size, Boolean consumeWhiteSpace)
at GrapeCity.ActiveReports.Layout.LayoutEngine.
#Lv0(
#saR context)
at GrapeCity.ActiveReports.Layout.LayoutEngine.BuildLayout(LayoutInfo layoutInfo)
at
#GPr.
#RLf.
#NNf(IReport report, TargetDeviceCapabilities targetDevice, LayoutNotificationCallback callback)
at GrapeCity.ActiveReports.Export.Image.Page.ImageRenderingExtension.Render(IReport report, StreamProvider streams, NameValueCollection settings)
at GrapeCity.ActiveReports.Document.PageDocument.Render(IRenderingExtension renderingExtension, StreamProvider streams, NameValueCollection settings, Boolean forceDataRefresh, Boolean forceParameterDataRefresh)
— End of inner exception stack trace —
at GrapeCity.ActiveReports.Document.PageDocument.Render(IRenderingExtension renderingExtension, StreamProvider streams, NameValueCollection settings, Boolean forceDataRefresh, Boolean forceParameterDataRefresh)
at GrapeCity.ActiveReports.Viewer.Win.Rdlx.RdlReport.<>c__DisplayClassf.
#7yz()
at GrapeCity.ActiveReports.Viewer.Win.AsyncLoader.<>c__DisplayClass7.
#cAz(Object param0, DoWorkEventArgs param1)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)