Questions on Reporting Forum

1 answer

98 views

Hi how ca i make the graph logarithmic , i attacment the example , help me please i don know how to change the vertical gridline, can you help me ?

General Discussions

answered on 12 Mar 2016

4 answers

386 views

[Solved] How to publish .trdx(Report Designer report) in report server

Hi All,

I have created a report in Report Designer (Standalone) whose neme is test.trdx.Which is working fine.

Now i have installed report server to publish test.trdx report in report server.

So i have uploaded test.trdx report file in report server.But when i click on test.trdx in report server then it shows error.

"Unable to get report parameters.
An error has occurred.
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".

Thanks,

Narender

Report Designer (standalone)

answered on 12 Mar 2016

16 answers

915 views

[Solved] Show all report data without paging

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

980 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.2K+ 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

116 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

282 views

[Solved] 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

169 views

[Solved] 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

149 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