1 answer

186 views

Render .docx file through programatically using reporting.

Hi,

I want to generate .docx file at runtime from telerik reporting. But it is giving error message "DOCX file format is not supported." while rendering.
Rendering is fine with "RTF". But telerik says that we are able to export in to .docx.

General Discussions

answered on 10 Aug 2012

1 answer

126 views

Wrong version of OpenAccess referenced in dll

Hello, for some time I have been pulling my hair out trying to resolve a reference error when I upgraded my Telerik Reporting to the latest version. Everytime I run my web app on my client's network I get a message stating Telerik.OpenAccess version 2011.3.1129.2 could not be found, but on refreshing the page, this error would disappear.

I searched for hours trying to find the incorrect reference and finally found it, but not in my code.

The incorrect reference is in version 6.1.12.611 of Telerik.Reporting.DatabaseSession.dll and if I use Just Decompile, I can see a missing reference to Telerik.OpenAccess version 2011.3.1129.2 and also to Telerik.OpenAccess.35Extensions version 2011.3.1129.2, at least in my version of the reporting dll.

How can there be a reference to 2011 Q3 OpenAccess in the 2012 Q2 Telerik Reporting dll?

Regards, Jonathan

General Discussions

answered on 10 Aug 2012

4 answers

163 views

Converting Reporting Tool to 2012 Q1

I have inherited an application that was using a old version of the reporting tool.
Good news: I've gotten the above version installed on my machine (where none was installed previously).
Bad news: I got a number of compile errors now and I really haven't found anywhere to go where I can figure out what the code was/is doing.

I have made some changes to other methods (SWAGS trust me), but NO changes here. Here is the method that is currently causing me headaches, although I'm sure there is more coming:

    Private Sub DetailSection1_ItemDataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles DetailSection1.ItemDataBound
        Dim section As Processing.DetailSection = TryCast(sender, Processing.DetailSection)
        Dim typeText As Processing.ReportItemBase = section.Items.Find("txtType", False)(0)
        Dim mfgText As Processing.ReportItemBase = section.Items.Find("txtMFG", False)(0)
        Dim catalogText As Processing.ReportItemBase = section.Items.Find("txtCatalog", False)(0)
        Dim qtyText As Processing.ReportItemBase = section.Items.Find("txtQty", False)(0)
        Dim leadTimeText As Processing.ReportItemBase = section.Items.Find("txtLeadTime", False)(0)
        Dim notesText As Processing.ReportItemBase = section.Items.Find("txtNotes", False)(0)

        Dim row As DataRowView = TryCast(section.DataItem, DataRowView)
        If row IsNot Nothing Then
            Dim val As Object = row.Row("LINE_TYPE")
            If Not (TypeOf val Is DBNull) AndAlso _
              val.ToString.ToUpper = "GRP" Then
                typeText.Visible = False
                mfgText.Visible = False
                catalogText.Style.Font.Bold = True

            End If
        End If

End Sub

Any help will be greatly appreciated!

Rich

General Discussions

answered on 10 Aug 2012

1 answer

203 views

Textbox background image alignment

Telerik,

I got a small problem with the background image for textboxes see screenshot below.
http://screencast.com/t/fNRZWVqLIJih

I use the following properties:
http://screencast.com/t/pDsNSRml4N3o

Is it possible to align the image to the right side?

General Discussions

answered on 10 Aug 2012

1 answer

181 views

Problems with Exception handling

Occasionally my report generates an exception which I wish to catch and handle in my web page.
I had a look at the post : http://www.telerik.com/community/forums/reporting/telerik-reporting/how-to-handle-errors-exceptions.aspx
which provides a nice piece of c# code.
I have translated this to VB to get this :

AddHandler _rptBody.[Error], Sub(innerSender As Object, eventArgs As ErrorEventArgs)
      Me.ReportViewer.Report = Nothing
       Me.Label1.Text = eventArgs.Exception.Message.ToString()
End Sub

But sadly Visual Studio informs me that :

Error is not an event of object.

I have to say that c# is my language and not VB but sadly I have to do this in VB.

Am I doing something wrong here?

General Discussions

answered on 10 Aug 2012

1 answer

93 views

Some problemes to bind datas to a report

Hi,

i would bind a report with datas. i have a DAL method returns a collection of A objects contains a B object list.
List of A object contains properties and a list of B object.

i would fill my report's textboxes with A properties and a table with A list of B object.
the DAL method is called from a aspx page with a reportviewer and a reportbook.

my reportviewer is correctly displayed but with empty reports.

Filling the report with A object properties works. but filling the table of the report with A object's List<B> does'nt work.

i fill my cells with =Fields.property

in the aspx page, i bind my report with the object with : report.Datasource = A object;

How can i fill my table?
thanks

General Discussions

answered on 10 Aug 2012

1 answer

254 views

Cross Tab Report Issue

I have a report that I am trying to create a cross tab for.

I can get it to creat the report fine but for some reasons the pages will repeat for the toalt number of records I have.
So when I print a report for 65 records it formats and creats the record and the first page is correct, but it creates 65 pagas all of them exaclty the same. What am I missing?

my seltect is as follows

SELECT  m.FGID, GroupName, CategoryDescription, GroupDescription, TickerAbv, SecurityMasterDescription, SUM(MarketValue) AS Total, e.FamilyMemberName , percentage, (SUM(MarketValue) * percentage) AS eTotal

what I would like is to group on CategoryDescription and GroupDescription
then display SecutirityMasterDescription and Total

then pivot so the FamilyMemberName becomes the dynamic headers with the eTotal as the detail under the FamilyMemberName

