I have a crosstab that displays financials over three time periods (year, month, week) this is the first column group. The next  sub column group is actual vs forecast. The aggregate column for this  takes  max(field.value) - min(field.value) to determine the variance between actual and forecast.

I need to figure out either how to conditionally format this field to show whether the variance is favorable or unfavorable (probably with color)



I need to write the expression to subtract



(fields.value Where fields.type = actual) - (fields.value Where fields.type = forecast)



with this the result would be negative if unfavorable.





Basically I need to create case or switch statements for conditional formatting and format string values can this be done either through the expression editor or through the backend C# code behind page.

Hi,
I am new to Telerik Reporting so sorry for this basic question. I've tried to search the forums and could not find an answer.

In our reports we need to show http links to different URL ( as actions, to download a file, etc).

Unfortunatelly, I could only make it work on the HTML preview (by using Textbox.Value = <a href > tag, but then using PDF it's not compatible and show the html tag text directly.

How can I achieve a simple http link in PDF format?
If this is not supported directly is there any workaround?

Hi I'm stucked with a little problem.
I'm working with the telerik report designer, and I'm trying to show a chart on a report I'm designing. I've already did a sample with SSRS and now I would like to get about the same chart with telerik.
I almost got everything to work as I wanted but I still have 2 little problems I can't solve, because I can't find the properties to change on my designer.

the first is that my linechart does not start from the intersection of X and Y axis, and at the end leaves a blank space from the image you can see it in the 2 blue squares
the second is the Xaxis interval, as you can see from the image in the green square, the label are a bit a mess, but i cannot find where I could set this property too.

Can somebody help me?

Thank you very much raphael

Hello, i am trying to setup a simple example of reports on our MVC 4 application but i am having difficulty in referencing my report.

i have setup my view and controller as described in these articles:
http://www.telerik.com/help/reporting/html5-report-viewer-embedding.html
http://www.telerik.com/help/reporting/telerik-reporting-rest-implementing-http-service.html

I do NOT want to use a trdx file to reference my report, i just want to be able to use the Report.cs file as we would have in the past.  None of the documentation talks about using the .cs report files anymore, which is somewhat confusing.

According to this post, we still can use .cs report files.

When i try to view the report, the viewer is displayed but there is just a message saying 'Not Found'.  So what is the correct way to reference a .cs report?

Currently my viewer is setup as:
        $("#reportViewer1")
            .telerik_ReportViewer({
                serviceUrl: "/api/reports/",
                templateUrl: '../Content/ReportViewer/templates/telerikReportViewerTemplate.html',
                reportSource: { report: 'new Telerik.Reporting.TypeReportSource() { TypeName = "Application.Reports.TestReport, Application" }' },
                scale: 1.0
            });

Application is the main assembly.
Reports is the folder where my reports are stored, in the Application project.  
TestReport is the .cs report file.

what am i missing? please n thanks.

Edit: there is also a javascript error when the report is displayed that says:
Failed to load resource:      http://localhost:53661/api/reports/clients/115240-ff1a/parameters
I assume its related to the fact that it cant find the report but thats about all i can figure out from that.

Hi,

I am using Telerik Reports with my Silverlight 4 application and wanted to know if there is a way to change the layout and format of the parameter controls?  For example, I want to change the width of the controls.

Please help.

Same question but for HTML5 Report viewer.   I know the HTML5 report viewer has a template but not sure about the ASP.net report viewer, but in either case, is it possible to customize the layout and format of the parameter controls in one or both of the previous?

Hello,

Last year, our company bought a license for "Reporting Q3 2012". And now, we need to upgrade to "Reporting Q3 2013", is the same license bought last year still working ? if yes, how ?

Thanks

I cannot get any of the following to work for me:

 

• Change Report ConnectionString at Runtime
• DataSource Configuration / ConnectionString
• Change Connection String for Reports Designed in Standalone Designer

 

I have a WPF project that contains several Telerik Report Q3 2013 objects. The reports also have parameters and they preview just fine. During runtime, each report runs a query that fetches data from a SQL Server database and displays the results in the reports.

 

The WPF app has a menubar. At runtime, a user can go to the Reports menu, and choose to preview Report1, Report2, or Report3. There is a WPF window that hosts a report viewer control (called RptViewer). When the code behind a menu option executes, such as the Report3 menu option, the code basically does the following:

 

    private void mnuReports_View_Report3_Click(object sender, RoutedEventArgs e) {

        InstanceReportSource irSrc = new InstanceReportSource();

        RptViewer winRptView = new RptViewer();

        irSrc.ReportDocument = new Report3();

           

        winRptView.rptViewer.ReportSource = irSrc;

        winRptView.Show();

    }

This all works fine and the correct report is previewed every time. My problem is that each report stores a static connection string.

 

I intend for some of my clients to install and use this WPF app within their own network. The reports will need to access the data within their own SQL Server databases. So I need the connection strings to be updated accordingly. We already have the correct connection strings; we just need the string to be assigned to a report whenever it is loaded by the report viewer. I don’t know why I can’t get this to work.

Hello,
I'm trying to get a handle at runtime to the total page count of a generated report but am unable to find a property containing this data. Being able to get it from a saved PDF file would also work for me.  Any tips help would be appreciated.
Thanks

Hello.  I'm using the Q2 2012 version of Telerik Reports and a, generating a report that will display details of transactions on insurance policies grouped by coverage codes.

Ideally, I'd like to use a single report, avoiding a subreport.

Would my version of Telerik reporting allow me to use a dataset with the proper Dataset.Relations added in my BL and put the transactions in the detail section, and their Coverage code one level up in the Group header, I'm thinking something similar to the way RadGrid can generate nested grids with relationships between the MasterTable and DetailTable?

If so, could you point me towards some code samples showing how to set the ObjectDataSource.DataSource = myDataset or what to do in the NeedDataSource events to wire this up correctly?

I expect I can do this with the Table object, but frankly, I've been stymied by how to use that one.

Thanks.