Telerik Forums
Reporting Forum
1 answer
115 views
First, Is this feature finally implemented in the latest release? Second, if this is not available yet does anyone know a hack or workaround to get the desired behavior?

I basically have a report with 5 grouped rows and want the report to break on the 4th grouped row. Currently using a cross-tab.

Thanks.
Hinata
Top achievements
Rank 1
 answered on 21 Oct 2014
2 answers
184 views
We have reports that use two date parameters as a from and to date input into these reports.   When these date inputs appear on the MVC report site, we want to display as a group.  So in other words, we would like to have a common name (for example "Date Range") above the date input parameters with "From" in front of one and "To" in front of the  other.    Would there be a good way to group parameters so that our javascript can easily format the DOM, or is there a way to create a custom control that the Report designer will recognize and hence have a template within the website specific to this custom control that would style the date range as mentioned?  

Attached is a visual example of what we want to achieve. 
Randy
Top achievements
Rank 1
 answered on 17 Oct 2014
1 answer
178 views
Hi  all,
I have a CrossTab (Telerik Reporting V4.0.10.317 - 2011) with two grouping settings on "Fields.ASSET" and "Fields.PRDCT_NM" (product name) columns and a "=SUM(Fields.AMOUNT)" expression relative to the product.Basically, there are 4 types of products (generating 4 rows for every asset) : "p10", "p50", "p90" and "det", each with his subtotal amount.What I need is to access and store for every asset, to the subtotal, and use these 4 values in a logic like this:
when the subtotal for "det" product (for the current asset) is greater than "p90" sub -> use a formula to calculate ,when the subtotal for "det" product is between "p90" and "p50" subs -> use other formula
and so on ... storing the result of that formula in another cell of my crosstabI've found the "Exec(scope, expression)" Expression, but don't know how to implement the "when" logic based on the product nameCan this be done directly with an expression or I need to catch che item data bound event and search for a workaround?
Thanks in advanceMichele
KS
Top achievements
Rank 1
 answered on 17 Oct 2014
1 answer
561 views
Hi,

I need to display a list of images horizontally and once it has reached end of the page size go to the next line and so on...

Image1     Image2     Image3
Image4     Image5     Image6
Image7

Currently I have placed a picture box inside a table cell and have rotated the table layout so the report displays the images horizontally. But it displays all the images in one single line.

Any help in this regard is highly appreciated.

     
Stef
Telerik team
 answered on 17 Oct 2014
1 answer
189 views
I have a question concerning the removal of a page from a reportbook at runtime.

I have a custom reportbook class that is defined as a set of report pages.

public class MyReportBook : ReportBook
{
    public MyReportBook()
    {
        this.Reports.Add(new CoverPage());
        this.Reports.Add(new DetailPage());
        this.Reports.Add(new SummaryPage());
        this.Reports.Add(new MonthlyBreakoutPage());
    }
}


Now, for a subset of my objects, no summary page is required, so I'd like to, based on a condition in the bound data object, programatically delete it from the book. 

I've gotten the desired results by creating another reportbook class and removing the pages that I don't want, but given that the Reports for the 3 of the 4 pages are the exact same and all I want to do is remove a page, is there a way to do this?

Thanks
Stef
Telerik team
 answered on 17 Oct 2014
1 answer
113 views
Is the Graph inferior to the Chart from the older versions of Telerik Reporting?

There is a great deal I cannot do in the Graphs that used to be available in the chart.

1. Please see 1.png
I want to line up the charts nicely and crop  the labels when they get beyond a certain size. Instead the labels keep growing- and shrinking the chart. Adding blank spaces as advised by customer support will not help because the letters all have different spacing and kerning and will not line up nicely due to differences in the label content.


2. Please see http://www.telerik.com/help/reporting/understandingelementsbackground.html
Multicolored zones was actually supported natively in the Chart (which is now obsolete and unusable) by using the MarkedZone property. This is no longer available in the Graph. I need to color certain ranges on the Graph. :(


3. Please see 2.png
I need a custom scale for the x-axis where
a) The origin starts from 100-190
b) And the steps are 30 resulting in 3 discrete zones of different colors (100-130), (130-160) and (160-190) Setting the x-min and x-max and the step size results in the graph seen in the screenshot. Is it possible to have a graph where there is only 3 hash marks and nothing in between.

