Active Reports 13 demo

Active Reports 13 demo

Posted by: wgoodhead on 4 March 2019, 6:44 pm EST

• 

  wgoodhead

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 4 March 2019, 6:44 pm EST - Updated 30 September 2022, 5:49 pm EST

  Having an issue similar to this one:
  
  https://www.grapecity.com/en/forums/ar-dev/multi-value-parameter-not-

  Was able to take an existing SSRS Report and import it to the Active Reports 13 Report Editor.

  Then modified to use the correct SQL calls.

  Next modified the parameters to insure that they are correct.

  Everything imported and the report calls the Reports’ Main SQL Stored Procedure and works properly if I do not use “multivalue” selection on any of the parameters.

  Note that on the “Issue-5” screenshot below that all of the items in the "Ticket Types are all selected which is the desired result. But the call to the query has the SQL Exception.

  The exception message is shown below when attempting to choose multivalue on ANY of the items that can be used for multiple values.

  Any idea on what to do to fix the issue?

  Thanks,
  
  Bill G.

  ---

  Exception details:
  
  GrapeCity.ActiveReports.ReportException: An unexpected error occurred. Additional information: ‘Procedure or function ‘GetReport_Queries_131_DataSet1’ expects parameter ‘@TypeList’, which was not supplied.’ —> System.Data.SqlClient.SqlException: Procedure or function ‘GetReport_Queries_131_DataSet1’ expects parameter ‘@TypeList’, which was not supplied.
  
  at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action

  1 wrapCloseInAction)    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action

  1 wrapCloseInAction)
  
  at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
  
  at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
  
  at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
  
  at System.Data.SqlClient.SqlDataReader.get_MetaData()
  
  at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
  
  at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
  
  at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource

  1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)    at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)    at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()    at GrapeCity.ActiveReports.Rendering.DataProcessing.RecordsAdapter.c.MoveNext()    at GrapeCity.Enterprise.Data.DataEngine.Extensions.EnumerableExtensions.MemoizedReadOnlyList

  1.CacheItem()
  
  at GrapeCity.Enterprise.Data.DataEngine.Extensions.EnumerableExtensions.MemoizedReadOnlyList

  1.<GetEnumerator>d__6.MoveNext()    at System.Linq.Enumerable.Any[TSource](IEnumerable

  1 source)
  
  at GrapeCity.Enterprise.Data.DataEngine.DataProcessing.AggregateImpl.<>c__DisplayClass1_0.b__3(ExecutionContext exc)
  
  at GrapeCity.Enterprise.Data.DataEngine.DataProcessing.DataProcessor.<>c__DisplayClass17_0.b__2(ExecutionContext ctx)
  
  at GrapeCity.Enterprise.Data.DataEngine.DataProcessing.DataProcessor.<>c__DisplayClass13_0.b__2(ExecutionContext exc)
  
  at GrapeCity.Enterprise.Data.DataEngine.DataProcessing.DataProcessor.<>c__DisplayClass17_1.b__4(RegionFn 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.Enterprise.Data.DataEngine.DataProcessing.DataProcessor.<>c__DisplayClass17_1.b__3()
  
  at GrapeCity.Enterprise.Data.DataEngine.DataTree

  1.Scope.get_Regions()    at GrapeCity.Enterprise.Data.DataEngine.DataProcessing.DataTreeGenerator.<>c__DisplayClass17_1.<MakeScopeFn>b__5()    at GrapeCity.Enterprise.Data.DataEngine.DataTree

  1.Scope.get_Regions()
  
  at GrapeCity.ActiveReports.Rendering.Data.DataScopeBase.GetRegion(String name)
  
  at GrapeCity.ActiveReports.Rendering.Components.RenderReportItemFactory.Create(IReportRenderingContext reportRenderingContext, ReportItem rdlItem, IDataScopeInternal currentDataContext)
  
  at GrapeCity.ActiveReports.Rendering.ReportRenderingContext.<>c__DisplayClass65_0.b__0(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.BuildGraph[T](IEnumerable

  1 canvasItems)    at GrapeCity.ActiveReports.Layout.L2.Canvas(IEnumerable

  1 canvasItems, Boolean galleyMode, Object item, Int32 width, Int32 height, Boolean consumeWhiteSpace)
  
  at GrapeCity.ActiveReports.Layout.L2.Canvas(IEnumerable

  1 canvasItems, Boolean galleyMode, Object item, Int32 width, Int32 height, Boolean canShrink, Boolean canGrow, Boolean consumeWhiteSpace)    at GrapeCity.ActiveReports.Layout.ReportCanvasLayout.Canvas(IEnumerable

  1 items, LayoutScope context, Object item, Int32 width, Int32 height, Boolean canShrink, Boolean canGrow, Boolean consumeWhiteSpace)
  
  at GrapeCity.ActiveReports.Layout.ReportImpl.BodyLayout(LayoutScope context, IBody body, Object item, Size

  1 contentSize, Nullable

  1 size, Boolean consumeWhiteSpace)
  
  at GrapeCity.ActiveReports.Layout.LayoutEngine.BuildPages(LayoutScope context, Int32 limit)
  
  at GrapeCity.ActiveReports.Layout.LayoutEngine.BuildLayout(LayoutInfo layoutInfo)
  
  at f.GetLayoutTree(IReport report, TargetDeviceCapabilities targetDevice, ITextMetricsProvider metricsProvider, 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, CancellationToken token)
  
  — End of inner exception stack trace —
  
  at GrapeCity.ActiveReports.Document.PageDocument.Render(IRenderingExtension renderingExtension, StreamProvider streams, NameValueCollection settings, Boolean forceDataRefresh, Boolean forceParameterDataRefresh, CancellationToken token)
  
  at cf.c.b__5()
  
  at System.Threading.Tasks.Task.InnerInvoke()
  
  at System.Threading.Tasks.Task.Execute()
  
  

  

  1920×1040 259 KB

  

  688×710 95.1 KB

  

  688×710 82.4 KB

  

  688×710 79 KB

  

  1920×1040 236 KB

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 5 March 2019, 2:07 am EST

  Hello,

  In order to achieve your requirement, you need to use JOIN function while passing the parameter in the stored procedure. Please refer the attached report for implementing the same.
  
  Also, refer to the below-stored procedure which has been used in the report

  USE [testDb]
  
  GO

  SET ANSI_NULLS ON
  
  GO

  SET QUOTED_IDENTIFIER ON
  
  GO

  CREATE PROCEDURE [dbo].[create_Table]
  
  @LastName nvarchar(4000)
  
  AS

  SELECT *
  
  FROM STRING_SPLIT(@LastName,‘,’)
  
  GO

  If issue still exists, please share the report along with the stored procedure. This will be very helpful for us.

  Thanks,
  
  Mohit
  
  rpt_MultiValue.zip

• 

  wgoodhead

  • Post Options:
  • Link
    Copy

  Posted 5 March 2019, 4:00 pm EST

  Thanks for the reply.

  We will discuss our results with our team.

  Have a great day!