Telerik Forums
Reporting Forum
1 answer
211 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
218 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
118 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
170 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
561 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
396 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
185 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
120 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
138 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
177 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
Top users last month
Rob
Top achievements
Rank 3
Bronze
Iron
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?