Questions on Reporting Forum

1 answer

110 views

hi guys

i have a problem with the telerik report designer.
we have a 2 tier application, containing a GUI layer and a DAL layer.
for the reports we created a new library because not all customers use the same reports.
the reports library has a reference to the DAL library. i created a new report and choose the dataset
from the DAL library.

a dataset and a tableadapter are inserted from the toolbox to the report. when I run the software, the report works fine.
but when i click the preview tab in the design mode, no data is displayed.

if the dataset and the tableadapter are attached to the same report project the data is displayed in the report preview correctly.

its dificult to create a report without preview.

does anybody has an idea or a work around?

any help is appreciated

thanks a lot in andvance,

marino

General Discussions

answered on 26 Nov 2009

1 answer

111 views

Showing pie chart based on DatagroupColumn

Hi,

i want to show the pie chart based on DataGroupcolumn

3 columns -
1.resource name - legend
2. usage time - Y axis
3. Date - X axis
Line chart is showing correctly,This is the coding i used(displaying number of lines based on resources)

                 DataSet dsChart = new DataSet();
                Telerik.Reporting.Processing.Chart chart = (Telerik.Reporting.Processing.Chart)sender;
                Telerik.Reporting.Chart chartDef = (Telerik.Reporting.Chart)chart.ItemDefinition;
                chartDef.PlotArea.XAxis.Clear();
                dsChart = DBMethods.GetDetailsForInstrumentUsageByDateChart(facilityId, fromDate, toDate, isActual, resourceId);
                (sender as Telerik.Reporting.Processing.Chart).DataSource = dsChart;
                chartDef.DefaultType = Telerik.Reporting.Charting.ChartSeriesType.Line;
                chartDef.DataGroupColumn = "resource_name";
                chartDef.AutoLayout = true;
                chartDef.IntelligentLabelsEnabled = true;
                chartDef.Legend.Appearance.GroupNameFormat = "#VALUE";//this will display the usage time
                chartDef.PlotArea.XAxis.DataLabelsColumn = "date";

How to show the pie chart based on those three fields?

Thanks for any help

General Discussions

answered on 26 Nov 2009

2 answers

131 views

HTMLTextBox trouble rendering Grave Accents and Acute Accents...

Hello,

We're using Telerik Reporting Q2 2009 (dll version: 3.1.9.807) and we're having trouble rendering Grave Accents " ` " and Acute Accents " ´ " inside of a HTMLTextBox control.

Any ideas why this would be happening?

Thanks,

Allen

General Discussions

answered on 25 Nov 2009

1 answer

151 views

The type of column with name PropertyName is not numeric

Hi there,

I have spotted a strange problem which I have managed to get around but thought it worth sharing:

I have a report whose datasource was an IList of a custom object. The custom object's class has an int property; 'PropertyName' in this example. On my report I have a table of data and two charts, all bound to the same data source. The table rendered without any issues, however the chart came up with the error mentioned in the title and would not render. This report had worked initially so it surprised me to learn that a very minor change had caused this error.... if I change the datasource from an IList to a List the error disappears.

Hopefully this will save somebody the pain gone through to rectify this, and perhaps this issue could be looked into and maybe addressed.

Thanks, Carl

General Discussions

answered on 25 Nov 2009

1 answer

131 views

Changing series item labels

I can't find a way to change the skin for the chart, and the default labels are difficult to read on the gray background. I was able to change the background color in codebehind, but I can't seem to change the font color. Is there a way to do this? I'm looking to change both the xaxis and yaxis labels as well as the actual series item labels.

Thanks,
Wade

General Discussions

answered on 25 Nov 2009

8 answers

139 views

MetaFiles in PDF

I am using a MetaFile image type for a picture box. The PDF renderer doesn't appear to be rendering it correctly. It looks like the renderer is first converting the image type to jpeg, tiff, etc. Therefore the Image comes up as an rastered image in the PDF instead of a drawn EMF or WMF. Is there a way around this? The current reporting program I have does this correctly, but I'd rather go with you because there software has many more issues.

Thanks

General Discussions

answered on 25 Nov 2009

1 answer

142 views

Telerik Reporting and 3rd Party Controls

Hi I am thinking about picking up the Telerik Reporting component. However I am using other third party WinForm controls (Dundas Graph and Mind Fusion Flowchart Control). Am I able to use these controls within the Telerik Report? I spoke with Mindfusion a while back and they noted that:

"you can use the Flowchart.NET image and SVG export features to create diagram images and embed them into any kind of reporting tool that has bitmap or SVG support. To create image or SVG files, use the Diagram.CreateImage method, or the SvgExporter class"

I have not worked with a reporting tool before and I am not sure how you incorporate existing Visual Studio controls or 3rd party controls into the ouput of the report.

Thanks

General Discussions

answered on 25 Nov 2009

1 answer

263 views

Rendering a report directly into a RadWindow

Hi. I just got my license to Telerik Reporting and am excited to use it in my website in place of the SQL Reporting Services that I have used to now.

