Telerik Forums
Reporting Forum
6 answers
367 views
Hi,

We are designed the report using Report Viewer and able configure the report file using Report Viewer of Kendo.UI for ASP.Net MVC application.

Since in Report Designer, the report controls are bind with Data Source object with results. But as per my requirement, we need to bind the data at the run time based on other filter options. I tried to look into the Demo and Documentation of the reporting for this but could not able to get it.

Here is my reportViewer code used to display the report:

    @(Html.TelerikReporting().ReportViewer()
       .Id("reportViewer1")
       .ServiceUrl("/api/reports/")
       .TemplateUrl("/ReportViewer/templates/telerikReportViewerTemplate.html")
               .ReportSource(new UriReportSource() { Uri = "TransactionSummary.trdx" })
       .ViewMode(ViewModes.INTERACTIVE)
       .ScaleMode(ScaleModes.SPECIFIC)
       .Scale(1.0)
       .PersistSession(false)
    )


To the transaction summary report I need to pass the data at the run time.

Can some one please guide us on this as early as possible?

Regards!
Stef
Telerik team
 answered on 27 Aug 2015
1 answer
90 views

I can export reports in IE just fine, but when I try to export in Chrome or Fire Fox I get an error. I have found that I only get the error with reports that use a SqlDataSource​ because when I created a test report that did not get external data it exported ok; but when I added the SqlDataSource and had it pull from SQL Server then it would no longer export. It always displays just fine though... it just won't export unless I (or my clients) use IE.

 

I've also posted this on Stack Overflow: http://stackoverflow.com/questions/31250011/telerik-reporting-cant-export-in-chrome-when-using-sqldatasource.

