1 answer

175 views

Object cannot be cast from DBNull to other types

I have a report that depends on database made of not null and null values which are updated by different users in different levels. The report should display all information including updated 1, but i keep on getting the above error when i run report after updating records in database but when i remove filtering it works but sometimes it refuses. Can any1 help me with solution on how to handle this error. My report should filter some records form others. For example; it should display information of hired staff from list of registered staff. when i remove the filtering it displays all staff info including those who are not posted for job. Help me with how to handle null values in report.

Regards
Mex

General Discussions

answered on 01 Apr 2011

3 answers

111 views

PictureBox image height limitation?

Hi, we are working around this Telerik Reporting known limitation...
"Limited rich text/html content formatting options in the textbox item (only text formatting is available)"

...by converting the HTML generated by RadEditor into an image, then placing this image into a PictureBox control of the Telerik report.

This works OK for us except we have noticed that if the image is > 16384 pixels in height, then the Telerik online viewer shows a 1 pixel high image in place of the actual image, but appears to reserve enough blank space for the actual sized image.

Is this some kind of limitation in the PictureBox control? BTW if we export to PDF the image is rendered just fine.

General Discussions

answered on 01 Apr 2011

2 answers

1.0K+ views

Nested object with table inside table inside table

My problem:
It seems like i can have table inside table upto 2 layer and my third nested table only prints the first data of my nested collection.

I found help where List inside list inside list..... but I am looking for table inside table inside for my nested object data.
http://www.telerik.com/community/forums/reporting/telerik-reporting/list-in-list-in-list-etc.aspx

So, i have my object set like this (see attached .png):
My Data class contains:
        List<SampleModel>
        {
                new SampleModel
                {
                       contain List<SampleSubItem>
           {
               contain List<Sample2SubItem>
               {
                    contain List<Sample3SubItem>
                }
                    }
            }
      }
}

If you see the attached "report2.png", it shows the preview of my report..
My first table (white color) is good
Its nested table and object SubItem (orange color) is good
its nested table and object Sub2Item (green color) looks good but the data is incorrect. They are all showing first index of the list, that is, Sub2Item 1
its nested table and object Sub3Item should error.

Any help would be great or Is subreport the only fix?

Thank

General Discussions

answered on 01 Apr 2011

6 answers

160 views

HTML and PDF versions not the same

I've been struggling to figure out why the first 2 sections of my report are blank on-screen. I can't find any reason for it.

I exported the report to PDF to show it to a coworker, and discovered that the PDF version is rendering exactly as it should! (I also just now discovered that the Preview tab in the designer works OK, but the Html Preview does not)

Can anyone give me any ideas about what to change to make them both the same? What commands are processed differently in the HTML and PDF renderers?

<edit>
I've just realized that the first sections are not missing - the problem is the details section is starting on page 2 instead of page 1. Page 1 has only the report header, page header, and page footer in the HTML version.