I only want it to behave like the Chart's ChartAxis.AutoScale as seen on http://www.telerik.com/help/reporting/understandingelementsaxislabels.html 
Again this is no longer supported


4. I am unable to embed labels onto a plot area shared by 5 different series to show the different charts on the same axes. Telerik reports to me this is not possible.

Will really appreciate any heads up! Thank you.




Nasko
Telerik team
 answered on 17 Oct 2014
5 answers
206 views
Hi

After upgrading my reports to the latest version Im having problems selecting my dataset as datasource in the report designer.

When I select DataSource in the property viewer, my old DataSets are not there.
However, when try to show all datasource in my project (using the VS 2010 menu "Data/Show Data Sources") they are all there.
So, why can't I see the datasets in the report designer select datasource windows, when I can see them in the "Data/Show Data Sources" window ?

When I try to add a new datasource to my report, I can only select "SQL DataSource" or "Object DataSource".
Is its still possible to use a DataSet as datasource in the Q1 release?

Regards
Per 
Rafa
Top achievements
Rank 1
 answered on 17 Oct 2014
7 answers
2.0K+ views
I am trying to figure out how to render an excel report into the Office 2007 format but I keep getting errors that the report extension is corrupt.

What do I need to change here:

I have tried setting the filname to xlsx and the reponse content type to application/vnd.openxmlformats-officedocument.spreadsheetml.sheet with no luck.

Dim reportProcessor As New Telerik.Reporting.Processing.ReportProcessor()
Dim result As Telerik.Reporting.Processing.RenderingResult = reportProcessor.RenderReport("XLS", myReport, Nothing)
Dim fileName As String = result.DocumentName + ".xls"
    Response.Clear()
    Response.ContentType = "Application/XLS"
    Response.Cache.SetCacheability(HttpCacheability.Private)
    Response.Expires = -1
    Response.Buffer = False
    Response.AddHeader("Content-Disposition", String.Format("{0};FileName=""{1}""", "attachment", fileName))
    Response.OutputStream.Write(result.DocumentBytes, 0, result.DocumentBytes.Length)
    Response.End()

Stef
Telerik team
 answered on 17 Oct 2014
1 answer
140 views
I've implemented the report viewer in my MVC application and everything works well. I'm wondering if it's possible to store our Telerik reports outside of the web application, on a shared drive for example, so that we can keep the report files created in Report Designer separate from the web application. Is there any way to point that Uri to a mapped network drive maybe?

This is the current code, but I would like to be able to have @Model.ReportSource be a path to an external path.

@(Html.TelerikReporting().ReportViewer()
       .Id("reportViewer1")
       .ServiceUrl("/api/reports/")
       .TemplateUrl("/Content/ReportViewer/templates/telerikReportViewerTemplate-8.1.14.804.html")
       .ReportSource(new UriReportSource() { Uri = @Model.ReportSource })
       .ViewMode(ViewModes.INTERACTIVE)
       .ScaleMode(ScaleModes.SPECIFIC)
       .Scale(1.0)
       .PersistSession(false)
)
Jan
Top achievements
Rank 1
 answered on 15 Oct 2014
1 answer
838 views
Hi Guys,

I'm new to reporting and there is a requirement to display an image in my report and I'm using a picture box for this. 

Problem I have is I want to display this image only when it is available. From my dataset I'm returning the image path(this will always return a path if image is present or not) and a boolean value indicating if the image is present. 

So I tried adding an conditional formatting rule to picture box defining layout should not be visible when the Field.ImageAvailable property is false. But when I render the report, it displays image not found error.

So have I missed anything or is there any other way to handle this?

Thanks in advance!!
Hinata
Top achievements
Rank 1
 answered on 15 Oct 2014
Top users last month
Rob
Top achievements
Rank 3
Bronze
Iron
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?