It has 14 votes so apparently someone else is having this problem... but no answers :(

Nasko
Telerik team
 answered on 26 Aug 2015
7 answers
144 views

I have a Chart on ​a ASP.NET Web Forms report. The customer wants to see datetimes displayed in local time with​ no offset. However, we need the offset to prevent weird chart behaviors during Daylight Savings Time.

One solution would be to have the Value be ​a UTC DateTime field and the ​Text be a local DateTime field. Can I do this with Telerik charts? I do not see a way to set the Value and Text of each data point in the LineSeries.

Nasko
Telerik team
 answered on 25 Aug 2015
5 answers
651 views

I am trying to show a report in HTML5. I have setup the Web API and I am able to successfully call the API with the xxx/formats and xxx/clients URL. However the next calls, which are clients/{clientid}/parameters and clients/{clientid}/instances are failing with a 404 and no additional information in Fiddler (see attached).

I included the Web API into my existing Web API, so the format of the URL is different than what is documented in the tutorials, but that shouldn't matter.

I have also seen that the 404 may indicate that the report file cannot be found. I have the following setup:

In the controller, I have this statement

Dim resolver = New ReportFileResolver(HttpContext.Current.Server.MapPath("~/Reports")).AddFallbackResolver(New ReportTypeResolver())

and I have in the project location a Reports sub folder which contains the file Report1.trdx

In the Web Application, I build the html that has to be added to the page as following. The most noticeable is the ReportSource which is set to Report1 (I have also tried Report1.trdx with the same result)

Can you help me to set this up?

"<div id=\"reportViewer1\" class=\"k-widget\"> " +
                "    loading... " +
                "</div> " +
                "<script type=\"text/javascript\"> " +
                "        $(\"#reportViewer1\") " +
                "            .telerik_ReportViewer({ " +
                "                serviceUrl: \"/api/" +
                                                "token/" + Credentials.getToken(this.mainViewModel.connection) + "/" +
                                                this.mainViewModel.connection + "/" +
                                                "TelerikReports/\", " +
                "                templateUrl: '/ReportViewer/templates/telerikReportViewerTemplate-9.1.15.731.html',  " +
                "                reportSource: {  " +
                "                    report: \"Report1\" " +
                "                } " +
                "            }); " +
                "</script> ";

Stef
Telerik team
 answered on 25 Aug 2015
1 answer
133 views
Hi,

I'm trying to use a custom function in my expression to decide what field should be displayed in the textbox, what grouping should be done, what formatting style should be applied, visibility and how the drilldown functions work.

So far I got here (example of displaying text)
C#
public static string GroupDisplay(int GroupNumber, Telerik.Reporting.ReportParameterCollection parameters, decimal? RecordCenterKey, decimal? RecordUserKey, DateTime? BillDT_DateTime, decimal BillDT) {
            switch (GetGroupingForGroupNumber(GroupNumber)) {
                case ReportGrouping.None:
                    return string.Empty;
                case ReportGrouping.Centers:
                    return CenterName(GetCenterKeyFromParameters(parameters), RecordCenterKey, GetViewSubCentersFromParameters(parameters));
                case ReportGrouping.Users:
                    return CreateUserName(RecordUserKey);
                case ReportGrouping.Date:
                    return CheckDate(GroupDate(BillDT_DateTime, BillDT));
                default:
                    return string.Empty;
            }
        }

My expression:
= GroupDisplay(1, Parameters, Fields.TxTicket_CenterKey, Fields.TxTicket_UserKey_BilledByKey, NULL, Fields.TxTicket_BillDT)

The reason why I am using the Telerik.Reporting.ReportParameterCollection instead of using every parameter separately is because there are 7 default parameters and many optional depending on the report, I want to use the same expression in all 40 so if something changes I can change the expressions in code for all of them in no time.

Am I using a bad approach to solve this or is it something that is not possible in the current release of Telerik Reporting

Kind regards,
Frank
Sven J
Top achievements
Rank 2
 answered on 25 Aug 2015
2 answers
423 views

I have escaped the ampersand but still get this error

the unit.Description is "something something & something something"

I then run the following code;

var unit = HttpUtility.HtmlEncode(unit.Description);

which returns "something something &amp; something something"

this is bound to a field in a HtmlTextBox

Provider: {=Fields.Description.ToUpper()} ({=Fields.Identifier})

which causes (see the attachment)

when I manually remove the ampersand the report renders just fine

I have read other threads on this suggesting to escape it but this is not working. Any ideas?

Telerik Version : Q2 2013 7.1.13.705

 

 

 

 

 

Jono
Top achievements
Rank 1
 answered on 25 Aug 2015
4 answers
110 views
I am trying to learn how to use your data access and reporting modules by creating a very basic project in VS2013 that accesses an oracle database, but i keep coming up with an error.
Here is what i am doing
(just using default names as provided by wizards)
new project -> class library -> add new item -> telerik data access domain model -> select populate from database, backend = oracle -> next -> choose connection -> I have a connection created already from server explorer which works -> name is "connection" -> next -> select the schema i want to use -> select the table i want to use -> next->next->finish -> project gets reloaded -> build solution
add new item -> telerik report q3 2014 wizard -> table wizard -> ok -> add new data source -> select Open Access Data Source -> ok -> choose "connection" as data connection -> choose "ClassLibrary1" and "EntitiesModel1" as object context -> next -> choose IQueryable method that is same name as my table as object context member -> finish -> next -> add my fields (only have 2, one is primary key) -> next -> select normal as style -> next -> finish
report designer is shown -> select preview tab -> get following error
Type is enhanced and registered, but not available from the database class meta data. this can be caused by a wrong connection id or configuration. Parameter name: type Actual value was ClassLibrary1.COURT (COURT is the name of my table)

What am I doing wrong,











Stef
Telerik team
 answered on 24 Aug 2015
1 answer
507 views
Hi:
 We have a MVC project that to load a summary table (e.g a list of ​staff, with its role and location) When each row is click, it ​needs to print out a detail report directly to the local printer​, can I ask it is possible to do this with telerik reporting on a MVC project? (There is no need to view the generated report)

Many thanks

William
Nasko
Telerik team
 answered on 24 Aug 2015
8 answers
859 views
Hi,
I'm really new to Telerik and really love what this thing has done to me so far.

I have a question about Master and SubReport. How can I hide subreport if the subreport do not have the data. Right now the Master and the subreports work well, but if one or two of the sub reports do not have the data from the master report, how do i hide it? because it display an error that should not be seen by the end user....

I really need some help for it in VB because recently i only found them in C#. Thank you.
Stef
Telerik team
 answered on 24 Aug 2015
1 answer
494 views
Can I know how to add column group in telerik report?
Nasko
Telerik team
 answered on 24 Aug 2015
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?