Telerik Forums
Reporting Forum
2 answers
219 views
I have an Image placed in PictureBox control at report footer and assigned it's value, when using export i could fine (visible) in PDF an MS Word but not in Excel Export, tried using relative URL but no luck, any help would be appreciated.

Thanks,
R
Ramesh
Top achievements
Rank 1
 answered on 30 Apr 2014
4 answers
54 views
Silverlight, VS 2010, VB.NET

I would like to add a button or clickable image that will raise an event in my code behind.

In my report I display, for example, a list of clients.  when the user clicks the 'open' button or image I want to launch a user control that displays the client entry screen.

Is this possible?
Stef
Telerik team
 answered on 29 Apr 2014
1 answer
356 views
I feel like I went backward on this one... Anyone using SQL Server Table Valued Parameters (TVP) in a stored procedure and then using the results in a Telerik report? (Nice Code Project TVP and C# discussion in case you're not familiar http://www.codeproject.com/Articles/39161/C-and-Table-Value-Parameters)

For a 'normal' report, you create a report and a datasource and some parameters (single values or multiple values) using the excellent interface and hey presto! everything works out of the box.

Telerik reporting does not support TVP though, so you go back, strip out report's datasource and nice built-in parameter UI you had in there and

1) create a routine to make DataTable(s) from a RadComboBox(es) for the TVP
2) create a routine using SqlConnection, SqlCommand, SqlDataAdapters and the TVP DataTable(s) above to return another DataTable from your stored procedure
3) instantiate your report from your class library and hand it the DataTable above as the record source
4) if you're in ASP.NET, hand the loaded up Report to the ReportViewer.

It's what's going on behind the scenes, I guess, but it feels kludgy.

We have a fairly large library of stored procedures that use TVP and rewriting them all as VIEWs with IN clauses is not really an option. I'm worried about performance and size limitations as the above downloads ALL of the data into the DataTable and ... and does what with it?

Again, the above is working. Anyone else have a technique for working with Reports and TVP?
Nasko
Telerik team
 answered on 29 Apr 2014
2 answers
301 views

When I try to run the report on a specific machine, I am getting the following error message. This program runs locally, and on other servers just fine.

System.ArgumentException: Unable to find the requested .Net Framework Data Provider.

Full Error message and call stack:

