Questions on Reporting Forum

16 answers

812 views

Hi,

I am working on telerik reporting, every thing was fine until I receive one new requirement from client. Currently, on clicking "Generate" button, telerik reports viewer showing all data with paging and the new requirement is to give one option on page i.e. "View All", If user click on "View All" button, the viewer should show all data in one page only!!! i.e. without paging. User should be allow to show all report data in one shot without paging.

Is this possible in telerik reporting? if yes please let me know how? I am new in telerik reporting and have to finish this task ASAP.

Thanks,
Vatsal Desai

General Discussions

answered on 12 Mar 2016

3 answers

886 views

CustomReportResolver, where are the parameters?

I've created a customreportresolver in my project (mvc) so that I can make changes to the connection string (and other stuff) on the fly. I'm passing a dictionary<string,object> from my mvc view with the settings for all the report's parameters.

How does that dictionary get to my customreportresolver? I'm not seeing the parameters in my report being updated from the dictionary.

@{

var parameters = new Dictionary<string, object>();

parameters.Add("s1", Model.ReportGeneratorOutput.s1);

parameters.Add("s2", Model.ReportGeneratorOutput.s2);

parameters.Add("g1", Model.ReportGeneratorOutput.g1);

parameters.Add("sourceflag", Model.ReportGeneratorOutput.SourceFlag);

parameters.Add("sid", Model.ReportGeneratorOutput.Sid);

parameters.Add("hdr1", Model.ReportGeneratorOutput.hdr1);

parameters.Add("hdr2", Model.ReportGeneratorOutput.hdr2);

parameters.Add("session", Model.Session);

}

<div id="reportOutput">

@(Html.TelerikReporting().ReportViewer()

.Id("reportViewer")

.ServiceUrl("/api/reports")

.ReportSource("Report.trdx", parameters)

.ViewMode(ViewMode.Interactive)

.PersistSession(false)

.ScaleMode(ScaleMode.FitPage)

)

</div>

public class CustomReportResolver : Telerik.Reporting.Services.Engine.IReportResolver

