1 answer

99 views

Line Series Color Problem with Telerik Reporting Version Q1 2013

Greetings

In just converted a recent project I am working on from Q1. 2011 Telerik Reporting to Q1, 2013

After converting some of the code to the new version. I notice that my line bars lose their original colors. However, for graph that were of type Bat Chart or Point Chart colors were preserved very well.

In my scenario, I applied an Skin to the Chart objects, subsequently I attempt to overwrite their color settings. So I notice that there is a very strange situation specific to the line chart.

This will work for the Point Chart

ChartSeriesItem seriesItem = new ChartSeriesItem();

seriesItem.PointAppearance.FillStyle.MainColor = Color;

seriesItem.PointAppearance.FillStyle.FillType = Telerik.Reporting.Charting.Styles.FillType.Solid;

The following will work for Bar Charts

ChartSeriesItem seriesItem = new ChartSeriesItem();

seriesItem.Appearance.FillStyle.MainColor = Color;

seriesItem.Appearance.FillStyle.FillType = Telerik.Reporting.Charting.Styles.FillType.Solid;

The following for some reason will not Work for me on this new Line Chart

ChartSeries series = new ChartSeries();

series.Appearance.LineSeriesAppearance.Color = Color;

series.Appearance.LineSeriesAppearance.PenStyle = System.Drawing.Drawing2D.DashStyle.Solid;

I have try everything to make the line Chart work, however I have not come to a solution. What I am doing wrong with respect to a Line Chart in this version Q1, 2013

I will appreciate the response

General Discussions

answered on 14 Nov 2013

1 answer

697 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

2.0K+ 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

113 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

149 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

221 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

549 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

294 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

110 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

370 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