We are in the process of adapting our Winform application into a MVC Web Application and we have Telerik Reports that we use to generate Invoices and Statements which we attach to emails.

Ideally we would call a stored procedure while passing an Id, from there we would call the sp_send_dbmail stored procedure and pass it the file attachments and other data gathered using the Id which would make our sp call look like this:

    EXEC msdb..sp_send_DBMail
    @profile_name ='Profile'
    ,@subject = @Subject
    ,@body = @Body
    ,@recipients= @Recipients
    ,@body_format = 'HTML'
    ,@reply_to = @ReplyTo
    ,@file_attachments = 'C:\Report\Invoice 123'

I have a Report based on a database table. I have interger fields in the table (0 for false and -1 for true). These fields should be represented in report as checkboxes.
How can I bind the columns for checkbox state (checked/unchecked).

I am using following expression for the Value property of the checkbox, but the checkstate is not changing.
= IIf(Fields.col1< 0, True, False).

Or.......should I put this in the properties: "Truevalue" or "FalseValue"=

What am I missing?

 Thanks!

J. David

Hi

I'm stuck.

Here are my steps:

1 Open Report Designer

2. New Report; Pick tabular

3. Choose a datasource > Add New Data Source... Pick Open Access Data Source... OK

4. Choose data connection> (I add a new sql connection and test that I can connect)

5. I save the connection

6. Choose an Object Connection.

The context is empty

The message says ' make sure your current project is built for the types to show up in the list'.

How do I "build the project" from Report Designer, or from within the wizard?  

Thanks

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

Hi, 
I need to use a special expression in the last group in a table. The first row I can detect 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?