1 answer

644 views

Table Cell Merge

Hi Guys

I am creating dynamic table and using (07a0fcda-7fca-4925-b85b-7a3c620a2d6f_DynamicStaticRows.zip sample // Report1.cs)
I am using Q2 2013 SP1

I have Table Cell values like below

1    2        3 //Row 1
1    5        6 // Row 2

I need to merge Row cells 1 and 1 to be like below

    2 3 //Row 1
1                         //Merged data in middle
    5 6 //Row 2

My Client Requirement is to export to PPT with same output (If possible any sample code is app)

Senthil

General Discussions

answered on 14 Nov 2013

35 answers

1.8K+ views

ReportViewer and ASP.NET MVC 3 - Razor

Hi,

What is the best way to implement the report viewer using MVC 3 project with the Razor engine?

Thanks

General Discussions

answered on 14 Nov 2013

2 answers

93 views

Style Issue Reflects export

hi Guys

I am working on dynamic Table where textbox are dynamic

below is code , i am making one textbox bottom border style=none

labelTextBox.Style.BorderStyle.Bottom = BorderType.None; //Not Exporting to Powerpoint
                    labelTextBox.Style.BorderStyle.Top = BorderType.Solid;
                    labelTextBox.Style.BorderStyle.Left = BorderType.Solid;
                    labelTextBox.Style.BorderStyle.Right = BorderType.Solid;

labelTextBox.Style.BorderStyle.Bottom = BorderType.Solid; //Exporting to Powerpoint
                    labelTextBox.Style.BorderStyle.Top = BorderType.Solid;
                    labelTextBox.Style.BorderStyle.Left = BorderType.Solid;
                    labelTextBox.Style.BorderStyle.Right = BorderType.Solid;

Attached sample image which i am in need of

Senthil

General Discussions

answered on 14 Nov 2013

1 answer

115 views

Area Graph xAxis Format

I have a report that contains a Area Graph. I have set up all the data and it works except for a few issues.
In the coordinate System collection when I set the Label FOrmat for the XAxis to {0:d} it still displays the time. How do I just display the date?

Also I can get the No Data Message to work but If I set the NoDataStyle visibility to false it still displays?

Also how can I set the xAxis to not display every tick mark. The x axis is every month since 2004 currently the scale is set to Category Scale and I do not see a way to set a step poperty. When I change it to date then the graph no longer displays

Are these know issues?

General Discussions

answered on 13 Nov 2013

1 answer

179 views

Area Graph xAxis Format

I have been having an issue the area chart in the Telerik reporting for WPF. I have a sql query that returns a seriesID, DateTime, and Account Value.

When I set the chart up I set the GraphGroup Collection to the Valuation Date.

For the Series I have the Category Group set to the ValuationDateGroup, the Series GroupI have the series ID, for the Y I have the sum of the Account Value.

For the Graph Coordinate System the x axis is CategoryScale and the yAxis is NumericalScale

I can get the graph to display this way but I cannot get the date on the x axis to format without the time, and when I change the xAxis to DateTimeScale the graph is blank.

I want to be able to format the date to just show date and then only show the lables on the x axis ever 6 months.

I created these reports originally with an earlier version but they did not work so I upgraded the controls to the most recent. Now when I change the XAxis to DateTimeScale VS2008 errors out and closes. I can go to the designer.cs and code the report to DateTimeScale and it will run but I still have the same issue.

I had contacted Phone support and Rick Hellwege told me to set the Data.x propery of the Graph to DateTime, but I cannot find this property anywhere.

General Discussions

answered on 13 Nov 2013

10 answers

482 views

store procedure with parameters

Hello,
How I can use store procedires with parameters? I would like to fill DataAdapter depends on parameters.
Could you heplp me?
Regards.
Leszek

General Discussions

answered on 13 Nov 2013

6 answers

237 views

Report property dropdown list for reportview

Hi,

The report drop down list in the property window for the report viewer does not work on my app or in the sample app supplied by Telerik. I'm referring to the Report property assigned at design time. The documentation says: "Set the Report property of the viewer using the drop down list in the Properties Window". When I click on it I get the message "Object not set to an instance of an object" in both my app and the sample app. What do I do to correct this?

Thanks.
Ron

General Discussions

answered on 13 Nov 2013

1 answer

89 views

cross-tab performance issue

Hey,

I am having performance issues with our reports and I am not sure where to look next.

I have cached the calls using :

http://www.telerik.com/help/reporting/configuring-telerik-reporting-database-session-state-provider.html

This has helped a lot on the initial pull of the data but now has dramatically increased the rendering when expanding a group. It used to be about 1 second and now is 30 seconds.

Thanks,

Robert

General Discussions

answered on 12 Nov 2013

1 answer

316 views

Telerik Reporting Cached Session

Hello,

I am having problems getting the cached report to work properly, attached is the Stack Trace. I followed everything on the step by step guide and it works in some instances and others it gives the error "missing object name 'session_state'.

Server Error in '/' Application.

Invalid object name 'session_state'.
Statement(s) could not be prepared.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Telerik.OpenAccess.RT.sql.SQLException: Invalid object name 'session_state'.
Statement(s) could not be prepared.

Source Error:

 An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


            [SQLException: Invalid object name 'session_state'.
Statement(s) could not be prepared.]
   Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery() +499
   OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery() +118
   OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute() +152
 
[DataStoreException: Error executing query: Telerik.OpenAccess.RT.sql.SQLException: Invalid object name 'session_state'.
Statement(s) could not be prepared.
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()
   at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery()
   at OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute()
SQL:
SELECT [modified_date] AS COL1                  FROM [session_state] WHERE [resource_id] = ?                                       AND [session_id] = ?                                        Telerik.OpenAccess.RT.sql.SQLException: Invalid object name 'session_state'.
Statement(s) could not be prepared.
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()
   at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery()
   at OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute()]
   Telerik.OpenAccess.SPI.Backends.ThrowException(Exception e) +28
   OpenAccessRuntime.ExceptionWrapper.Throw() +34
   OpenAccessRuntime.DataObjects.OpenAccessPersistenceManagerImp.handleException(Exception x, Boolean needsRollback) +1433
   OpenAccessRuntime.DataObjects.OpenAccessPersistenceManagerImp.getObjectById(Object oid, Boolean validate) +1144
   OpenAccessRuntime.DataObjects.OpenAccessPersistenceManagerImp.GetObjectByKey(ObjectKey key) +66
   OpenAccessRuntime.DataObjects.UnsynchronizedPMProxy.GetObjectByKey(ObjectKey key) +50
   OpenAccessRuntime.ObjectScope.GetObjectByKey(ObjectKey key) +50
   Telerik.OpenAccess.Query.ExpressionCompiler.PerformDatabaseQueryImpl(Type resultType, Int32 elementAt, Object[] groupResolutionParamValues, Boolean single, Boolean checkOid) +676
   Telerik.OpenAccess.Query.ExpressionCompiler.PerformDatabaseQuery(Type type, Int32 elementAt, Object[] groupResolutionParamValues, Boolean single, Boolean checkOid) +97
 
[InvalidOperationException: An exception occured during the execution of 'Extent<Telerik.Reporting.Cache.Database.SessionState>().Where(sessionState => (sessionState.SessionId == value(Telerik.Reporting.Cache.Database.DatabaseCache).sessionKey)).Where(sessionState => (sessionState.ResourceId == value(Telerik.Reporting.Cache.Database.DatabaseCache+<>c__DisplayClass4).key))'. Failure: Error executing query: Telerik.OpenAccess.RT.sql.SQLException: Invalid object name 'session_state'.
Statement(s) could not be prepared.
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()
   at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery()
   at OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute()
SQL:
SELECT [modified_date] AS COL1                  FROM [session_state] WHERE [resource_id] = ?                                       AND [session_id] = ?                                        Telerik.OpenAccess.RT.sql.SQLException: Invalid object name 'session_state'.
Statement(s) could not be prepared.
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()
   at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery()
   at OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute()
See InnerException for more details.
Complete Expression:
.Call System.Linq.Queryable.Where(
    .Call System.Linq.Queryable.Where(
        .Constant<Telerik.OpenAccess.Query.ExtentQueryImpl`1[Telerik.Reporting.Cache.Database.SessionState]>(Extent<Telerik.Reporting.Cache.Database.SessionState>()),
        '(.Lambda #Lambda1<System.Func`2[Telerik.Reporting.Cache.Database.SessionState,System.Boolean]>)),
    '(.Lambda #Lambda2<System.Func`2[Telerik.Reporting.Cache.Database.SessionState,System.Boolean]>))
 
.Lambda #Lambda1<System.Func`2[Telerik.Reporting.Cache.Database.SessionState,System.Boolean]>(Telerik.Reporting.Cache.Database.SessionState $sessionState)
{
    $sessionState.SessionId == .Constant<Telerik.Reporting.Cache.Database.DatabaseCache>(Telerik.Reporting.Cache.Database.DatabaseCache).sessionKey
}
 
.Lambda #Lambda2<System.Func`2[Telerik.Reporting.Cache.Database.SessionState,System.Boolean]>(Telerik.Reporting.Cache.Database.SessionState $sessionState)
{
    $sessionState.ResourceId == .Constant<Telerik.Reporting.Cache.Database.DatabaseCache+<>c__DisplayClass4>(Telerik.Reporting.Cache.Database.DatabaseCache+<>c__DisplayClass4).key
}
]
   Telerik.OpenAccess.Query.ExpressionCompiler.PerformDatabaseQuery(Type type, Int32 elementAt, Object[] groupResolutionParamValues, Boolean single, Boolean checkOid) +489
   Telerik.OpenAccess.Query.ExpressionExecution.PerformDatabaseQuerySingle(ChainedContext context, Expression expression, QueryableCategory before, Int32& found, Int32 elemAt, Boolean single, Boolean diffType) +610
   Telerik.OpenAccess.Query.ExpressionExecution.PerformQuerySingle(QueryableCategory before, Expression expression, Boolean tryGetObjectById, ChainedContext piece) +2491
   Telerik.OpenAccess.Query.Piece`1.ExecuteSingle(Expression expression) +527
   Telerik.OpenAccess.Query.Piece`1.System.Linq.IQueryProvider.Execute(Expression expr) +80
   System.Linq.Queryable.SingleOrDefault(IQueryable`1 source) +265
   Telerik.Reporting.Cache.Database.DatabaseCache.SetValue(String key, Byte[] value) +1185
   Telerik.ReportViewer.WebForms.StreamManager.StreamReady(RenderStream renderStream) +183
   Telerik.ReportViewer.WebForms.RenderStream.Finish() +46
   Telerik.Reporting.Html5Rendering.Writers.Html.ImageWriter.SaveImageInStream(IImageContainer imageContainer) +755
   Telerik.Reporting.Html5Rendering.Writers.Html.ImageWriter.SaveImageInStream(Image image) +73
   Telerik.Reporting.Html5Rendering.Writers.Html.Element.CreateToggleAdorner(IAdornerAction adornerAction, IInteractiveItem item, ElementPageInfo pageInfo) +603
   Telerik.Reporting.Html5Rendering.Writers.Html.Element.WriteAction(LayoutElement element, ElementPageInfo pageInfo) +459
   Telerik.Reporting.Html5Rendering.Writers.Html.Element.Begin(LayoutElement element, ElementPageInfo pageInfo) +613
   Telerik.Reporting.Html5Rendering.Writers.Html.TextBox.Begin(LayoutElement element, ElementPageInfo pageInfo) +137
   Telerik.Reporting.Html5Rendering.Writers.Report.WriteStartElement(LayoutElement element, ElementPageInfo pageInfo) +90
   Telerik.Reporting.BaseRendering.PageHandler.Telerik.Reporting.Paging.IPageHandler.StartElement(LayoutElement element, ElementPageInfo info) +49
   Telerik.Reporting.Paging.PageStartElement.AddToPage(IPageHandler handler) +52
   Telerik.Reporting.Paging.PageElementLayer.AddToPage(IPageHandler handler) +113
   Telerik.Reporting.Paging.PageElementManager.AddToPage(IPageHandler handler) +59
   Telerik.Reporting.Paging.PageCompositionBase.AddElementsToPage() +70
   Telerik.Reporting.Paging.PageCompositionBase.SendPhysicalPages() +57
   Telerik.Reporting.Paging.PageCompositionBase.OutputPage() +973
   Telerik.Reporting.Paging.PageCompositionBase.CreatePages() +638
   Telerik.Reporting.Paging.PagerBase.Telerik.Reporting.Paging.IPager.CreatePages(IPageHandler handler, Report report) +73
   Telerik.Reporting.BaseRendering.RenderingExtensionBase.Render(Report report, Hashtable renderingContext, Hashtable deviceInfo, CreateStream createStreamCallback, EvaluateHeaderFooterExpressions evalHeaderFooterCallback) +418
   Telerik.Reporting.Processing.ReportProcessor.RenderCore(ExtensionInfo extensionInfo, IList`1 reports, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback) +1595
   Telerik.Reporting.Processing.ReportProcessor.RenderCore(String format, IList`1 reports, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback) +92
   Telerik.ReportViewer.WebForms.ReportPageOperation.RenderReport(String format, IList`1 processingReports, Hashtable deviceInfo, IRenderingContext renderingContext) +104
   Telerik.ReportViewer.WebForms.ReportRenderOperation.PerformOperationOverride() +319
   Telerik.ReportViewer.WebForms.ReportPageOperation.PerformOperationOverride() +152
   Telerik.ReportViewer.WebForms.HandlerOperation.PerformOperation(HttpContext context, ICacheManager cacheManager) +74
   Telerik.ReportViewer.WebForms.BasicHandler.ProcessRequest(HttpContext context) +255
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +100
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75

General Discussions

answered on 12 Nov 2013

1 answer

770 views

Proxy Error: Error reading from remote server

I have a Telerik report with a SQL Data Source query that can take up to 10 minutes to run depending on the parameters selected and number of records returned. When the report runs for over 6 minutes (approximately), it encounters the following error:

Proxy Error

The proxy server received an invalid response from an upstream server.
The proxy server could not handle the request GET /CustomReports/Telerik.ReportViewer.axd.

Reason: Error reading from remote server

If I refine my selection criteria so that it runs under that timeframe, it finishes successfully. Does this error indicate that a timeout is occurring somewhere? I confirmed that the timeout value on the data source is set to 3000 minutes, so that doesn't appear to be the issue.

General Discussions