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

With the ASP.Net report viewer, the date picker for a date parameter has no styles, it's just using the ugly default browser fonts.  I tried setting the skin of the reportviewer control, but didn't affect it.  Is this a bug?  Seems like it should look exactly the same as the RadDateInput date picker.
Will this be fixed, or is there anything we can do about it?

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

 

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