Telerik Forums
Reporting Forum
2 answers
140 views
I'm putting a bottom border on my list items (using a panel) to separate them, but don't want to show this border on the last item, because I have another border at the end of the list. Is there a way I can check if the record being processed is the last one, so that I can set the border to none?
Rayne
Top achievements
Rank 1
 answered on 11 Jul 2011
1 answer
59 views
Hi,

Ive created a silverlight report that based on a parameter dynamically adds some report fields in code. So in my NeedsData event on the report definition I check a parameter and create some extra fields and then set the datasource for the report.

This seems to work fine to generate and print the report but when I use the silverlight reportviewer to save as pdf (or any save as format) then it appears I get a new instance of the report on the server (I can set a breakpoint in the constructor) but never get a needsdata event call. I tried moving my code to the constructor but it seems that my parameter is not not initialized yet in the constructor.

Where would be the correct place to dynamically add some report textblocks, etc. in code so that it works for both report generation and save as?

thanks,
Adam
Peter
Telerik team
 answered on 11 Jul 2011
2 answers
181 views
Hello all, I'm using Telerik Report for the first time. Since we use other Telerik solutions, we opted to try it.

Here is my current problem. I created the Service in my server, where all my solution services are. I created a ClassLibrary with the report, and followed the tutorial to create the viewer in my Silverlight application. Now when I try to render/view the report I get an error: "Report is unavailable or session has expired."

I debugged my server, and both the report, and the data source (an object) are created. The report works fine in design preview. I checked asp.net session, and tried both StateServer and InProc sessions with the same error. 

As someone suggestion in this forum, I debugged with Fiddler and two calls are made, with the following response:

Fist call response:
HTTP/1.1 200 OK
Server: Microsoft-IIS/5.1
Date: Fri, 08 Jul 2011 12:07:42 GMT
X-Powered-By: ASP.NET
X-AspNet-Version: 4.0.30319
Content-Length: 812
Set-Cookie: ASP.NET_SessionId=faopnca1hygazmjbd2yx4x5d; path=/; HttpOnly
Cache-Control: private
Content-Type: text/xml; charset=utf-8
 
 
<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">
  <
s:Body>
    <
RenderAndCacheResponse xmlns="Telerik.ReportService">
        <a:Error i:nil="true"/>
        <a:Actions/>
        <a:Bookmarks i:nil="true"/>
        <a:HasDocumentMap>false</a:HasDocumentMap>
        <a:InstanceID>226a967f-0ce1-4951-99a8-94449583823f</a:InstanceID>
        <
a:NavigateBackEnabled>false</a:NavigateBackEnabled>
        <
a:NavigateForwardEnabled>false</a:NavigateForwardEnabled>
        <a:PageCount>1</a:PageCount>
        <a:PageNumber>1</a:PageNumber>
        <a:Parameters/>
        <a:Report>MJDS.Relatorios.RelatorioTipoPermissao, MJDS.Relatorios, Culture=neutral, PublicKeyToken=null</a:Report>
      </RenderAndCacheResult>
    </RenderAndCacheResponse>
  </s:Body>
</s:Envelope>


Second call response:
HTTP/1.1 200 OK
Server: Microsoft-IIS/5.1
Date: Fri, 08 Jul 2011 12:07:42 GMT
X-Powered-By: ASP.NET
X-AspNet-Version: 4.0.30319
Content-Length: 436
Cache-Control: private
Content-Type: text/xml; charset=utf-8
 
 
  <s:Body>
    <GetPageResponse xmlns="Telerik.ReportService">
        <a:Error>Report is unavailable or session has expired.</a:Error>
        <a:Buffer i:nil="true"/>
        <a:PageNumber>0</a:PageNumber>
      </GetPageResult>
    </GetPageResponse>
  </s:Body>
</s:Envelope>


But the above response did not help me solve the problem. What should I do, where should I look?
MJDS
Top achievements
Rank 1
 answered on 11 Jul 2011
9 answers
508 views
i am using RadControls Winforms Q1 2011 SP1 with Reporting Q1 2011 SP1,

in one of my reports in the page between 85-95 i get "A Generic GDI+ error occured"..
i tried a lot and the source of problem is a picturebox in my report that show the Student pictures.
Student objects loaded with Nhibernate

here is the stack trace from output window:

*** RENDER PAGES STARTED ***
*** RENDER PAGES DONE in 00:00:16.6764322 ***

An error has occurred while rendering the report: System.Runtime.InteropServices.ExternalException: A generic error occurred in GDI+.
   at System.Drawing.Imaging.Metafile..ctor(Stream stream)
   at Telerik.ReportViewer.WinForms.DrawablePage..ctor(Stream stream)
   at Telerik.ReportViewer.WinForms.PageLayout.AddPage(Stream stream)
   at Telerik.ReportViewer.WinForms.WinViewer.OnStreamReady(Object sender, StreamReadyEventArgs eventArgs)
   at Telerik.ReportViewer.WinForms.RenderFileManager.OnStreamReady(StreamReadyEventArgs eventArgs)
   at Telerik.ReportViewer.WinForms.RenderFileManager.RenderStream.Telerik.Reporting.Processing.IRenderStream.Finish()
   at Telerik.Reporting.ImageRendering.CompositionGdi.SendPhysicalPages()
   at Telerik.Reporting.ImageRendering.CompositionBase.SendPhysicalPages(Boolean force)
   at Telerik.Reporting.ImageRendering.ImageRendererBase.ProcessPages(CompositionBase composition, RenderingElement renderingReport, Int32 startPage, Int32 endPage, Boolean render)
   at Telerik.Reporting.ImageRendering.ImageRendererBase.ProcessPages(Report report, CompositionBase composition, Int32 startPage, Int32 endPage, Boolean render)
   at Telerik.Reporting.ImageRendering.ImageRendererBase.RenderPages(Report report, CompositionBase composition)
   at Telerik.Reporting.ImageRendering.ImageRendererBase.RenderReport(Report report, Hashtable renderingContext, Hashtable deviceInfo, CreateStream createStreamCallback, EvaluateHeaderFooterExpressions evalHeaderFooterCallback)
*** RenderReport #0 DONE in 00:00:16.7004656 ***

*** ReportProcessor.Render DONE in 00:03:24.9680921 ***

WinViewer> An error has occurred while rendering a report:
System.Runtime.InteropServices.ExternalException: A generic error occurred in GDI+.
   at System.Drawing.Imaging.Metafile..ctor(Stream stream)
   at Telerik.ReportViewer.WinForms.DrawablePage..ctor(Stream stream)
   at Telerik.ReportViewer.WinForms.PageLayout.AddPage(Stream stream)
   at Telerik.ReportViewer.WinForms.WinViewer.OnStreamReady(Object sender, StreamReadyEventArgs eventArgs)
   at Telerik.ReportViewer.WinForms.RenderFileManager.OnStreamReady(StreamReadyEventArgs eventArgs)
   at Telerik.ReportViewer.WinForms.RenderFileManager.RenderStream.Telerik.Reporting.Processing.IRenderStream.Finish()
   at Telerik.Reporting.ImageRendering.CompositionGdi.SendPhysicalPages()
   at Telerik.Reporting.ImageRendering.CompositionBase.SendPhysicalPages(Boolean force)
   at Telerik.Reporting.ImageRendering.ImageRendererBase.ProcessPages(CompositionBase composition, RenderingElement renderingReport, Int32 startPage, Int32 endPage, Boolean render)
   at Telerik.Reporting.ImageRendering.ImageRendererBase.ProcessPages(Report report, CompositionBase composition, Int32 startPage, Int32 endPage, Boolean render)
   at Telerik.Reporting.ImageRendering.ImageRendererBase.RenderPages(Report report, CompositionBase composition)
   at Telerik.Reporting.ImageRendering.ImageRendererBase.RenderReport(Report report, Hashtable renderingContext, Hashtable deviceInfo, CreateStream createStreamCallback, EvaluateHeaderFooterExpressions evalHeaderFooterCallback)
   at Telerik.Reporting.ImageRendering.ImageRendererBase.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.WinForms.RenderingThread.ThreadFunc(Object o)
The thread 0x1828 has exited with code 0 (0x0).
Michael Hilgers
Top achievements
Rank 1
 answered on 11 Jul 2011
1 answer
92 views
Hi

I am creating a report using Telerik Reports. I am also using DocumentMapText property for groups to display in the bookmarks section in pdf. But its not showing the hierarchy in the bookmarks according to the group. I have a top group with Region Name and I have ServiceTypes udner it. But Region and Service Types are being shown at the same level in the bookmarks and the same even in the reportviewer as well.

