Telerik Forums
Reporting Forum
7 answers
1.0K+ views

I would like to run reports designed by the standalone designer from my application.
So far I have managed to load the report definition (.trdx file) and run it in the app.

What's the best way to specify the connection string dynamically from the application?
I did not find a pointer in the docs.
Changing the ConnectionString attribute on the SqlDataSource Node in the XML Document in memory would probably be an option, but is there a direct Telerik API for that?

I am confused a bit with the different options to set the Windows Forms Report Viewer ReportSource property:

If I use XmlReportSource to load a trdx file, I apparently do not get all the functionality of the Report object (DataSource, ReportParameters),

However, the following code seems to work:

// ReportDefinitionFile is the path to my .trdx file
 
var xmlSerializer = new ReportXmlSerializer();
var reportDocument = (Report)xmlSerializer.Deserialize(ReportDefinitionFile);
  
var reportSource = new InstanceReportSource();
reportSource.ReportDocument = reportDocument;
  
SqlConnectionStringBuilder scsb = new SqlConnectionStringBuilder();

.... // initialize connection string
 
 
SqlDataSource sds = (SqlDataSource)reportDocument.DataSource;
sds.ConnectionString = scsb.ConnectionString;
 
this.reportViewer1.ReportSource = reportSource;
this.reportViewer1.RefreshReport();



Regards
Erwin
Myth
Top achievements
Rank 1
 answered on 22 May 2013
3 answers
427 views
Hi there

I have report that has a frame background image, when I export the report to a PDF it works 100%, but it doesn't display correctly in the ReportViewer. I understand that this has something to do with it rendering as HTML?

Is there a way to either set the ReportViewer "view" as PDF? I just need the reportviewer to display it the same a PDF would look.

I would like to keep it in the ReportViewer as a client can first view/confirm before exporting to PDF.

Thank you.
IvanY
Telerik team
 answered on 22 May 2013
1 answer
122 views
After upgrading to Telerik reporting Q3 2012 we have lost all  formatting in our htmltextbox.
Any clue why?
Peter
Telerik team
 answered on 22 May 2013
1 answer
483 views
Hello,

I'm currently binding a picturebox to a database field in my report. If null is returned from the database, I would like to display a default "photo not available" picture. I tried to accomplish this by setting the picturebox value to the desired default image, and setting the picturebox binding to the database field - that didn't work. I also tried to do some conditional formatting based on if the Fields.Picture was null, and set the background to the default image - that didn't work.

Any ideas? 
Squall
Top achievements
Rank 1
 answered on 22 May 2013
1 answer
132 views
Hi there,

We are in the process of planning for the upgrading all our telerik tools (including reporting) from our current versions which are about 3 years old to the latest versions and would like some advice on the best way of doing so.

We currently use Telerik asp.net for AJAX, Telerik winforms and Telerik reporting tools for our inhouse system and are thinking of starting the upgrade with reporting tools first.

We will be trying to do this sequentially and concurrently, also take the opportunity to upgrade visual studios from 2008 sp1 to 2012.

As we are thinking of upgrading the telerik reporting api first, we would like to know whether the best way is upgrade incrementally by versions ( time consuming since our current version is v4.1.10.714) or just download the latest telerik version. The reports are used by both the webapplications and winforms app and are stored in its own report project.

Please advise?

Regards

Jonathan
Peter
Telerik team
 answered on 22 May 2013
5 answers
570 views
Hi Team

We are rendering pie chart with numerous slices which are dynamically generated based on the responses for the particular question, while we doing this pie slice's labels are overlapping. Kindly please provide the solution.

I have attached the expected format (Expected_Pie_Chart_Labels.png) as well as over lapped one(pie-slices-label-value-overlap.png).

We tried the suggestion which is mentioned on this link -

http://www.telerik.com/community/forums/reporting/telerik-reporting/pie-chart---connect-labels.aspx


When we applied IntelligentLabelsEnabled = true Its skipped few slice's labels which are causes overlapping. Please refer the attached image - piechart-no-overlap-but-label-value-skipped.png, there one of pie slice's response lablel was skipped.

Apart from this, we played around with decreasing the font size, increasing plot area, margin, label appearance property as well, but no use. 

One more issue we encountered here is, when we have 2 slices response's percentages are same, then only one leader line is rendering instead of two, this also causes over lapping even though we have enough space and less slices in pie. 

code snippet:

