Telerik Forums
Reporting Forum
1 answer
108 views
The release notes say commands and events are exposed on the html5 viewer, where can I find some documentation on those?   I'm not seeing anything about events in the documentation?
Stef
Telerik team
 answered on 20 Aug 2014
1 answer
162 views
 
I generate an Excel file using Telerik reporting Q2 and I want to have a single cell with colored text, e.g., one part of the text to be green, the other blue. Is this possible to be accomplished?

 

Nasko
Telerik team
 answered on 20 Aug 2014
2 answers
529 views
Hi, I am new to Telerik and am wondering where the best resources for using the Standalone Report Designer with .trdx files are.

The information at http://www.telerik.com/help/reporting/standalone-report-designer.html shows very different screenshots than what I see, and http://www.telerik.com/help/reporting/quick-start-create-simple-report.html is helpful but only as a brief introduction to setting up a connection.

I have attached a screenshot of what I see in the Report Designer. I am particularly interested in any information on the controls found under the Insert tab.


Thank you for your time,

Ian
Ian
Top achievements
Rank 1
 answered on 19 Aug 2014
3 answers
367 views
I want to only show data that appears between the first and last days of last month, how might I do this?

My attempt (not working) is to use "between" logic and the C# methods AddMonths() and AddDays() in an "IIf" expression, showing another field if true and otherwise showing nothing if false:
= IIf(Fields.[Date Last Updated] Between Now().AddMonths(-1) And Now().AddDays(-1), Fields.[The Field I Want to Show], )
Ian
Top achievements
Rank 1
 answered on 19 Aug 2014
2 answers
179 views
Is it possible to dynamically produce charts in a ReportViewer? (bar, pie, and line charts)
I managed to make RadCharts in a User Control, but I can't seem to produce anything inside a ReportViewer.
My data source (for the chart) is an array, and I'm using WPF.
Darius
Top achievements
Rank 1
 answered on 19 Aug 2014
5 answers
115 views
Hi,

I'm getting this message error when I' try to export the report from my report viewer.



could somebody give me a hand with this please?

Regards.
Hinata
Top achievements
Rank 1
 answered on 19 Aug 2014
2 answers
131 views
I have a stand-alone HTML page based on the Report Viewer samples. This page calls the api/reports API. When my report is not parameterized, the Report Viewer works great and my report appears. I am now trying to add parameters to my report. 

Here is my Report Viewer script that passes the parameter:
$("#reportViewer1")
            .telerik_ReportViewer({
                serviceUrl: "http://localhost:36563/api/reports/",
                templateUrl: '/ReportViewer/templates/telerikReportViewerTemplate-8.1.14.804.html',
                reportSource: {
                    report: "MembersTest.trdx",
                    parameters: {
                        LastName: 'McGuy'
                    }
                }
            });

Here is the parameter JSON being passed into '/api/reports/clients/085707-b6ce/parameters':
[{"name":"LastName","type":"System.String","text":"Last Name","multivalue":false,"allowNull":false,"allowBlank":true,"isVisible":false,"autoRefresh":false,"hasChildParameters":false,"childParameters":null,"availableValues":null,"value":"McGuy","id":"LastName","label":"McGuy"}]

So it appears to be passing the parameter. In fact, I added a text box that prints the LastName parameter, and when the report loads, it shows "McGuy", which is the value I am passing. But the report does not return any rows. Here is my report SQL:

SELECT
Last_Name, First_Name, Middle_Name, Birth_Date
FROM
Member
WHERE
(Last_Name = @LastName)

When I go through the "Configure SQL Data Source" dialogues in the stand alone Report Builder, it returns records based on my parameter, when I preview.

I am not sure what I am doing wrong. Any help would be great.









Shawn
Top achievements
Rank 2
 answered on 18 Aug 2014
2 answers
168 views
I'm designing a couple of reports in a class library. Suddenly I keep getting the following error, printed in the report itself, when I try to preview the report:

An error has occurred while processing Report '<report name>': COM object that has been separated from its underlying RCW cannot be used.

After I completely restart Visual Studio, I can generate the report again, without a problem. However, when I make a change, the error comes back.

This restarting is getting tedious. What is wrong? Is there a way to solve this? Or when this happens, is there a quicker way of making the report run again?

Thanks in advance,
   Herre
Boardy
Top achievements
Rank 1
Veteran
 answered on 18 Aug 2014
3 answers
362 views
We are working on a crosstab report where there is a row group (Category) and two column groups (Location and Gender),  and we are showing total hours as the value. What we'd like to do is to show the hours as a percentage of the total for that Category and Location. The attached screenshot shows what we want, and also what the report designer gives us.

Basically if we have Category 1 and Location 1, we'd like to show the percentage of females for that category and location only. We are using an expression like

= Sum(Fields.TotalHours)/ exec("Gender1",Sum(Fields.TotalHours))

However this EXEC statement returns the total for the whole Gender group. We've tried the other groups, with similar results.

Is there a way to sum only across the current range of values?
Nasko
Telerik team
 answered on 18 Aug 2014
6 answers
466 views
On occasion our report viewer will receive a "Report is unavailable or session has expired." when opened in a new window on an ASP.NET 2.0 application.  This started when pushed to our production environment which is load balanced using round robin.  Production is also HTTPS.  Also, the images on the report never show.  Everything worked great on our test server which is not load balanced and is not HTTPS.

Any help is greatly appreciated.

Thanks,

Warren
أشرف
Top achievements
Rank 1
 answered on 18 Aug 2014
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?