Hi there

I want to add a combobox into the Reportviewer Toolbar so that i can change the size (A0,A1,A2 ....) from the Report which is displayed.

Until now i have added the following into the Telerik.ReportViewer.Wpf.xaml

<telerikInput:RadComboBox x:Name="PapersizeCb" 
                          ItemsSource="{Binding PaperSizeList}" 
                          SelectedItem="{Binding SelectedPaperSize}">
</telerikInput:RadComboBox>

My Problem is that i don't know how i can modify the Viewmodel of the Reportviewer to bind my Properties.

The version of Telerik I'm using is Q3 2014 SP1.

 Regards

I am using MVC Telerik Reporting. I have added parameter using Report Source, when I see html page it seems parameter are added but when I try to access it on code side in NeedDataSource Event, that time I get Paramter Collection is NULL.

1.) Add this Report Source in Report Viwer

var reportSource = new TypeReportSource() { TypeName = typeof(MBOProReportBook).AssemblyQualifiedName };
reportSource.Parameters.Add(new Telerik.Reporting.Parameter("OrganizationID", SessionHelper.LastSelectedOrganization.OrganizationID));
reportSource.Parameters.Add(new Telerik.Reporting.Parameter("Organization", SessionHelper.LastSelectedOrganization));

2.) Use Following to access parameters but getting NULL in parameter collections

private void IssueReport_NeedDataSource(object sender, EventArgs e)
{
Telerik.Reporting.Processing.Report report = (Telerik.Reporting.Processing.Report)sender;
            Organization organization = (Organization)report.Parameters["Organization"].Value;
           string organizationid = (string)report.Parameters["OrganizationID"].Value;

}

I have this in a text box on the page footer of a very simple 1 page report to count the rows displayed.

RowCount: {Count(Fields.AccountNo)}

Why is it always returning 0, not sure what I am missing. Is there somewhere I can look to see a working example. 

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