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

Hi guys,

 

Just wondering if there is a way to use a different table prefix to the standard tr_xxx when using your implementation of IStorage as the caching mechanism for reports?

 

Cheers.

Hello together.

There are two possibilities to accomplish ordering, sorting, filtering and grouping of data when using Telerik Reporting.

First approach is very obvious because probably you have to / had to work like this anyway: Use WHERE, ORDER BY, GROUP BY directly in SQL clause but it's some kind of "hidden".
Second approach is the ".NET way" which means that you apply those conditions on a "data adapter class" like you can do it in the report designer for example which is very handy since you don't need to code anything manually but have handy GUIs and can see it instantly in the designer's view.

Now my question: Which one is better / faster and (dis-) advantages over the other?
Are those "programmatically applied" conditions configured through the GUI evaluated by the application code after the original sql query is executed code or are they "translated" to native sql commands and applied before exuting the query?

First one would have noticeable impact on performance I guess whilest the second one is very handy as described above and you can see on the "top level" and don't have to search for anything "back" in the sql commands.

Thanks and regards!

Hello,

I have added a pie-chart to my report.  For each "pie-slice", I have added a label that appears just outside the slice. 
I am facing problem  for "connecting-line" from the pie-slice to its label.  The connecting-line overlaps the labels?

I have used following code snippet to place the labels and connecting-line properly in Pie-chart.

 

chart.AutoLayout = true;
chart.IntelligentLabelsEnabled = true;

chartSeries3.Appearance.ShowLabels = true;

chartSeries3.Appearance.ShowLabelConnectors = true;

chartSeries3.Appearance.LabelAppearance.Visible = true;

chartSeries3.Appearance.LabelAppearance.Distance = 10;
chartSeries3.Appearance.StartAngle = 30;
chartSeries3.Appearance.ShowLabelConnectors = true;

 

But Still i am facing the issue of connect line overlapping labels.