The report formats to this design, but it displays it 65 times.
Also one other issue, there are time where there are no matching FamilyMembers so iti si getting a null value and printing an empty column, is their a way to suppres the blank column.

General Discussions

answered on 10 Aug 2012

5 answers

359 views

ASP.NET: ReportViewer images are broken and misaligned

Hi,

I have never used the ReportViewer before. When I add the ReportViewer to my web application, it looks great and styled as it should in the design, but when I go to run my program, the images are all broken, and there is no styling of the bar. This is before I assign any report to the viewer.

Unfortunately, I have this project which is due in a very short time frame, and this is holding me up. I hope that someone may have a quick answer for me.

I am running Reporting Q3 2007 and Visual Studio 2008.

I tried my existing application that I am trying to get the ReportViewer to show up in and I created a brand new application with just the ReportViewer and I received the same result.

Any help anyone has would really be great. I may be forced to use Crystal Reports to finish my project otherwise. Thanks.

Andre

General Discussions

answered on 09 Aug 2012

2 answers

1.7K+ views

[ExtensionManagerException: Error loading extension type with name .]

Hi,

We are experiencing the following error when adding these lines to the web.config:

    <Telerik.Reporting>
       <Extensions>
           <Render>
               <Extension name="XLS">
                   <Parameters>
                       <Parameter name="DefaultPageFooter" value="false"/>
                   </Parameters>
               </Extension>
               <Extension name="XLSX">
                   <Parameters>
                       <Parameter name="DefaultPageFooter" value="false"/>
                   </Parameters>
               </Extension>
           </Render>
       </Extensions>
   </Telerik.Reporting>

This only happens when it is outside of the development environment and it seems to be down the the XLSX segment (if I remove that then it works).

The error that we are getting is this:

Server Error in '/' Application.

A null or zero length string does not represent a valid Type.

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: System.TypeLoadException: A null or zero length string does not represent a valid Type.

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:


            [TypeLoadException: A null or zero length string does not represent a valid Type.]
   System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) +10161414
   System.RuntimeType.PrivateGetType(String typeName, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) +42
   System.Type.GetType(String typeName, Boolean throwOnError) +71
   Telerik.Reporting.Processing.ExtensionManagerBase.CreateExtensionInfo(String typeName, String extensionName) +55

[ExtensionManagerException: Error loading extension type with name .]
   Telerik.Reporting.Processing.ExtensionManagerBase.CreateExtensionInfo(String typeName, String extensionName) +214
   Telerik.Reporting.Processing.ExtensionManagerBase.Config(ExtensionInfoCollection extensions, ReportingConfigurationSection section) +539
   Telerik.Reporting.Processing.ExtensionManager.get_Instance() +98
   Telerik.Reporting.Processing.ExtensionManager.ListExtensions(Type extensionType) +13
   Telerik.Reporting.Processing.ReportProcessor.ListRenderingExtensions() +27
   Telerik.Reporting.Processing.ReportProcessor.GetExtensionInfoCore(String name) +29
   Telerik.Reporting.Processing.ReportProcessor.GetExtensionInfo(String format) +136
   Telerik.Reporting.Processing.ReportProcessor.RenderCore(String format, IList`1 reports, Hashtable deviceInfo, Hashtable renderingContext, CreateStream createStreamCallback) +22
   Telerik.ReportViewer.WebForms.ReportRenderOperation.RenderReport(String format, IList`1 processingReports, Hashtable deviceInfo, Hashtable renderingContext, CreateStream createStreamCallback) +43
   Telerik.ReportViewer.WebForms.ReportPageOperation.RenderReport(String format, IList`1 processingReports, Hashtable deviceInfo, Hashtable renderingContext) +192
   Telerik.ReportViewer.WebForms.ReportRenderOperation.PerformOperationOverride() +223
   Telerik.ReportViewer.WebForms.BasicHandler.ProcessRequest(HttpContext context) +195
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +599
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +171

Version Information: Microsoft .NET Framework Version:2.0.50727.5420; ASP.NET Version:2.0.50727.5420

We are using 2011 Q3 or the reporting so we know it is not a case of missing the XamlRendering dll (as it is no longer required we believe).

Any help would be appreciated.

Many thanks

Carl Howarth
PSP IT Design & Development

General Discussions

answered on 09 Aug 2012

2 answers

195 views

Chart with Multivalue parameter SqlDataSource

Dear Telerik Support Team,

would it be possible for you to provide with a sample solution on how to generate a report containing a Chart (Lines) that is filled with a SqlDataSource with a multi valued parameter using the datagroupcolumn value.

I have tried for hours to achieve this but cannot get it to work. The chart does not split the selected values into series or the datasource does not select multiple data.

To recreate the problem the steps would be as follows:

- Create a report with a multi value parameter that accepts instance ids e.g. person ids
- Create a SqlDataSource with the same parameter and pass the reports parameter value to it
- Create a chart and set the DataGroupColumn to the persons id to get a series for each person contained in the datasource
- Execute the preview and select two or more persons via the report parameter
- The chart will only display one series, independant of what is selected as a parameter whereas a crosstable set to the same datasource with column grouping set to the person id will display multiple rows.

I did not add any series explicitly. If I add some series explicitly the legend text will be the explicitly specified name. What I need would be the value of the DataGroupColumn as a Legend entry. The workaround you provide in your example with #NAME:#VALUE does not work as it references the Series name.

Is there a way to tell the Chart which DataSource Columns to use for X,Y, LEGEND if no Series have been defined explicitly?
I have found the PlotArea.XAxis.DataLabelsColumn but nothing for Y or Legend. Is it mandatory to specify series explicitly?

I'd appreciate a quick response,
thank you for your time.

General Discussions

answered on 09 Aug 2012