Telerik Forums
Reporting Forum
1 answer
243 views
Hi,

I would like to remove Arrow buttons (Left and Right) from Report Viewer Naviagtion tool Bar.
How can I remove those?

Thanks,
Asit
Chavdar
Telerik team
 answered on 12 Sep 2012
2 answers
145 views
Hello,

I have a table pulling data from a stored procedure, but due to the way the database was set up, some of the strings were cut off. I cannot change the structure of the database, so I was wondering if it was possible to add the part of the string cut off in the [=Fields.whatever] part of the cell.

Here's a simplified example of what I mean....

The table was created like this:
CREATE TABLE ThingColor(
id int PRIMARY KEY,
thing varchar(20),
color varchar(5))

And data inserted:
INSERT INTO ThingColor
VALUES (1, 'sky', 'blue'), (2, 'sun', 'yello');

My stored procedure calls 'thing' and 'color', but the "yello" is missing its w. When I get to the Telerik Report table, is there something similar to an if statement function where, if the string = 'yello', then display 'yellow', that I can add to my [=Fields.color] box?
Matthew
Top achievements
Rank 1
 answered on 12 Sep 2012
0 answers
70 views
I have a telerik report service (Telerik.Reporting.Service.ReportService) that is used by silverlight application. I want also use the same service for iPad version of the application.
The way we are going to implement:
Create a proxy service, that will send requests to ReportService. This proxy service will have 2 methods: RenderAndCache, GetPage. I want to get a page with html format and then just return it to iPad client. But the markup that we got from ReportService has a strange links for images.

Example:
<img alt="Chart" src="&amp;StreamID=3nxve03monw" width="718px" height="600px" /></td>

I want to get the following link
[ApplicationRoot]/ReportService.svc/resources/getrenderstream?instanceID=smth&name=3nxve03monw".

I understand that it's possible just to replace it manually. But I'm interested if there is a way of getting such kind of links from the box.

Alex
Top achievements
Rank 1
 asked on 12 Sep 2012
7 answers
248 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
137 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
161 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
608 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
163 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
120 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
169 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
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
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?