Telerik Forums
Reporting Forum
2 answers
1.1K+ views
Hi.  I just started using the reporting tools to replace some XSLT reports.  My datasource is a dataset (read from XML), which contains two datatables.  One table contains just the header info, while the other table contains all the actual data.  If I set the report datasource to just the dataset, then I can only seem to to access the values in the first table (I am probably doing this wrong).  I am just using [=FieldName] in textboxes as a test, I tried specifying the table name like this [=TableName.FieldName] but that did not work.  WHat am I missing here?
Joel
Top achievements
Rank 2
 answered on 05 Aug 2010
11 answers
345 views
The class Telerik.Reporting.Processing.TableCell was removed in the new version of Telerik Reporting !!
Now I don't know how to Access report fields from a Table item.
The example in documentation is :

private void tableTextBox_ItemDataBinding(object sender, EventArgs eventArgs)
{
    //get the textbox from the sender object            
    Processing.TextBox textBox = (Processing.TextBox)sender;
    //get the corresponding tableCell in which the textbox is located
    Processing.TableCell tableCell = (Processing.TableCell)textBox.Parent;
    //get the table object
    Processing.Table table = (Processing.Table)tableCell.Parent;
    //get the detail section
    Processing.DetailSection detail = (Processing.DetailSection)table.Parent;
    //get the raw value from the Report datasource directly
    textBox.Value = detail.DataObject["Data"];
}

But now this is not possible !!!

And now ????

My code don't work more !!!!!

Thank you !
Svetoslav
Telerik team
 answered on 05 Aug 2010
5 answers
314 views
I want to bind htmltextbox value to report parameter. The report parameter value is:

<div style="font-family: tahoma; font-size: 10pt">
    Request from <strong>{Fields.CustomerName} ({Fields.CustomerNo})</strong> to update
    the profile information as follow:
</div>
<div style="font-family: tahoma; font-size: 10pt">
    <strong>P.O. Box</strong> {Fields.POBox}
</div>
<div style="font-family: tahoma; font-size: 10pt">
    <strong>Address</strong> {Fields.Address1}
</div>
<div style="font-family: tahoma; font-size: 10pt">
    <strong>City</strong> {Fields.City}
</div>
<div style="font-family: tahoma; font-size: 10pt">
    <strong>Country</strong> {Fields.Country}
</div>
<div style="font-family: tahoma; font-size: 10pt">
    <strong>Main Contact No</strong> {Fields.ContactNo}
</div>
<div style="font-family: tahoma; font-size: 10pt">
    <strong>Email</strong> {Fields.Email}</div>

When I run the report, I got the error 'Fields.CustomerName' is not a valid type name. Even I tried with double braces but same error. One thing I noticed, If I set this value in htmltextbox expression its working. What could be the reason?
Can someone help me?
Hrisi
Telerik team
 answered on 05 Aug 2010
3 answers
277 views

Hi,

I have a report which contains  bound fields and a table (Telerik.Reporitng.Table) in the detail section of the report. I have used stored procedure which returns dataset with 2 datatables. i.e (Categories and Products). I have bound (in code) the report datasource to "Categories" datatable of the dataset and Telerik.Reporting.Table to "Products" datatable of the dataset. Both datatables “Categories” and “Products” have "CategoryID" column. I have a filter on the Telerik.Reporting.Table to only display products related to particular "CategoryID". Everything works just fantastic. I am able to run and export to pdf thousands of pages without any issue. However if there is no product for some category, in such case Telerik.Reporting.Table doesn't have any records it renders without any issue in report viewer but when I export to pdf it throws "Index out of range" error. Surprisingly export to excel just works fine.

 


Please help.

 


Thanks

Jignesh

Jignesh
Top achievements
Rank 1
 answered on 05 Aug 2010
4 answers
209 views
I am trying to create some charts using Telerik Reporting - Q2 2010

I have a data source that returns 2 columns

Date Value
39812 931
39843 796
39871 855
39902 931
39932 752
39963 827
39993 852
40024 732
40055 677
40085 891
40116 723
40146 610
40177 774
40208 984
40236 1281
40267 2322
40297 2734
40328 2726
40358 2570

