Hi,

I am trying to do some simple math for a report and it works fine in vs2012 and in the Telerik Reporting SQLDataSource when I execute the query.

However I cannot access the results because the Data Explores gives me the following error.

System.Data.SqlClient.SqlException (0x80131904): Operand data type nvarchar is invalid for subtract operator.

Here is the code:

SELECT
  CASE
    WHEN (@RowsTotal IS NULL OR
      @RowsTotal = 0) THEN 0
    ELSE ((@Rows1 + @Rows2 + @Rows4) * 1.0/ (@RowsTotal - @Rows8)) * 1.0
  END AS 'Permanency Discharges %'
, CASE
    WHEN (@RowsTotal IS NULL OR
      @RowsTotal = 0) THEN 0
    ELSE ((@Rows6 + @Rows7) *1.0 / (@RowsTotal) *1.0)
  END AS 'Insufficient Resources %'

All of the variables are initiated as a float in SQL but as a double in Telerik Reporting.

The values of the variables are:

@Rows1 = 5

@Rows2 = 11

@Rows4 = 12

@Rows6 = 2

@Rows7 = 7

@Rows8 = 2

@RowsTotal = 47

If I replace the variables in the SQL with their values it works in Telerik Reporting.

Any help is greatly appreciated.

Andy

How do I programmatically set the datasource for a graph? I've created the NeedDataSource event handler and it gets called but I cannot work out how to cast the sender in order to set the datasource:

void graph1_NeedDataSource(object sender, EventArgs e)
{
                (sender as Telerik.Reporting.Processing.?).DataSource = GetGraphData();

} 

I've tried casting to a Telerik.Reporting.Processing.Chart and a Telerik.Reporting.Processing.DataItem both of which do not work. The object appears to be a Telerik.Reporting.Processing.Graph but that is not accessible.

 

TIA

Nic

 

I have created a Pie Chart in Report Designer, which has come out as expected. But when I try to preview the chart it doesn't get past the 'generating report' load

Hi, 
I need to use a special expression in the last group in a table. The first row I can detect by using

I want to use the same logic to detect the last group, but I can't find any indications of number of groups in the table or number of rows in a group (other than using COUNT aggregate).
I have now found a way to solve it by using

However I feel that it is ineffective to count all rows in all groups. Is there a better way to accomplish this?

 

Best regards,

Anders

I have been working on this for a while and it simply doesn't work.  I set my reportSource as follows (as specified in the TR-Q1 2015 documentation):

self.loadViewer = function () {
$('#reportWrapper').telerik_ReportViewer({
    reportSource: self.reportSource(),
    serviceUrl: self.reportSettings.serviceUrl,
    templateUrl: self.reportSettings.templateUrl,
    viewMode: self.reportSettings.viewMode,
    scaleMode: self.reportSettings.scaleMode,
    scale: self.reportSettings.scale,
    ready: function () {
        self.reportViewer = this;
    }
});
};

self.refreshReport = function () {
    if (self.reportViewer) {
       self.reportViewer.reportSource(self.reportSource());
       self.reportViewer.refreshReport();
    }
}

self.compositionComplete = function () {
    self.loadViewer();
    self.refreshReport();
};

I have tried to set the reportSource in different ways still I see that the viewer is not passing the correct params but those used while in design.  Can you please provide an example that works for MVVM (I am using Durandal). 

Eduardo. 

 

 

 

 

Report is looking fine into Viewer but when I tried to get export result in any export format it give me a bad result.

1.) This is what I can see in viewer http://snag.gy/l1iiM.jpg (Note is report page is long)

2.) This is what I am getting in export as pdf http://snag.gy/NufMI.jpg

 whole table structure break badly. Can please elaborate what I am doing wrong? 

i have created my class library and got my first report to work. i am using a sqldataadapter and parameters with a stored procedure. when i go to create a second report, i drag the sqladapter onto the report and use the connection that already existed for the first report. i have tried this numerous times, and every time i go to preview the report i get: login failed for user xxxxxx.

i believe i have done everything the exact same way. once i create and configure the dataadapter, i set the datasource. i can see my fields in the data explorer. the only difference i see is that in the first report, there is a sqlselectcommand1 at the bottom with the dataadapter and the connection objects on the reports that work but on the one that does not, that sqlselectcommand object is not present. i don't know if this is the problem, but i cannot get that object on the report.

thanks and let me know if you need any more information.

thanks,
susan

If the Report Name contains German umlauts, it is impossible to export the report as e.g. PDF.

The problem just occurs when using Internet Explorer (I use IE 11).

Report designer: I need to set a table's visibility to TRUE when it has no rows.........the problema I have is that the titles of the table did not appear when it has no rows...please help. Thanks!

Hi, I have a setup a multi-value UI parameter in a report and would like to show the comma seperated value list the user has selected in a textbox in the page header.

just using "=Parameters.myParam" as the textbox expression renders as "System.Collections.ArrayList"

Could you please advise me of the correct expression I should use?

Many thanks