Telerik.Reporting.Processing.Chart chart = (Telerik.Reporting.Processing.Chart)groupHeaderSection.ChildElements.Find("chtItemPie", true)[0];
         Telerik.Reporting.Chart chartDef = (Telerik.Reporting.Chart)chart.ItemDefinition;
         chartDef.AutoLayout = true;
         chartDef.IntelligentLabelsEnabled = true;
         Telerik.Reporting.Charting.ChartSeries chartSeries = new Telerik.Reporting.Charting.ChartSeries();
         chartDef.Series.Clear();
         chartSeries.Type = Telerik.Reporting.Charting.ChartSeriesType.Pie;
         chartSeries.Appearance.LegendDisplayMode = Telerik.Reporting.Charting.ChartSeriesLegendDisplayMode.ItemLabels;
         chartDef.Legend.TextBlock.Visible = true;
         chartSeries.Appearance.ShowLabelConnectors = true;
         chartSeries.Appearance.StartAngle = 270;
         chartSeries.Appearance.ExplodePercent = 8;
         chartSeries.Appearance.LabelAppearance.Distance = 30;
         chartSeries.Appearance.DiameterScale = 0.85;
         chartSeries.Appearance.Border.Width = 2;
         chartSeries.Appearance.Border.PenStyle = System.Drawing.Drawing2D.DashStyle.Solid;

Version Detail: Telerik Reporting Q2 2012

Thanks
Sankar
Stef
Telerik team
 answered on 22 May 2013
1 answer
338 views
Hi,
I have developed number of projects in Visual Studio 2010 using Telerik Reports  v. 6.2.12.1017 (Q3 2012)

Now I'm using Visual Studio 2012, and want to install the latest version of Telerik Reporting v. 7.0. 13.426 (Apr 26, 2013)

I want to keep the old version for Visual Studio 2010, Because I have tried it before, as in the latest version of Telerik reporting they have obsolete some features from old versions which I have used in most of my Reports. and those projects with old version of Telerik reporting doesn't work with the latest version.
some of then are as bellow

Actually When I try to Install it from Telerik Control Panel, it gives the following warning

* All previous versions installed on the machine will be removed.
"Snapshot is attached"

Is there any way, so my Old Projects should use the old version of Telerik Reporting and New Projects should use the latest one...???

Thanks.
Peter
Telerik team
 answered on 21 May 2013
1 answer
195 views
Hi there,

I have an existing view with an view model as the data context, I am adding a report (Telerik Reporting 2013Q1) to the page, I use one of the public properties of the viewmodel as the data source (it's a list of object), but the report is empty seems like there is no data, here is some code:

1. the view
<tr:ReportViewer Name="ReportViewerStrats" ReportSource="{Binding DataContext.ReportSource, ElementName=StratsView}"/>

2. the property view model
private List<MyItem> _myItems;
public List<MyItem> MyItems
{
    get { return _myItems; }
    set
    {
        _myItems = value;                
        base.OnPropertyChanged("MyItems");
    }
}

3. the initialize in view mode:
MyItems = GetItems();   //Get from database
ReportSource = new MyReport();


And finally the report is attached. In debug mode, I check the view model (MyItems) does have data.

thanks.

--ricky
Peter
Telerik team
 answered on 21 May 2013
1 answer
108 views
Is there an option for a slider or something within the reportviewer that shows all the pages but at thumbnails, that once clicked it will jump to that page? In another control we were using it had this option, so I wanted to know if Telerik's reporting tool has this as well or at least a way to emulate it with some other control. Like using a ListBox or something
Stef
Telerik team
 answered on 21 May 2013
1 answer
116 views
Hello,

My company just purchased a bunch of Telerik controls. We noticed there was a reporting control so we wanted to take a look at it. Currently we are using Active Reports for all our reports. I was asked to look into what the Telerik Reporting could do for us. I wanted to create a simple report with a few text boxes and a subreport to show data. I am having a hard time though getting data to show in a sub report. I have to set all the report data in a usercontrol file. Since the report would be dynamically filled, I have to reference each control and set the data source to whatever I need. I call my PrepareReport() function to load the data into the report and then stream it. I am able to access my textboxes and set their values and those show fine.The datset below returns 4 records but nothing shows in the subreport when I run it. What am I missing? Any help would be greatly appreciated. I have searched through this forum and google and can't seem to find a solution for what I want to do. Thanks!
private void PrepareReport(Telerik.Reporting.Report rpt)
{
    Telerik.Reporting.DetailSection detail = (Telerik.Reporting.DetailSection)rpt.Items["detail"];
 
    Telerik.Reporting.TextBox txt = (Telerik.Reporting.TextBox)detail.Items["txtDNIdValue"];
    txt.Value = "11111";
 
    Telerik.Reporting.SubReport subRpt = (Telerik.Reporting.SubReport)detail.Items["subReport1"];
 
    DataSet ds = new DataSet();
    ds = FunctionToFillDataSet();
 
    subRpt.Report.DataSource = ds;
}

Zack

 

 

 

Zack
Top achievements
Rank 1
 answered on 20 May 2013
Top users last month
Simon
Top achievements
Rank 2
Iron
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Grant
Top achievements
Rank 3
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?