In the designer I have no data source for the report, but I have the SQLDatasource connected to the chart.

I have a bar series

I set the Series X to Date, and the Series Y to Value

If I preview the report in the designer the bars are all drawn over each other and it looks a complete mess.

See attached image for what it looks like (capture1.png)

Considering there are in the screen shot (and data above) there are 19 data points along the X axis.

But the # of areas defined by the grid is only 7 - this makes reading the labels along the bottom of the X Axis hard since they do not line up.

Have I missed something here?

Capture2.png is what I actually see after configuring some more properties in the chart. As you will see in that image there is 10 grid columns but 19 data columns. The Bars draw over each other.

I do not want to manually configure the width of the bars as the control should do this for me.

Chris

Chris Crowe
Top achievements
Rank 1
 answered on 04 Aug 2010
1 answer
232 views
Hi there!

On my project I have lots of report files, on which I bind a list of objects. One of the properties from these objects is a boolean field, which gives me as output the text "true" or "false".

I woundn´t like to use expressions, neither itemdatabound event, cause it would lead me to a herculeous work, since I have more than two hundred reports in this project.

Is here a way to set the boolean fields to get their text from a resource (resx) file instead of "true" and "false"?

btw, I´m already using the file Telerik.ReportViewer.WebForms.Resources.pt-BR.resx, but it only translates the interface itens, not the data.

Best regards,

Svetoslav
Telerik team
 answered on 04 Aug 2010
1 answer
385 views
Hi,
I'm running our reports with the Silverlight viewer and the WCF report service.
I'm using an authenticated channel and in the report, I want to be able to access the OperationContext of the service making the call to the report so that I can access the authentication information and know for whom I am executing the report.
However, in the report's constructor, OperationContext is null? How is that possible if the report is called from the reporting WCF service? and is there any way I can obtain the appropriate information and/or hook into the report service before it executes the report?

Thanks

Andrew
Svetoslav
Telerik team
 answered on 04 Aug 2010
4 answers
111 views
I am trying to put together a few reports - and can't seem to get the Telerik reports to work
here's what I did and how far I got

I added Telerik.Reporting and Telerik.ReportViewer,WebForms as reference to my web app
the verision is 4.1.10.714
the site is ASP.NET 4.0 created under Visual Studio 2010 with a SQL Server 2005 database

I had already created a view for my data
I added a New Item Telerik Report Q2 2010 - which Visual Studio wanted to put in the App_Code folder
I left clicked and opened View Designer

the menu item Telerik -> Reporting -> Report Wizard
I built a data source from the view, added a ConnectionString to the web config and hit Execute Query - it had 22 items
selected the fields
the data source control is at the bottom of the report
it shows on the left in Data Explorer
I built the report from the data source with the Report Wizard but Preview and HTML Preview are blank
what happened to the 22 records?
if the report is tied to the data source control and the data source control can locate data why can't the report?

also, to run the report, should I create a new page and add a Report Viewer to it, then create a report and move it into the viewer?
Help!
thanks

Marianne
Elliott
Top achievements
Rank 2
 answered on 04 Aug 2010
1 answer
172 views
I created a report and set up the objectdatasource as a "common type" that we use.  The "common type" has a structure of:

Class OrderSession
Property Name As String
Property ID As Integer
Property Orders As OrderList
End Class

The OrderList class contains a list of orders, with each order containing a list of OrderItems.  When I set the datasource as an order session..the only properties I can get to print in the details section are ID and Name.  Everything else causes a red box to display saying something about not having access to the field.  How would I go about printing properties from the Order and OrderItem in the details section?

I am new to Telerik Reporting but have used Crystal for a long time.  Any help on how to do this would be appreciated.
Peter
Telerik team
 answered on 03 Aug 2010
1 answer
76 views
Hello,
i've created a relerik report, my data only 5 record but it displayed on 2 pages the first one there's only report header, page header and one record as  attached the report image
Peter
Telerik team
 answered on 03 Aug 2010
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?