{

public ReportSource Resolve(string source)

{

var settings = new XmlReaderSettings();

settings.IgnoreWhitespace = true;

using (var xmlreader = XmlReader.Create(Path.Combine(HttpContext.Current.Server.MapPath("~/Reports"), source), settings))

{

var serializer = new Telerik.Reporting.XmlSerialization.ReportXmlSerializer();

var report = (Report)serializer.Deserialize(xmlreader);

//need to set the correct connection string here

//the parameter: session has the year

//var efconnection = ConfigurationManager.ConnectionStrings[$"Connection{report.ReportParameters["session"].Value}"].ConnectionString;

//var connection = new EntityConnectionStringBuilder(efconnection).ProviderConnectionString;

//SetConnectionString(report, connection);

var instancereport = new InstanceReportSource { ReportDocument = report };

return instancereport;

}

General Discussions

answered on 12 Mar 2016

1 answer

1.1K+ views

Formatting multiple values in an expression

I have a single cell that has data the following data:

Weight <unit of measurement> @ speed <unit of measurement>

Example: "40000 lbs @ 65 mph" "18143 kg @ 105 km / h"

Expression example:

=Fields.weight + " " + IIf(uom = "metric", "kg", "lbs") + " @ " ......

I am trying to find a way to do number formatting to add the thousands separator. Is there a way to format one specific field in an expression? I am trying to keep most of the formatting to be as native as possible, instead of user functions, in case the culture changes from "," to ".", etc.

General Discussions

answered on 11 Mar 2016

1 answer

82 views

Acessing database from outside network

Hi , how do we do access our database from outside of the network for Entity data source. I mean when we copy dll path and connection string to

report designer config file it only allows to access the data base if report designer is on the same network , how can we solve the problem so that from any network we can access our data from any network?

Report Designer (standalone)

answered on 11 Mar 2016

3 answers

252 views

Change Loading Animation

Hi,

I'm still on the legacy report viewer and would like to change the loading animation. I want to use a div based css approach that I am already using on the rest of my site with ajax panels.

I have tried to replace the existing content of the wait control with some different html and while that works in code the page itself still shows the original animation with the generating report text.

var waitControl = document.getElementById('uxReportViewer_ReportArea_WaitControl');

waitControl.innerHTML =

'<table style=\"width: 100%; height: 100%;\"><tbody><tr><td style=\"text-align: center; vertical-align: middle;\"><div class=\"loading-outer\"><div class=\"clear-loading-effect loading-animation-1\"><span></span><span></span><span></span></div></div></td></tr></tbody></table>'

;

Any suggestions?

Regards

Jon

General Discussions

answered on 11 Mar 2016

2 answers

119 views

Reporting Error

If I add a Report Viewer to my asp.net web page, non master. upon debugging I get this error

Unhandled exception at line 15, column 16485 in http://localhost/SpecCenter/Telerik.Web.UI.WebResource.axd?_TSM_HiddenField_=RadScriptManager1_TSM&compress=1&_TSM_CombinedScripts_=;;System.Web.Extensions,+Version=4.0.0.0,+Culture=neutral,+PublicKeyToken=31bf3856ad364e35:en-US:6b5ccaa5-a290-46bd-afb1-b6039033842c:ea597d4b:b25378d2;Telerik.Web.UI:en-US:4b258e7c-7002-4d3e-9fa4-709d417eed98:16e4e7cd:f7645509:22a6274a:ed16cbdc:24ee1bba:c128760b:1e771326:88144a7a:8c2d243e:f46195d3:4cacbc31:dc752f02:58366029:4b09f651:ac926cdd:2003d0b8:2bef5fcc:a9b7ace7:6b3f73b3:e330518b:8e6f0d33:864068a5:6a6d718d:52af31a4:74603f77:6d43f6d9:78b9daca:8674cba1:7c926187:b7778d6c:c08e9f8a:59462f1:a51ee93e:19620875:874f8ea2:c172ae1e:9cdfc6e7:c8618e41:e4f8f289:1a73651d:16d8629e;System.Web.Extensions,+Version=4.0.0.0,+Culture=neutral,+PublicKeyToken=31bf3856ad364e35:en-US:6b5ccaa5-a290-46bd-afb1-b6039033842c:76254418

0x800a139e - JavaScript runtime error: Sys.WebForms.PageRequestManagerServerErrorException: Value cannot be null.

Parameter name: key

if I remove the report viewer the page loads and functions as expected.

General Discussions

answered on 10 Mar 2016

1 answer

106 views

Creating a chart/graph in report

Hi,

I am trying to create a chart/graph inside a report control. I have following the below link to create the chart.

http://docs.telerik.com/reporting/buildingprogrammaticcreate

ChartSeries chartSeries = new ChartSeries();

chartSeries.Name = "Sales";

chartSeries.Type = ChartSeriesType.Bar;

chartSeries.AddItem(120, "Internet");

chartSeries.AddItem(140, "Retail");

chartSeries.AddItem(35, "Wholesale");

When i used this code the chart is created, but in x axis it is showing as "1", "2", "3", but i want it to be "Internet" "retail" and "wholesale" (the series name).

Please set me know how to set the label for the series.

Regards,

Deepak

General Discussions

answered on 10 Mar 2016

3 answers

151 views

Connection string for entity data source

How we configure connection string for entity data source approach.

Report Designer (standalone)

answered on 10 Mar 2016

2 answers

713 views

Multiple Detail Section

Hi,

I am trying to add multiple detail section in telerik report, but I am not able to get any option.

Please guide me how to add other section in telerik report.

Please revert me as early as possible.

Thanks

General Discussions

answered on 10 Mar 2016

1 answer

83 views

Adding a referernce to a report

I am creating a report within a dll but when I come to consume my application within the website I am faced with a error of object, I have the reported stored in a class type project and rerfernce it in the application. Also how do i add the filters which I have defined in the designer on the report viewer so the user can select two dates start date and end date in filters?

General Discussions

answered on 09 Mar 2016