Telerik.Reporting.Processing.Data.SqlDataSourceException: Unable to establish a connection to the database. Please, 
verify that your connection string is valid. In case you use a named connection string from the application configuration file, 
make sure the name is correct and the connection string settings are present in the configuration file of your application. ---> 
System.ArgumentException: Unable to find the requested .Net Framework Data Provider.  It may not be installed.
   at System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName)
   at Telerik.Reporting.Processing.Data.SqlProviderFactory.CreateConnection()
   at Telerik.Reporting.Processing.Data.SqlCommandProvider.CreateConnection(String connectionString)
   at Telerik.Reporting.Processing.Data.SqlQueryProvider.CreateConnection()
   --- End of inner exception stack trace ---
   at Telerik.Reporting.Processing.Data.SqlQueryProvider.CreateConnection()
   at Telerik.Reporting.Processing.Data.SqlDataEnumerable.<GetEnumerator>d__0.MoveNext()
   at Telerik.Reporting.Processing.Data.ResultSetAdapter.Fill(ResultSet resultSet, IEnumerable`1 data)
   at Telerik.Reporting.Processing.Data.SimpleDataProvider`1.Execute(MultidimensionalQuery query)
   at Telerik.Reporting.Processing.Report.ResolveData()
   at Telerik.Reporting.Processing.Report.ProcessItemCore()
   at Telerik.Reporting.Processing.Report.ProcessItem()
   at Telerik.Reporting.Processing.ReportItemBase.ProcessElement()
   at Telerik.Reporting.Processing.ProcessingElement.Process(IDataMember dataContext)
Donald
Top achievements
Rank 1
 answered on 28 Apr 2014
6 answers
481 views
Hi,

I create reports using standalone report designer. Reports are run on reportviewer in an asp.net webform. Is there anyway to capture report generation start and end time? Also is there anyway to capture timeout message and customize it?
Stef
Telerik team
 answered on 28 Apr 2014
3 answers
114 views
Hi, 

We are facing issues with the Telerik reporting' print... It was working previously, after newer adobe update: version Adobe Reader XI (11.0.02) nothing happens on the click of the print button. current reporting version installed on the server 5.1.11.713.

Thanks,
Anuj
Stef
Telerik team
 answered on 28 Apr 2014
1 answer
474 views
Hi,

I am creating a report for a membership database that lists all members of the organization, grouped by US state. For each state, each member record is displayed in a row with several columns of data (e.g., first name, last name, address, etc.). One of the columns is called "member type" and has values such as "youth", "adult", and "honorary". What I would like to do in the group footer is display a summary of the count of each member type found in the given US state. The table should look like this:

Member Type            Members
-------------------            -------------
Adult                                105
Youth                                 28
Honorary                             5
......

I created the report and everything looks great except I cannot figure out how to create this summary data in the group footer. Each state's members are grouped and displayed correctly but each state should have its own table at the end of each group section. I have tried a crosstab, creating a subreport but to no avail. Any advice is much appreciated.

Ivan Hristov
Telerik team
 answered on 28 Apr 2014
3 answers
236 views
Hi,

I am trying to convert an application that uses Crystal reports to use Telerik reporting

The issue I have is this... In my Crystal Report I have a cross tab that has months as columns and items as rows so I can see the value for each item month by month. There are also total columns and rows so I can see the total for each month as well as the total for each item. The cross tab is sorted so that the items with the highest total is at the top This is all fine and I have got this working in Terlerik reporting.

However, although this is fine if I want to show all items, what I actually want to show is the Top 5 items and everything else bundled into a 6th Item labelled "Other". I can do this in Crystal by using the "Cross-Tab Top N and Sort Expert", but how do I do this in Telerik?

Many thanks in advance

Regards



Huw
Stef
Telerik team
 answered on 28 Apr 2014
1 answer
184 views
I am trying to use the report viewer widget in my Existing MVC 4 project.  I followed the steps found on this tutorial:
.  http://www.telerik.com/help/reporting/mvc-report-viewer-extension-embedding.html
The difference I change from the guide posted to my own project was to put the styleing in my MVC project css and add the the javascript files with the MVC bundles.  

I am trying to view the reports from the reportviewer widget and am trying to use the follwing view to instantiate the widget

    @(Html.TelerikReporting().ReportViewer()
        .Id("reportViewer1")
        .ServiceUrl("/api/reports/")
        .TemplateUrl("/ReportViewer/templates/telerikReportViewerTemplate.html")
        .ReportSource(report)
        .ViewMode(ViewModes.INTERACTIVE)
        .ScaleMode(ScaleModes.SPECIFIC)
        .Scale(1.0)
        .PersistSession(false)  )
but I am getting     an error in the ReportViewer-8.0.14 file in the throwIfNoReportInstance() function saying the report instance Id is undefined.  I know this is because the report instance is not created, but I am wondering where the report is instantiated at.  Thanks






KS
Top achievements
Rank 1
 answered on 28 Apr 2014
4 answers
136 views
What's the best way of creating a report with a dynamic number of columns?

For an example let's say I need to get the data of a person who has been scored in different subjects and by different scorers.

Subject      Scorer 1 |  Scorer 2 | Scorer 3...
Sub 1              2               3                6
Sub 2              1               4                4
Sub 3              5               3                1
Total                8               10              11
Max score       10            10               12

I do not know at the start how many subjects there will be or how many scorers there will be.  I also need to have each page of the report have a different person's scores on it.

I have tried using a crosstab, but I can't get the crosstab to page break between each person.  Which through some research it doesn't look like it's possible to page break within a crosstab.



Stef
Telerik team
 answered on 28 Apr 2014
Top users last month
Rob
Top achievements
Rank 3
Bronze
Iron
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?