Telerik Forums
Reporting Forum
7 answers
226 views
I'm trying to use the Fields() function in the Groupings property of a report.

It will work if I use a field that is at the base of my object graph. For example:-

=Fields("Price")

However if I try to use a field from deeper in the graph, the generated report is blank. For example:-

=Fields("Supplier.Name")

Both of the above fields work fine as bound fields in the report itself.

Specifying the field directly in the Groupings parameter works as expected:-

=Fields.Supplier.Name

The reason I want to use the Fields function is that I am passing a parameter into the report so I can change the grouping from the page from which the report is run.

Can anyone tell me if the Fields() method should work with deep mapped fields? or was this overlooked when deep object support was added in Q2 2007?

Thanks in advance.
Peter
Telerik team
 answered on 12 Sep 2012
1 answer
117 views
Hi..
Can you provide a sample or direction of how to implement error handing on a report - rendered in the SL viewer.
thx again!
Hrisi
Telerik team
 answered on 12 Sep 2012
1 answer
149 views
Currently we are calling a service that generates our reports and then returns the results and we create a PDF with that:

Dim s as new ServiceName.ReportServiceClient
Dim result as ServiceName.RenderingResults
Dim paramaters as New Dictionary(Of String, Object)

s.Open()
result = s.Render("PDF" "report name here",Nothing,paramaters)

Then we just basically write out the result.DocumentBytes to create our PDF.  This works great for one report but the report needs to contain more than one reportBook.  Basically this report is a combination of reports.  How can I get the "result" that returns into a reportbook so that I can call the render again for the next report so I can add that to the reportbook? or is there a better way?
Hrisi
Telerik team
 answered on 12 Sep 2012
5 answers
573 views
I'm using the web report viewer and for some reason, although the report has multiple pages, the paging controls (next, previous etc) in the report toolbar are disabled. Here's a screenshot to illustrate:

http://i.imgur.com/UeDyw.png 

It should be noted that the data for the report is generated in the aspx codebehind and bound to an ObjectDataSource. Something along the lines of:

var objectDataSource = new Telerik.Reporting.ObjectDataSource();
objectDataSource.DataSource = GetData();
 
var report = new Fuelomat.Reports.ConsumptionPerVehicleGroup();
report.DataSource = objectDataSource;
 
var reportSource = new InstanceReportSource {ReportDocument = report};
 
ReportViewer.ReportSource = reportSource;
ReportViewer.Visible = true;

The reason for this is that the data is combined from a web service and from a SQL database. Additionally, we couldn't use report parameters because the UI has no time picker in addition to the date picker. So we did our own UI in the aspx.

Anyone have any idea why the paging doesn't work?

Cheers,
Rickard
Rickard
Top achievements
Rank 1
 answered on 12 Sep 2012
3 answers
150 views
Hi

I am using a  cross tab  that had data dynamically loaded  from data source and hence its size is dynamic and the detail  section width is not fixed.
I have a heading in the report header page and the text in it is centred but due to the  dynamic nature of the cross tab in the detail section
the report header text  and the detail section is not properly aligned.  how to make the report header textbox width same as the detail section(dynamic)

Thank You

Chavdar
Telerik team
 answered on 11 Sep 2012
1 answer
113 views
Hi.

Is it possible to investigate why a report that looks okay in the viewer has peculiar behavior when exported to the various formats? 

When exporting to pdf, it leaves a lot of blank pages.

When rendering to excel, I get this error message in the viewer:
Attempting to get range {1,64}{30,112},Merged=False,Parent=Tank3TestReport[0], that intersects with an already merged range.

When rendering to rtf, I get this error message in the viewer:
Invalid column index.

My situation is that I am creating a test report of where a surveyor is to inspect data on different tanks and to mark them checked and signed in the written report as he inspects them. 

I have an objectdatasource with a "Tanks" collection exposed as a property. I have bound against the objectmodel (not its "Tanks" property) because I need some other information from the objectmodel for the report header. The result is that the report renders the detail section only once, but this details section contains a list that has its Datasource bound to the "Tanks" property.


Other questions: Should I be considering other options for implementing the report? 
Should I use the Tanks property as the data source and then forward information to the report header through report parameters?
As the details of each tank spans about three pages, should I be using sub reports?
Chavdar
Telerik team
 answered on 11 Sep 2012
3 answers
163 views
Hello Adimn,

I am passing A multi Value  throught parameter to a stored procedure and When a multivalue is passed to a parameter it fails as you have too many arguments when ever i select multi value parameter.
Can you please assit me how to pass a Multi value parameter.


Thanks,
Ravi
Peter
Telerik team
 answered on 11 Sep 2012
3 answers
269 views
Hi all

I have been using telerik report Q1 2012 controls. I created a small report in my class library using telerik report Q1 2012 and and displayed the report in widnows forms application using telerik report viewer. Every thing is fine till now. Now I need to save the report in .trdx format in my system. How to display save button in report viewer and how can I save the report in the format mentioned above

Regards
Rajesh MV

Thomas
Top achievements
Rank 1
 answered on 11 Sep 2012
1 answer
138 views
Hi all,

I'm trying to create a small line in a bar chart.
I've tried to use a marked zone but this creates a line over the whole of the chart.

I only need a line across a small part of the chart.

Attached are screenshot of how i would like it to work and how it looks right now.

ChartMarkedZone mZone = new ChartMarkedZone();
 
mZone.ValueStartY = 90;
mZone.ValueEndY = 90;
mZone.Appearance.Border.Color = Color.Red;
mZone.Appearance.Border.Width = 2;
 
chart_overzichtAantallen.PlotArea.MarkedZones.Add(mZone);
Chavdar
Telerik team
 answered on 10 Sep 2012
2 answers
107 views
Hello,

I am having some issues with the crosstab.  The issue seems to be in the way it is displaying the data.  It is showing one row per record found which is not correct.  First, here is the data I am referencing:

ID,RowIndex,ColIdx,Name,Amount,Category
3482,1,1,Tera,100,Fung
3482,1,2,Rid,200,Fung
3482,1,3,Man,100,Fung
3482,1,4,Vy,1,Inse
3482,1,6,Am,2,Inse
3482,1,8,Mon,55,Inse
3482,2,1,Tera,200,Fung
3482,2,3,Man,50,Fung
3482,2,5,WP,88,Inse
3482,2,9,Fu,66,Inse
3482,3,1,Tera,300,Fung
3482,3,2,Rid,100,Fung
3482,3,3,Man,80,Fung
3482,3,5,WP,5,Inse
3482,3,7,As,4,Inse
3482,3,8,Mon,5,Inse
3482,3,9,Fu,2,Inse
3482,4,4,Vy,45,Inse
3482,4,6,Am,66,Inse
3482,5,4,Vy,78,Inse
3482,5,6,Am,8888,Inse
3482,5,8,Mon,9999999,Inse
3482,5,9,Fu,87,Inse

I am setting up the crosstab as follows:
Row Group is: RowIndex
Detail Values: Sum(Amount)
Column Groups: Name

What am i doing wrong here or how do i need to format my data to have it output correctly.  

I hope I have provided enough information here and if not please let me know.  

Thanks
Aaron
Top achievements
Rank 1
 answered on 10 Sep 2012
Top users last month
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?