(it's a web app using Visual Studio 2008, Telerik Reporting Q3 2009, and C# - in case any of that matters)

General Discussions

answered on 01 Apr 2011

3 answers

136 views

Crosstab Report OutOfMemoryException

Is there a limit to the amount of information the a crosstab report can return? We have a report that generally runs fine, but when a user tries to run the report for a long date range, we are getting an OutOfMemoryException thrown. I've included the information from Event Viewer.

Event code: 3005

Event message: An unhandled exception has occurred.

Event time: 11/12/2010 10:32:14 AM

Event time (UTC): 11/12/2010 3:32:14 PM

Event ID: 33249fffceea432586db46a80ca2637d

Event sequence: 617

Event occurrence: 14

Event detail code: 0

Application information:

Application domain: /LM/W3SVC/194803890/Root-1-129339523234331482

Trust level: Full

Application Virtual Path: /

Application Path: XXXXXXXXXX
Machine name: XXXXXXXXXXX

Process information:

Process ID: 3456

Process name: w3wp.exe

Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:

Exception type: OutOfMemoryException

Exception message: Exception of type 'System.OutOfMemoryException' was thrown.

Request information:

Request URL: XXXXXXXXXXXXXX
Request path: /Telerik.ReportViewer.axd

User host address: 67.139.94.50

User: ADMIN

Is authenticated: True

Authentication Type: Forms

Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:

Thread ID: 7

Thread account name: NT AUTHORITY\NETWORK SERVICE

Is impersonating: False

Stack trace: at System.String.GetStringForStringBuilder(String value, Int32 startIndex, Int32 length, Int32 capacity)

at System.Text.StringBuilder.GetNewString(String currentString, Int32 requiredLength)

at System.Text.StringBuilder.Append(Char value)

at System.IO.StringWriter.Write(Char value)

at System.Web.UI.HtmlTextWriter.RenderBeginTag(HtmlTextWriterTag tagKey)

at Telerik.Reporting.HtmlRendering.HtmlPage.RenderScripts(HtmlTextWriter writer, List`1 scripts)

at Telerik.Reporting.HtmlRendering.HtmlPage.Render(HtmlTextWriter primaryWriter, HtmlRenderingContext renderingContext)

at Telerik.Reporting.HtmlRendering.HtmlReport.Render(HtmlTextWriter writer)

at Telerik.Reporting.HtmlRendering.HtmlRenderingExtension.Telerik.Reporting.Processing.IRenderingExtension.Render(Report report, Hashtable renderingContext, Hashtable deviceInfo, CreateStream createStreamCallback, EvaluateHeaderFooterExpressions evalHeaderFooterCallback)

at Telerik.Reporting.Processing.ReportProcessor.Render(IList`1 reports, ExtensionInfo extensionInfo, Hashtable renderingContext, Hashtable deviceInfo, CreateStream createStreamCallback)

at Telerik.Reporting.Processing.ReportProcessor.RenderReport(String format, IReportDocument reportDocument, Hashtable deviceInfo, Hashtable renderingContext, CreateStream createStreamCallback)

at Telerik.ReportViewer.WebForms.ServerReport.Render(HttpResponse response, String format, Int32 pageIndex)

at Telerik.ReportViewer.WebForms.ReportPageOperation.PerformOperation(NameValueCollection urlQuery, HttpContext context)

at Telerik.ReportViewer.WebForms.HttpHandler.ProcessRequest(HttpContext context)

at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

General Discussions

answered on 01 Apr 2011

1 answer

202 views

Conditional totals

Hi all,

In my group footer(s) I am displaying averages (using Avg). However, I need these averages to exclude any zero and null values in the detail lines. How do I go about doing that?

Lucien Dol
QicSoluciens
Wellington, New Zealand

(Telerik Reporting Q1 2011 v5.0.11.316)

General Discussions

answered on 01 Apr 2011

2 answers

327 views

Adding reports to a reportbook

Hello all.

I am trying to setup a report book (programmatically) to load in three reports into a web viewer. Each report is one page of a large 3 page report that I am trying to duplicate here. I had to break it up because each page had different page setting (mainly the orientation). Now I am hoping to read a table and print all three reports for each record of the table (thus producing a three page report for each record). At some point I will pass an ID variable to each report for every record.

I started out with the following code but get an error that the reports are not declared (the OFC21, OCF21b, and OFC21c reports).

        Dim reportBook As New ReportBook()
        reportBook.Reports.Add(OFC21)
        reportBook.Reports.Add(OFC21b)
        reportBook.Reports.Add(OFC21c)

Then I tried to create the report object first and then pass it to the report book but I get the same error when I try to declare the reports.

        Dim reportBook As New ReportBook()
        Dim rOFC21 As New OCF21()
        Dim rOFC21b As New OCF21b
        Dim rOFC21c As New OCF21c

        reportBook.Reports.Add(rOFC21)
        reportBook.Reports.Add(rOFC21b)
        reportBook.Reports.Add(rOFC21c)

At this point I have no idea why it is having an issue reading the reports. The reports were created in a class library project and the dll was brought into this one.

Funny thing is, if I drop a report book control on the page and try and add the reports through there, it sees the reports without and issues.

Any help would be much appreciated.

Paul.

General Discussions

answered on 01 Apr 2011

6 answers

230 views

PDF with bookmark

Is there a way to initially display the document map when exporting to PDF.
I saw in the documentation that the report viewer has a property "DocumentMapVisible" that set this. I'm not using a report viewer, I export to PDF. When the pdf opens the document map is not initially displayed.

General Discussions

answered on 01 Apr 2011

1 answer

97 views

Labels Report # Per Page

Using the multi-column feature, I have created a labels report that displays 30 labels per page (3 across 10 down). However, after 11 pages, the report starts displaying only 29 labels 10 in the first column, 10 in the second and 9 in the third. From then on, it displays 29 per page for the rest of the report. It does this for both PDF and RTF formats and if I print it directly from the report viewer. There does not appear to be anything different about the addresses on page 12 so I am not sure why this would be happening. Any suggestions?

thanks!

General Discussions

answered on 01 Apr 2011

1 answer

420 views

Unknown server tag 'telerik:ReportViewer'.

I'm getting the following error in all Telerik reports in a .NET 4.0 web app I have recently taken over from somebody else who has resigned. Thus far I've had success by installing required MSI files and removed hard-coded versions in web.config files and adding references to the DLL files. But this approach hasn't worked for Telerik ReportViewer. Am I missing something? I've installed Reporting Q3 2010 and added references to Telerik.Reporting.dll and Telerik.ReportViewer.WebForms.dll and also ticked quite a few related namespaces below these references in the properties for the solution, but am getting nowhere. I have never used Telerik before but like what I see so far, apart from these errors :-(

Here's the error (and thanks):

Server Error in '/' Application.

Parser Error

Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.

Parser Error Message: Unknown server tag 'telerik:ReportViewer'.

Source Error:


            Line 3:  </asp:Content>
Line 4:  <asp:Content ID="Content2" ContentPlaceHolderID="cphReport" runat="server">
Line 5: <telerik:ReportViewer ID="ReportViewer1" runat="server" Report="ReportsLib.SummaryByActivity, ReportsLib, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" Line 6:          Skin="Office2007" Width="100%" Height="700px" DocumentMapVisible="False" 
Line 7:          ShowZoomSelect="True">

Source File: /MyReport.aspx Line: 5

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.225

General Discussions

answered on 31 Mar 2011