Telerik Forums
Reporting Forum
1 answer
142 views
Hi, i am trying to add expression to a textbox in code. I can easily do it in the design view like ([=Fields.name]). But i want to set this property in code. So how can i do it ?
Nasko
Telerik team
 answered on 20 Aug 2014
1 answer
222 views
I have 2 websites that I am running in localhost. 1 is the main web app and the 2nd is the telerik reporting application.
My connection string looks like this:
Data Source=.\SQLExpress;AttachDbFilename=C:\ODI\ODI_AGBSafety.mdf;Trusted_Connection=Yes;

I keep getting the following error and don't know what to do

"CREATE DATABASE permission denied in database 'master' An attempt to attach an auto-named database for the C:\ODI\Example.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. 

Any help would be greatly appreciated.

thannks,

Chad
Stef
Telerik team
 answered on 20 Aug 2014
2 answers
224 views
Hello !

I'm using WPF Telerik Reporting Q2 2014 in my application. In one of my reports, I've a table and a chart. Both of them have a different SqlDataSource ( using parameterized stored procedure). My report DataSource is null.   When I preview the report, it works fine and I can see the data. However, when I render the report in the reportviewer, nothing is being displayed. I'm using the following code:

            Report report = new Report();
            report .ReportParameters["StartDate"].Value = this.StartDate;
            report .ReportParameters["EndDate"].Value = this.EndDate;
            InstanceReportSource reportSource = new InstanceReportSource();       
            reportSource .ReportDocument = report ;
            telerikReportsViewer.ReportSource = reportSource ;

Am I missing anything ? Please guide.
Josh
Top achievements
Rank 1
 answered on 20 Aug 2014
1 answer
126 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
173 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
571 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
402 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
190 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
129 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
143 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
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?