Telerik Forums
Reporting Forum
14 answers
440 views
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?
Stef
Telerik team
 answered on 19 May 2015
1 answer
331 views

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

 

 

 

Stef
Telerik team
 answered on 19 May 2015
2 answers
91 views

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

andy
Top achievements
Rank 1
 answered on 18 May 2015
1 answer
297 views

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

 

Nasko
Telerik team
 answered on 18 May 2015
3 answers
120 views
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
Nasko
Telerik team
 answered on 18 May 2015
1 answer
191 views

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

RowIndex("crossTab1") = 1
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

RowNumber("crossTab1") = EXEC("crossTab1", CountDistinct(Fields.Month))

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

Nasko
Telerik team
 answered on 18 May 2015
2 answers
224 views

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. 

 

 

 

 

Stef
Telerik team
 answered on 18 May 2015
2 answers
166 views

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? 

Adit
Top achievements
Rank 1
 answered on 17 May 2015
8 answers
764 views
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
luisv21
Top achievements
Rank 1
 answered on 15 May 2015
1 answer
85 views

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).

Nasko
Telerik team
 answered on 15 May 2015
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?