Questions on Reporting Forum

1 answer

158 views

SQL Connection

Hello

I've design some reports in the Report Designer and they're working great, but what I need to do is to change the DB being connected to when I load the report. The idea would be to pass a connect string to the Report Rest Service, as we already pass the filename for the report. Is this possible?

Thanks
Andrew

Report Designer (standalone)

answered on 21 Dec 2016

1 answer

564 views

Report works locally but not when deployed to iis

Hi Team,

I tried to deploy htmlreport viewer to iis and when i browse for 'htmlreportviewer.asp' page.It throws an error 'jQuery undefined'.

Not sure on why the jQuery is not loading eventhough the references are pointed right.Below is my htmlreportviewer asp page

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Telerik HTML5 Report Viewer</title>



<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1" />
<meta http-equiv="X-UA-Compatible" content="IE=edge" />

<script src="../ReportViewer/js/jquery-1.9.1.min.js"></script>
<link href="css/kendo.common.min.css" rel="stylesheet" />
<link href="css/kendo.blueopal.min.css" rel="stylesheet" />
<script src="../ReportViewer/js/kendo.subset.2015.3.930.min.js"></script>
<script src="../ReportViewer/js/telerikReportViewer-10.1.16.615.min.js"></script>

<style>
#reportViewer1 {
position: absolute;
left: 5px;
right: 5px;
top: 5px;
bottom: 5px;
overflow: hidden;
font-family: Verdana, Arial;
}
</style>
</head>
<body>

<div id="reportViewer1">
loading...
</div>

<script type="text/javascript">
jQuery(document).ready(function () {
jQuery("#reportViewer1")
.telerik_ReportViewer({

// 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: "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: '/ReportViewer/templates/telerikReportViewerTemplate',

//ReportSource - report description
reportSource: {
// The report can be set to a report file name (trdx report definition)
// or CLR type name (report class definition).
report: "WealthTrackerReporting.Report1, WealthTrackerReporting",
},

// Specifies whether the viewer is in interactive or print preview mode.
// PRINT_PREVIEW - 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 without paging. Additionally interactivity is enabled.
viewMode: telerikReportViewer.ViewModes.INTERACTIVE,

// Sets the scale mode of the viewer.
// Three modes exist currently:
// FIT_PAGE - The whole report will fit on the page (will zoom in or out), regardless of its width and height.
// FIT_PAGE_WIDTH - 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: telerikReportViewer.ScaleModes.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,

ready: function () {
//this.refreshReport();
},
});
});
</script>

</body>
</html>

Attached the project structure that is on iis. Please suggest.

Thanks,

Navatha.

General Discussions

answered on 21 Dec 2016

5 answers

222 views

Problem with visibility that SubReport

HI,
First, sorry for my english google translator.

My problem is that I'm trying to set the visibility of a subreport this by DataBinding. Except that Telerik is not updating the fields that I'm by setting the visibility, they still visible. I tried other ways, but then when I exchange their visibility to false when returns to be true, the interface fields do not return true.

Here is a piece of my code to see if you can help me.

I'm have a List

C#

I have the list, and I want the subreport becomes invisible when the list is empty.

detail is the name of the group that want to become invisible

private void subReport1_ItemDataBinding_1(object sender, EventArgs e)

{

var table = sender as Telerik.Reporting.Processing.SubReport;

if (table == null) return;

var group = table.DataObject.RawData as CommissionPaymentValue;

if (group == null) return;

var items = group.CommissionPaymentValueItem;

detail.Visible = items.Count > 0;

this.commissionPaymentValueItemReport1.Report.DataSource = items.OrderByDescending(a => a.TypeItem);

}

I know there are threads with the same problems, but still could not solve my.

att Lucas

General Discussions

answered on 20 Dec 2016

2 answers

184 views

How to export Excel file same as CSV format via reportviewer ?

Hi,

I'm wondering if Winform Reportviewer could export Excel file (.xls) which is same format as CSV (column by column) or not. If there is no official way to do, is there any other workaround way ? Please note CSV is not the file I need

General Discussions

answered on 19 Dec 2016

3 answers

519 views

Increase width of parameter area

I have enabled the parameter area in the report (HTML5) and was able to render custom controls, but it is not wide enough. I want to increase the width from 15em to 22em.

I have tried to update the css of the telerikviewer to 22em, but then the report area slides under the parameter area. I haven't found what is calculating the width of the report viewer itself. Is that done in javascript, or described in css.

Can you help me how to increase the width of the parameter area?

General Discussions

answered on 19 Dec 2016

1 answer

73 views

Decorate Properties with Metadata men using Object Datasource

Hello,

Is there any way I can express custom metadata as documentation to the user for object properties?

I'm looking at a way to display more meaningful information in the area marked in red in the attached screenshot.

Best regards,

Magnus

Report Designer (standalone)

answered on 19 Dec 2016

7 answers

380 views

Overlaying shape not displaying correctly

Hi, Im trying to use overlay shape to create the style I wants, please refer to the image below

https://unsee.cc/nomugira/.

(1): is the style I want

(2): is what it is actually displaying

Notice also on the top left corner, it should be a red circle, but for some reason it made the whole 'design box' red, so not just the circle is red but the whole area.

Is there a way around this? or perhaps another way to achieve the same effect?

Thanks

Report Designer (standalone)

answered on 19 Dec 2016

1 answer

693 views

Getting values from multiple scopes

I need to perform a calculation and show the result in the Page Header of my report.

The calculation comes from 3 different data sources: The report-scoped data source, and 2 separate data sources that are being bound to 2 tables in the Report Footer.

I'm able to get the values I need from the report-scoped data source, as follows:

= exec("ReportName", sum(Fields.Amount))

I have not been able to determine how to access the fields from the other 2 data sources. I've tried numerous ways to access the scope, but I always get "invalid scope" error. I've tried:

= exec ("My2ndDataSourceName", sum(Fields.Amount))

= exec ("My2ndTableName", sum(Fields.Amount))

= exec ("ReportName.My2ndTableName", sum(Fields.Amount))

I can't find good examples in the documentation that describe how to access scopes other than the top-level "report" scope.

Thanks

General Discussions

answered on 16 Dec 2016

8 answers

485 views

Is this possible? (vertical text field)

I am building a 1 page report, which requires that I have a few images along the entire length of the right side of the report. It also requires that I display a field vertically along the right side of the report. Please look at attachment for example.
I haven't seen how to do this, or if it is even possible ..
thanks for any help.
-Mike.

General Discussions

answered on 16 Dec 2016

7 answers

248 views

Tooltip on pie chart

Hi all,

am using telerik reporting chart.

please tell me how to do mouse hover option in pie, line charts etc.

previously i used radchart. so i can able to do mouse hover option.

protected void chartPie_ItemDataBound(object sender, ChartItemDataBoundEventArgs e)
        {

                    e.SeriesItem.Name = ((DataRowView)e.DataItem)["lab_name"].ToString();
                    e.SeriesItem.ActiveRegion.Tooltip = ((DataRowView)e.DataItem)["lab_name"].ToString();
                }

But in telerik reporting chart, the event does not contain ChartItemDataBoundEventArgs .so i cant do like as below..

How to do it in telerik reporting chart?

Thanks for any help

General Discussions

answered on 16 Dec 2016