Telerik Forums
Reporting Forum
2 answers
181 views
Hello

I have a report connecting to mysql using a sqldataadapter.
When the report is generated it creates 8 pages all of the same report.
Any suggestions?

Thanks
JedF
Top achievements
Rank 1
 answered on 24 Nov 2011
7 answers
670 views
Hi,

I have a SQL view where one row of data is for Header section of the report and the remaining rows of data are for Details section of a report. 

I have a field "RowType" in the view with values: 
  - "HeaderData" for row of data that goes to Header section (the view has only one such row).
  - "DetailsData" for all other rows of data, which goes to Details section.

I tried adding filter to Details Group, but observed that this filters the whole report.
Also, I did not find any way to add filter to the Header Group.

My queries are:
1. On the Header section, how do I display only the data from the row containing "HeaderData" on "RowType" field? 
2. On the Details section, how do I display remaining data (with "DetailsData" on "RowType" field)  ?

Thanks in advance.
Sumit
Sumit
Top achievements
Rank 1
 answered on 24 Nov 2011
2 answers
113 views
Over the past weeks I have updated my Telerik controls in Visual Studio 2010 ASP.NET.  My project contains both ASP.NET AJAX and Telerik Reporting.  The ASP.NET AJAX is version 2011.3.1115.40 and the Telerik reporting is version 5.3.11.1116. 

Since starting the telerik control updates, the ReportViewer control -- in design view and when it displays the report -- is strectched to the right, and the ReportViewer controls are moved around in the ReportViewer. 

I've attached an image of the ReportViewer in the Visual Studio design view, and another image of the ReportViewer when it diplays a report.

Thanks for any help.
Robert Adkison
Top achievements
Rank 1
 answered on 23 Nov 2011
1 answer
156 views
Hello Telerik,
I've currently developed a report that uses EF to retrieve the data (in the true DevForce's IdeaBlade), I've the main report then a subreport where I've attached my 1...N items and the data are shown correctly...
Now I need to show in the subreport a property that's not defined in the data below... how can I access to the data via expression editor?

Consider this

MainObject

ID
Description
Country
IEnumerable<ChildObject> xxx

I need in the subreport that's bound to item of type ChildObject to access to Country property

Using QuickWatch I've seen that the item I'm looking for can be accessed with

var dataContext = ((IdeaBlade.EntityModel.EntityReferenceBase)(((IdeaBlade.EntityModel.RelatedEntityList<MainObject>

Can someone help me out?
Thanks
Peter
Telerik team
 answered on 23 Nov 2011
4 answers
1.9K+ views
Hi, I am trying to load an image from external URL, following is my code

Private Sub detail_ItemDataBound(ByVal sender As System.ObjectByVal e As System.EventArgs) Handles detail.ItemDataBound  
        Dim detail As Telerik.Reporting.Processing.DetailSection = DirectCast(sender, Telerik.Reporting.Processing.DetailSection)  
        Dim section As Processing.DetailSection = TryCast(sender, Processing.DetailSection)  
        Dim row As DataRowView = DirectCast(section.DataItem, DataRowView)  
        Dim aPicBox = DirectCast(detail.ChildElements("pnlDetails").ChildElements("pnlPic").ChildElements("picProperty"), Processing.PictureBox)  
        Dim oWebRequest As WebRequest  
        oWebRequest = WebRequest.Create("http://www.geekologie.com/2007/12/07/future-car-1.jpg")  
        aPicBox.Image = System.Drawing.Image.FromStream(oWebRequest.GetResponse.GetResponseStream())  
    End Sub 

and I get

An error has occured while processing PictureBox 'picProperty':
Access to the path xxxxxxxxx' is denied.

any suggestions?
Steve
Telerik team
 answered on 23 Nov 2011
1 answer
181 views
Hello,

We have a Web Report Viewer that spans the width of the whole page.
However the report that is displayed in it, is align left by default, and we would like it to be centered.
How do we achieve this behavior?

See screenshot

Thanks!
Squall
Top achievements
Rank 1
 answered on 23 Nov 2011
1 answer
70 views
Hi,
Referring to the URL below, I try to apply style using htmltextbox design view. However, the style is missing after I change to HTML view and back to design view.
URL: http://www.ximnet.com.my/upload/telerik_reporting_htmltextbox.swf

Am I missing something?

Thanks.
Peter
Telerik team
 answered on 23 Nov 2011
5 answers
564 views
Hello,

  I have a table with several rows.  Some of them are spanned.

  Each of row has constant height in 8 points:
  var tableRow = new TableBodyRow(Unit.Point(8));

  Each of cell contains a TextBox with following style:
  var textBox = new TextBox
   {
           Docking = DockingStyle.Fill,
           CanGrow = false,
           CanShrink = true,
           TextWrap = false,
 };

But after exporting to Pdf some of columns are higher that 8 points (see picture).

How to fix the row height for a table?

P.S. The similar problem is described here: "http://www.telerik.com/community/forums/reporting/telerik-reporting/how-to-equal-cell-s-height.aspx"

Thanks,
-Andrey Popov
Andrey
Top achievements
Rank 2
 answered on 23 Nov 2011
4 answers
320 views
Can I use user-defined functions defined in an assembly different from the assembly where the report is located?

What about reports exported as XML? Can I call use user-defined functions in this kind of reports considering that they are not located in an assembly?
Sergey
Top achievements
Rank 1
 answered on 23 Nov 2011
11 answers
423 views
I am trying to create a simple mailing label report. I have gone through the wizard, selected a SQLDataSource, selected a procedure, added the 5 parameters and when I hit the Execute Query button I get a row count of 190 (which is correct) but no data is displayed in the wizard. When I continue on to the report, when I click on 'fields' in the expression builder, it tells me there is no datasource. When I look at the properties of the report, the datasource is filled in with the one I selected in the wizard.
Steve
Telerik team
 answered on 23 Nov 2011
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?