Telerik Forums
Reporting Forum
1 answer
145 views

Hi, 

If I make a nativescript app, can I display a report in the app? or just get a download for a PDF? or another option?

thanks, 

 

Carlitos

Nasko
Telerik team
 answered on 04 Aug 2016
0 answers
242 views

I recently spent a lot of time trying to fix a problem with one of my sites hosted as an App Service on Microsoft Azure. This particular site has an SSL certificate assigned to the production slot and does not have a certificate assigned to the staging slot. It is my practice to publish my sites to a slot I call "staging" and then once they are tested I use the swap feature in Azure to move staging to production. The site I had contains a page with the new HTML5 report viewer. The reports page looks fabulous and runs perfectly in the staging slot (the non https slot) however as soon as it is swapped into the production (https) site the reports page would return a blank screen. Thanks to a lot of help from the support team and from Fiddler we were able to determine a very simple fix.

The report viewer page was referencing the minimized jquery script in the normal way i.e.

<script src="http://code.jquery.com/jquery-1.9.1.min.js"></script>

Once I changed the http to https everything started working

<script src="https://code.jquery.com/jquery-1.9.1.min.js"></script>

I hope this posts saves some time for anyone else that runs into a similar issue. The fix is clearly very simple but running it down was a challenge

Jack
Top achievements
Rank 1
Iron
 asked on 04 Aug 2016
5 answers
544 views

Hi,
I have a main Report, and i call a sub report.
In the main report the Sub report Size is set to 0.1cm. And it can grow.
This Subreport has:

- Label
- Table with rotate layout
 - Label


I try NoDataStyle visible false. But the header are still showing.

I did create a report parameter on the SubReport, using the DataSource of the table i want to hide, With value =Count(Fields.Id).
I did that because i wanted to create a conditional formating to hide the table.
But with this try i have "Missing or invalid parameter Value. please input valid data for all parameters." .

I am trying Every solution i can find for this .

I have no more Idea.

Pierre
Top achievements
Rank 1
 answered on 03 Aug 2016
1 answer
45 views
I have a report (attached screenshot of the designer), I have the page set up to A4 Portrait,  210mm wide, 297mm high, left and right margins at 8mm each. The report is set at a width of 190mm so should fit fine as was working until I made some changes to the table (added 2 columns and set its width to 190mm) at wich points 2 panels I had above the table on the right on the document started being pushed on to a new page showing on the left of that new page. I tired moving them and the rest to the report header leaving the table in the detail, putting the table in a panel and removing the table, but the only thing that worked is moving the two panels so that they were 25mm from the right edge. In the PDF however they show up right against the edge in the same location as they were before they started getting pushed onto a new page.
Mark
Top achievements
Rank 1
 answered on 02 Aug 2016
11 answers
688 views

I created a report that contains a cell as an indicator (conditional formatting --> new rules --> If .... --> Background --< imagedata). When y try to export the report to excel format. The cell is emplty ?!! (it work when i export the report to pdf).

Any solution ?

Regards,

Diego
Top achievements
Rank 1
 answered on 01 Aug 2016
3 answers
2.8K+ views

Having read a number of posts here it does not appear that you can hide columns or rows dynamically.  Is there any plans on add this capability?

I have tried

performSubReportTable.Body.Rows[2] = new TableBodyRow(Telerik.Reporting.Drawing.Unit.Inch(0.001));

but neither the Rows or when I change to columns they do not resize.

I have a report that has a few sub-reports and these sub-reports have tables in them.  Depending on what account is being printed I want to dynamically show and hide specific columns and rows.  As of now it appears my only option is to either create multiple table with each possible combination of rows an columns and then hide and show the appropriate table  or create multiple sub-reports with each possible combination of rows an columns and then dynamically hide and show the proper sub- report.  It would be much nicer if I could create one sub-report with one table and then conditionally hide and show rows and columns, much like how SQL reporting works.

Frank
Top achievements
Rank 1
 answered on 29 Jul 2016
3 answers
207 views

I recently updated the Telerik.ReportViewer control from 9.0.something to 9.2.15.1126.  Since this update I have started noticing that the report-resolver is called multiple times (more than the previous version before) as now our database procedures (that fetch the data for the report) are being hit multiple times - ONLY for the first time a report is run.  Subsequent calls only call the data fetch once as before.

