Questions on Reporting Forum

13 answers

2.3K+ views

Can anyone tell me how can I group by a column in a table and make it look like this

Company: Company One
Item	Spend	Unit	Price
Item 1	10	Kg	10.2
Item 3	15	Oz	1.5
Item8	20	grs	50

Company: Comapny Two
Item	Spend	Unit	Price
Item 2	9	Kg	10.2
Item 3	15	Oz	1.5
Item 7	20	grs	50

General Discussions

answered on 27 Feb 2018

1 answer

249 views

Translation of "select all" and "clear all"

I have a multi language report and need to translate the texts "select all" and "clear all" that are shown in the multi select controls on the parameters area.

I can't find where i have to translate them.

I have translated resources.en.js and kendo.culture.en.min.js

Thanl you

General Discussions

answered on 27 Feb 2018

4 answers

478 views

Multiple references to same data set

I have a rather complex report that presents data results from a SQL Server stored procedure in a table then displays charts of the data for each category. The chart is the same data set as the table but with a filter. The table and each chart reference the same data source which in turn references the stored procedure. I discovered that this causes the same rather complex stored procedure to be executed not only for the table but again separately for each chart.

My first thought was to execute this complex stored procedure only on the table while stashing the results into a SQL Server table then have the charts reference only the resultant SQL Server table. However, a temporary table generated within the stored procedure vaporizes at the completion of the procedure. I cannot use a static table as it would cause conflicts between multiple executions of the report from different users. What solutions exist for this situation?

General Discussions

answered on 26 Feb 2018

3 answers

560 views

MUltivalue Parameter

Dear all i've read everything about multivalue articles but nothing works. I got attached error.For your information when i disable multivalue everything works fine.

My datasource is a stored procedure and i tried to pass parameter with item=@item and item in (@item) but i got the attached error. Please Help!!!!!

General Discussions

answered on 26 Feb 2018

8 answers

1.5K+ views

How to specify the name of the export file.

Hello,

I have a problem to specify the name of the export file (For example in PDF), in this moment i work with the winForm (.Net Framework 2.0) and the telerik report version is "TelerikReporting_Q1_2008_SP1_dev_setup.msi".

The problem is, when export a report, the name which shows in the SevaFileDialogg, is the name for report class, and my intention is change name.

dlls - Telerik.Reporting version v2.0.50727.
- Telerik.Reporting.Processing version v2.0.50727.

thank you very much.

Juan.

General Discussions

answered on 26 Feb 2018

1 answer

445 views

How can I hide NULL rows in telerik table ?

How can I hide these yellow filled rows in telerik table ?

Report Designer (standalone)

answered on 26 Feb 2018

0 answers

139 views

Why is there extra empty column on the left in Cross tab ?

Hi all,

I am creating a report and I am using cross tab to show data horizontally. I'm facing a kind of odd situation which is that I am getting an extra blank column on the left side of the Column Field as shown in attached picture. I don't have any empty column in the database but I'm not sure why I am having this. Please of anybody can answer this thread than help me out.

Regards, Asim

General Discussions

asked on 25 Feb 2018

0 answers

616 views

Uncaught ReferenceError: jQuery is not defined

Hi,

I am using Telerik Reporting with my asp.net mvc application, I developed a report in a separate library and browsed it with reportviewer sample successfully. But when I wanted to load the reportviewer page as a part of my _Layout page it didn't displayed, when I browsed to the console I found the bellow error :

Uncaught ReferenceError: jQuery is not defined

at telerikReportViewer.kendo-12.0.18.117.min.js:2

I found that my _Layout page is using a newer jQuery version rather than report viewer. I cannot change the version of jQuery in the _Layout page as every thing is going puzzled, what are the ways to fix this problem?

My _Layout page jQuery version is: jQuery v2.2.4

General Discussions

asked on 25 Feb 2018

1 answer

404 views

How to bind a datatable to a reportviewer in mvc

I have a reporting library project with MVC what I am trying to do is bind the data table to the report viewer and display it my MVC page as I am newbie Telerik what is the best way to display the data table in the viewer by using fields

public DataTable data()

{

DataTable table = new DataTable();

DataRow dr = table.NewRow();

dr["Name"] = "Lion";

dr["Type"] = "Mammal";

table.Rows.Add(dr);

return table;

}

public DataTable Getdata()

{

var d1 = data();

return d1;

}

@(Html.TelerikReporting().ReportViewer()

// Each report viewer must have an id - it will be used by the initialization script

// to find the element and initialize the report viewer.

.Id("reportViewer1")

// The URL of the service which will serve reports.

// The URL corresponds to the name of the controller class (ReportsController).

// For more information on how to configure the service please check http://www.telerik.com/help/reporting/telerik-reporting-rest-conception.html.

.ServiceUrl(Url.Content("/api/reports"))

// The URL for custom report viewer template. The template can be edited -

// new functionalities can be added and unneeded ones can be removed.

// For more information please check http://www.telerik.com/help/reporting/html5-report-viewer-templates.html.

// .TemplateUrl(Url.Content("/ReportViewer/templates/telerikReportViewerTemplate-10.1.16.615.html"))

// Strongly typed ReportSource - TypeReportSource or UriReportSource.

.ReportSource(new TypeReportSource() { TypeName = typeof(ReportLibrary1.Databinding.Report1).AssemblyQualifiedName })

// Specifies whether the viewer is in interactive or print preview mode.

// PrintPreview - Displays the paginated report as if it is printed on paper. Interactivity is not enabled.

// Interactive - Displays the report in its original width and height with no paging. Additionally interactivity is enabled.

.ViewMode(ViewMode.Interactive)

// Sets the scale mode of the viewer.

// Three modes exist currently:

// FitPage - The whole report will fit on the page (will zoom in or out), regardless of its width and height.

// FitPageWidth - The report will be zoomed in or out so that the width of the screen and the width of the report match.

// Specific - Uses the scale to zoom in and out the report.

.ScaleMode(ScaleMode.Specific)

// Zoom in and out the report using the scale

// 1.0 is equal to 100%, i.e. the original size of the report

.Scale(1.0)

// Sets whether the viewer’s client session to be persisted between the page’s refreshes(ex. postback).

// The session is stored in the browser’s sessionStorage and is available for the duration of the page session.

.PersistSession(false)

// Sets the print mode of the viewer.

.PrintMode(PrintMode.AutoSelect)

)

General Discussions

answered on 23 Feb 2018

2 answers

350 views

Obtaining report parameters client side

Hi, I am sure I am missing the obvious but...

Is there a way to obtain the current parameter values from a reportViewer on the client (html) side?

I have a report viewer that works along side a menu that offers several reports that are fundamentally related and all share the same parameters. When the user makes a change (for example the date range), and then chooses one of the other reports, I want to ensure the same date range is pre-selected.

Is this possible? or do I have to supply my own parameter controls and steal the values from that, seems a lot of work in comparison to just having access to a collection of current parameter values, something like ..

var viewer = $("#reportViewer1").data("telerik_ReportViewer");
var currentParams = viewer.reportSource.parameters;

viewer.reportSource( {

report: reportDefinition
, parameters: currentParams
});

Many thanks

General Discussions

answered on 23 Feb 2018