Please find the attached zip file containing the pdf and the report desginer and the code behind files and let me know where would be the mistake happened.

I have implemented by following the below url
https://demos.telerik.com/reporting/product-catalog/silverlight-demo.aspx

Thanks in advance
Ravindra
RAVINDRA
Top achievements
Rank 1
 answered on 11 Jul 2011
1 answer
121 views
Hi,
Whenever i going to add reportsource for the subreport it gives me error of "Object reference not set to instance of a object"
what could be the problem please let me know.

Thanks.
Manoj Gupta
Steve
Telerik team
 answered on 11 Jul 2011
1 answer
156 views
Whenever I try and drag and drop the Report Viewer WPF component (on my WPF window), i get the following error:

Initialization of 'Telerik.Windows.Controls.RadButton' threw an exception.
"Cannot locate resource: 'themes/expression/dark/rangecontrol.xaml'."

I am using VS2010 with the Telerik Reporting Q1 2011.  I followed the instructions for adding the report viewer to a WPF application, but have not been able to get past the above error.  Despite referencing all Telerik themes.

Please help.
Daniel Woodard
Top achievements
Rank 1
 answered on 08 Jul 2011
4 answers
302 views
I would like to dump the raw data that is used to create a report to Excel.
My intent is to be able to dump the raw data that feeds a report, be it a top level report, or a drill - through report (a report called by another report).  How can I retrieve the raw data that feeds the currently viewed report?

Telerik Reporting 2011 Q1 5.0.11.603
VS 2008 using WebForms
All reports datasources are SQLDatasource Stored Procedures with the report parameters fed from the application to the report object


The following is the method I am currently using for the top level report only.
Protected Sub btnDumpToExcel_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnDumpToExcel.Click
    Dim RunRpt As String = Me.ReportViewer1.Report.Reports(0).Name
 
    Dim tb As New DataTable(RunRpt)
    Dim dataConn As New SqlConnection
 
    Select Case RunRpt
        Case "evRptBehaviorChange"
            Dim report1 As Snap_EvalReports.evRptBehaviorChange = ReportViewer1.Report.Reports(0)
            With report1
                Dim xSQLDatasource As Telerik.Reporting.SqlDataSource = .DataSource
                Dim SQLConnectionString As String = System.Configuration.ConfigurationManager.ConnectionStrings(xSQLDatasource.ConnectionString).ToString
 
                Dim xSelectCommand As String = xSQLDatasource.SelectCommand
 
                dataConn.ConnectionString = SQLConnectionString
                dataConn.Open()
                Dim sdc As SqlCommand = New SqlCommand(xSelectCommand, dataConn)
                sdc.CommandTimeout = LengthOfTimeOut
                sdc.CommandType = CommandType.StoredProcedure   'xSQLDatasource.SelectCommandType
 
                For Each p As Telerik.Reporting.SqlDataSourceParameter In xSQLDatasource.Parameters
 
                    Dim xParam As SqlParameter = New SqlParameter(p.Name, p.GetType)
                    sdc.Parameters.Add(xParam)
                Next
 
                '                       ALTER   PROCEDURE [dbo].[StoredProcedure1]
                '(@FiscalYearID      int=3)
                sdc.Parameters.Item("@FiscalYearID").Value = CType(Session("spaFiscalYear"), Integer)
                Dim sda As SqlDataAdapter
                sda = New SqlDataAdapter(sdc)
                sda.Fill(tb)
                dataConn.Close()
                dataConn = Nothing
                XLSExport(tb, RunRpt)
            End With
    End Select
End Sub

Thank you in advance.

Patti
P.
Top achievements
Rank 2
 answered on 08 Jul 2011
1 answer
103 views
Hi:

i have designed the telerik report using telerik reporting, i am passing 4 parameters to the report.
when i click on preview it is asking for parameters, when i entered first parameter and moved to next parameter, the information i entered in the first parameter is erasing.
The report is getting refreshed.

Any help is appreciated.

Thanks
Venu
Peter
Telerik team
 answered on 08 Jul 2011
2 answers
98 views
I want to hidden the same under picture, but I don't know current version supported. Can you help me ?
abc
Top achievements
Rank 1
 answered on 08 Jul 2011
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?