My site generates numerous reports to be printed on the client computer. I use a window.open script to popup a single ReportRendering.aspx page to which I send report ID and parameters (parameters in a Session variable). The page uses Response methods to stream the rendered report from the SQL Reporting engine. I would like to replicate this process using Telerik Reporting. So I created a page 'reportpage.aspx' that is empty except for the following code behind:

    
            public partial class reporting_reportpage : System.Web.UI.Page  
        
            {  
        
                protected void Page_Load(object sender, EventArgs e)  
        
                {  
        
                    Telerik.Reporting.Report MyReport = new Telerik.Reporting.Report();  
        
                    MyReport = (Telerik.Reporting.Report)Session["taljacreport"];  
        
                    ExportToPDF(MyReport);  
        
                }  
        
                void ExportToPDF(Telerik.Reporting.Report reportToExport)  
        
                {  
        
                    ReportProcessor reportProcessor = new ReportProcessor();  
        
                    RenderingResult result = reportProcessor.RenderReport("PDF", reportToExport, null);  
        
                    Response.Clear();  
        
                    Response.ContentType = result.MimeType;  
        
                    Response.Cache.SetCacheability(HttpCacheability.Private);  
        
                    Response.Expires = -1;  
        
                    Response.Buffer = true;  
        
                    Response.BinaryWrite(result.DocumentBytes);  
        
                    Response.End();  
        
                }      
        
            }

On a test page, I put a RadWindow, a test buton, and a javascript function to open the RadWindow:

    
            <%@ Page Language="C#" AutoEventWireup="true" CodeFile="TelerikTestForm.aspx.cs" Inherits="TelerikTestForm" %> 
        
            <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
        
            <html xmlns="http://www.w3.org/1999/xhtml">  
        
            <head runat="server">  
        
                <title></title>  
        
            </head> 
        
            <body> 
        
                <form id="form1" runat="server">  
        
                    <telerik:RadScriptManager ID="RadScriptManager1" runat="server" /> 
        
                    <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">  
        
                        <script type="text/javascript">  
        
                            function PopUpReport() {  
        
                                var wnd = window.radopen("reporting/reportpage.aspx", "rdwReport");  
        
                                return false;  
        
                            }  
        
                        </script> 
        
                    </telerik:RadCodeBlock> 
        
                    <div> 
        
                        <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Button" /> 
        
                    </div> 
        
                    <telerik:RadWindowManager ID="rwmReport" runat="server" > 
        
                        <Windows> 
        
                                <telerik:RadWindow ID="rdwReport" runat="server" Width="850px" Height="1100px" Modal="true" VisibleStatusbar="False"   
        
                                    Behaviors="Move,Close" Left="" NavigateUrl="" Top="" > 
        
                                </telerik:RadWindow> 
        
                        </Windows> 
        
                    </telerik:RadWindowManager> 
        
                </form> 
        
            </body> 
        
            </html>

On the test page's code-behind, I put the following:

    
            public partial class TelerikTestForm : System.Web.UI.Page   
        
            {  
        
                protected void Page_Load(object sender, EventArgs e)  
        
                {  
        
                }  
        
                protected void Button1_Click(object sender, EventArgs e)  
        
                {  
        
                    Report myreport = new userdirectory();  
        
                    myreport = ReportMethods.AddReportParameters(myreport, null);  
        
                    Session["taljacreport"] = myreport;  
        
            //        ClientScript.RegisterClientScriptBlock(this.GetType(), "openreport", "var wnd=window.open('reporting/reportpage.aspx', '_blank', 'height=1100,width=850,directories=no,status=no,titlebar=no,toolbar=no,menubar=no,location=no');", true);  
        
            //        ClientScript.RegisterClientScriptBlock(this.GetType(), "openreport", "var wnd = window.radopen('reporting/reportpage.aspx', 'rdwReport'); return false;", true);  
        
                    ClientScript.RegisterClientScriptBlock(this.GetType(), "openreport", "PopUpReport()", true);  
        
                }  
        
            }

The 'ReportMethods.AddReportParameters() method is one I wrote to append parameters bot the report class by parsing a concatenated string (none are needed for this report).

Note that I have three lines of ScriptBlock execution for opening the rendering page in a browser popup or in the RadWindow. The first, with the browser popup works, but neither of the last two do, either writing the radopen script directly (nothin happens) or via the script function (script object reference error on 'PopUpReport()'. I imagine that this is just my poor understanding of scripting the RadWindow, but I am stuck. I would really like to use the RadWindow since it is so good on all the browsers. If anyone could shed some light on this for me, I would be grateful. Thank you!

Thomas Stanley

General Discussions

answered on 25 Nov 2009

1 answer

141 views

Any work around for word-wrap : break-normal

Hi All,

I am using Mozilla 3.0.15 build,
Still i am facing word wrap problem in report display.
I have read in one of Telerik post word-wrap accept from 3.0 FF version.

Is there any work around solution available with this issue?

Thank you in advanced.

General Discussions

answered on 24 Nov 2009

1 answer

144 views

Handle multiple datasource from code

Hi:

I need to use different a Subreport datasource as the information comes from different tables in my database, but I want to do this using code and not through the wizard.

How can I do to accomplish this, or another option I suggest a package?

Thank you.

General Discussions

answered on 24 Nov 2009