6 answers

224 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

80 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

310 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

758 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

answered on 12 Nov 2013

2 answers

242 views

Modify TextBoxValue in Table

Hi Guys

I saw the below link

http://www.telerik.com/help/reporting/m_telerik_reporting_processing_tablerow_getcell.html
I am able to access my dynamic table cell values but how to modify cell values

in C#

Telerik.Reporting.Processing.ReportItem item = cell.Item;
//(In cell.Item i can see html text box values)
//How to modify my dynamic TextBox Values

Thanks
Senthil

General Discussions

answered on 12 Nov 2013

3 answers

137 views

Subreports randomly are coming in blank

Telerik Version: 6.1.12.820

Hello,

I have a major issue with some of the subreports coming in as white space (not a blank table).

We have a win form with 2 telerik reportviewers stacked ontop of each other. One displays the individual mainpage + subreport combo while the other loads all the combinations of the main page + subreports (about 100 or so, totaling 350 pages (abouts), this one uses the ReportBook concept). We do this because we need to be able to preview the reports while the large report is building since it takes anywhere from 3-20 mins. And once it's completed we hide the single report viewer and show the one with all the reports.

All this was working fine but in the last few days it has been displaying blank subreports on both the large report and the single report, not necessarily the same subreport.

<Summary>

I have 1 main report with an empty detail section. I have a subreport with a table in it (blank). At runtime I basically stuff the subreports in the main report. All this is working fine except as of lately, several subreports are coming up as white space. I mean, you see the main pages header and footer, but where the detail is, it's all white.

Now to take this a step further, if you save as pdf, some of the subreports are white spaces, not necessarily the same ones that are blank in the viewer.

this is basically what I do:

                    foreach (...)
                    {
                        var genericSubReport = new GenericSubReport(data, title);

Telerik.Reporting.InstanceReportSource instanceReportSource = new Telerik.Reporting.InstanceReportSource();

instanceReportSource.ReportDocument = genericSubReport;

                        //use w/o subreports defined
                        Telerik.Reporting.SubReport subReport = new Telerik.Reporting.SubReport();
                        subReport.Location = new Telerik.Reporting.Drawing.PointU(Telerik.Reporting.Drawing.Unit.Inch(subReportDefaultLocation), Telerik.Reporting.Drawing.Unit.Inch(currentLocation));
                        subReport.Size = new Telerik.Reporting.Drawing.SizeU(Telerik.Reporting.Drawing.Unit.Inch(subReportWidthSevenPointNine), Telerik.Reporting.Drawing.Unit.Inch(subReportSpacer));
                        measureReport.Items["detailSection"].Items.Add(subReport);

subReport.ReportSource = instanceReportSource;

                        subReportIndex++;
                        currentLocation += LOCATION;
                    }

The subreport itself, builds the table in the code behind. We do all this becase it was either design 100+ reports or use a dynamic model. Other thing to note is the subreports do not use the NeedDatasource but do use the ItemDataBinding.

</Summary>

General Discussions

answered on 11 Nov 2013

2 answers

183 views

Toggle Mark Initially expanded doesn't work for me

The toggling works. I'm just doing grouping and putting the action toggle visibility on a textbox in the group header and the toggle targets are the groups below. (I'm not using a table or crosstab). It's just always expanded initially. If I check the Initially expanded all it does it change the + to a - but all the detail items or group below items are still displayed. I think I'm missing something.

This report is very basic
Group 1 -- Year
Group 2 -- Month
Details -- Day Data1 Data2 Data3

I have toggle vis on group 1 and group 2

General Discussions

answered on 11 Nov 2013

1 answer

51 views

Report Designer Error and shut down

hi

while designing the report an error message appears, and the program shuts down. How to troubleshoot this problem?

program bug screenshots;
http://prntscr.com/22jxwy
http://prntscr.com/22jy0k

my system;
http://prntscr.com/22ol75

Thanks.

Report Designer (standalone)

answered on 11 Nov 2013

3 answers

268 views

set default path for Export

Dear experts

Is there anyway to set the default path for Save As dialog during Export in Wpf Report Viewer?

Thanks
tungngie

General Discussions

answered on 11 Nov 2013

3 answers

631 views

Programmatically Export Multi-page report to PNG format

Hi,

I would like to programmatically do an export of my multi-paged report to PNG format, i.e. the end result should be 3 PNG files for a 3 paged report and so on. Is it possible to do this? And can I specify the filenames for each file programmatically or is it auto-generated? The whole process should be transparent to the end-user, i.e. I do not want the end user to click on the Export button and type in the file name in the File Dialog that pops up. Instead the program should do an auto-export to the required format and use names such as "Report1_pg1.png", "Report1_pg2.png" etc... Hope you can help me on this. Thanks.

General Discussions