I was already aware that the Resolve method is called multiple times, and to stop it getting the data multiple times, I access the view model and check the ReportObject to ensure it is null before going to get the data - (resetting this to null every time user request to run the report).  So the first line in my resolver is:

If (viewModel.ReportObject == null)

{

  viewModel.ReportObject = FETCHDATA()

}

This would stop the data being fetched multiple times.  However, since updating to the 9.2.15.1126, the resolver seems to be hit twice instantly, the code has not had chance to set the ReportObject before resolver is called again....  What has changed?  And how do I stop this now?  Its putting heavy loads on databases unnecessarily and degrading overall performance of the server.

Could someone shed a light on this situation?

Katia
Telerik team
 answered on 29 Jul 2016
1 answer
1.1K+ views

My ObjectDataSource data is flattened as follows (simplified)

Year 1, Item 1, Attribute String {empty}
Year 2, Item 1, Attribute String {empty}
Year 3, Item 1, Attribute String {Some data I want to express as a detail record}

Year 1, Item 2, Attribute String {Some data to display for this detail record}
Year 2, Item 2, Attribute String {empty}
Year 3, Item 2, Attribute String {Some more data to display for this detail record}

Year 1, Item 3, Attribute String {empty}
Year 2, Item 3, Attribute String {empty}
Year 3, Item 3, Attribute String {empty}

I am grouping the data by item name (Item 1, Item 2, Item 3 in this example) and am displaying the item name in the group header. I would like to suppress group headers for items that do not contain any rows with an attribute string (similar to Item 3 in this example.)

I am able to suppress detail rows with empty attribute strings using conditional formatting Field.[Attribute String] = {blank}, Visibility = false.

However, I have not discovered how to suppress the group header.  Filtering the group header on Field.[Attribute String] <> {blank}, seems to only test the first detail row (returning only Item 2 in this example.)

Can anyone think of a way to suppress the group header for only Item 3 for the example data above?

Thanks in advance for any assistance you can offer.

Stef
Telerik team
 answered on 29 Jul 2016
1 answer
597 views

I have a Telerik Reporting Table in a report.  I am trying to dynamically set the width of first column but it never changes in the report.  Is there some sort of update or refresh method that I need to use?

 

report.calcTable.Body.Columns[0].Width = new Unit(100);

Stef
Telerik team
 answered on 29 Jul 2016
2 answers
111 views

I am now trying to hide hole table dynamicaly but I am having an odd issue

This will not work, none of the table show

var performSubReportTable = performSubReport.Items.Find("table1", true)[0] as Table;
var performSubReportTable2 = performSubReport.Items.Find("table2", true)[0] as Table;
 
if (show1 == 1)
{
    performSubReportTable2.DataSource = performanceDataSet;
    performSubReportTable.Visible = false;
}
else
{
    performSubReportTable.DataSource = performanceDataSet;
    performSubReportTable2.Visible = false;
}

 

This works for the true but the false the none of the table show

var performSubReportTable = new Table();
if (show1 == 1)
{
    performSubReportTable  = performSubReport.Items.Find("table1", true)[0] as Table;
}
else
{
    performSubReportTable = performSubReport.Items.Find("table2", true)[0] as Table;
}
performSubReportTable.DataSource = performanceDataSet;
performSubReportTable.Visible = true;

 

but this does work

var performSubReportTable = performSubReport.Items.Find("table1", true)[0] as Table;
var performSubReportTable2 = performSubReport.Items.Find("table2", true)[0] as Table;
performSubReportTable.DataSource = performanceDataSet;
performSubReportTable2.DataSource = performanceDataSet;
if (show1 == 1)
    performSubReportTable.Visible = false;
else
    performSubReportTable2.Visible = false;

I would prefer if the second method since it is cleaner, but I am not sure why the first two ways wont work. 

Then big difference is the first and the third I set the tables to be visible on the report.  The second method I set the table visibility to false on the report.

Stef
Telerik team
 answered on 29 Jul 2016
Top users last month
Cynthia
Top achievements
Rank 1
Iron
Toby
Top achievements
Rank 3
Iron
Iron
Iron
Danielle
Top achievements
Rank 1
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Iron
yw
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?