Telerik Forums
Reporting Forum
1 answer
294 views
hello, i hope someone can help me with this problem.  

I have a mvc web app that has an edmx connection setup.  i added a class library to run the reports and created a new edmx in that class library.  

i am trying to setup a simple test report using the new HTML5 viewer.

I setup entity framework using your articles which seemed to work.

I am getting the dreaded 'Format of the initialization string does not conform to specification starting at index 0.' error and although i have copied the connection string from my reports project app.config to the main application web.config, i still get this error when trying to view the report through the application.  The report is visible using the preview mode in the visual studio.

The report only has one table on it which was setup using the table wizard.

my connection strings in the web.config:
   
<add name="TargetZeroEntities" connectionString="metadata=res://*/TargetZero.csdl|res://*/TargetZero.ssdl|res://*/TargetZero.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=uldev02\sql2008;initial catalog=TargetZero;persist security info=True;user id=TargetZeroDev;password=TargetZeroDev1@;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" /><br>
    <add name="TargetZeroReportEntities" connectionString="metadata=res://*/ReportingContext.csdl|res://*/ReportingContext.ssdl|res://*/ReportingContext.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=uldev02\sql2008;initial catalog=TargetZero;persist security info=True;user id=TargetZeroDev;password=TargetZeroDev1@;multipleactiveresultsets=True;application name=EntityFramework&quot;" providerName="System.Data.EntityClient"/>


The 2nd one(TargetZeroReportEntities) is used for the reporting project and was copied exactly as is from that project.

the report is very simple:
constructor{
            InitializeComponent();

            this.DataSource = entityDataSource1;
            this.table1.DataSource = entityDataSource1;
}

any suggestions to resolve this error?

EDIT: this has nothing to do with the table on the report.  I tried deleting that and i still get the same error.

EDIT2:  i have also gone through this article on setting up the datasource manually for production but it did not resolve this issue.
Stef
Telerik team
 answered on 09 Dec 2013
1 answer
249 views

I have a crosstab that displays financials over three time periods (year, month, week) this is the first column group. The next  sub column group is actual vs forecast. The aggregate column for this  takes  max(field.value) - min(field.value) to determine the variance between actual and forecast.


I need to figure out either how to conditionally format this field to show whether the variance is favorable or unfavorable (probably with color)



I need to write the expression to subtract



(fields.value Where fields.type = actual) - (fields.value Where fields.type = forecast)



with this the result would be negative if unfavorable.





Basically I need to create case or switch statements for conditional formatting and format string values can this be done either through the expression editor or through the backend C# code behind page.

Nasko
Telerik team
 answered on 09 Dec 2013
10 answers
516 views
Hi,
I am new to Telerik Reporting so sorry for this basic question. I've tried to search the forums and could not find an answer.

In our reports we need to show http links to different URL ( as actions, to download a file, etc).

Unfortunatelly, I could only make it work on the HTML preview (by using Textbox.Value = <a href > tag, but then using PDF it's not compatible and show the html tag text directly.

How can I achieve a simple http link in PDF format?
If this is not supported directly is there any workaround?

KS
Top achievements
Rank 1
 answered on 09 Dec 2013
2 answers
469 views
Hi I'm stucked with a little problem.
I'm working with the telerik report designer, and I'm trying to show a chart on a report I'm designing. I've already did a sample with SSRS and now I would like to get about the same chart with telerik.
I almost got everything to work as I wanted but I still have 2 little problems I can't solve, because I can't find the properties to change on my designer.

the first is that my linechart does not start from the intersection of X and Y axis, and at the end leaves a blank space from the image you can see it in the 2 blue squares
the second is the Xaxis interval, as you can see from the image in the green square, the label are a bit a mess, but i cannot find where I could set this property too.

Can somebody help me?

Thank you very much raphael
raphael
Top achievements
Rank 1
 answered on 06 Dec 2013
2 answers
348 views
Hello, i am trying to setup a simple example of reports on our MVC 4 application but i am having difficulty in referencing my report.

i have setup my view and controller as described in these articles:
http://www.telerik.com/help/reporting/html5-report-viewer-embedding.html
http://www.telerik.com/help/reporting/telerik-reporting-rest-implementing-http-service.html

I do NOT want to use a trdx file to reference my report, i just want to be able to use the Report.cs file as we would have in the past.  None of the documentation talks about using the .cs report files anymore, which is somewhat confusing.

According to this post, we still can use .cs report files.

When i try to view the report, the viewer is displayed but there is just a message saying 'Not Found'.  So what is the correct way to reference a .cs report?

Currently my viewer is setup as:
        $("#reportViewer1")
            .telerik_ReportViewer({
                serviceUrl: "/api/reports/",
                templateUrl: '../Content/ReportViewer/templates/telerikReportViewerTemplate.html',
                reportSource: { report: 'new Telerik.Reporting.TypeReportSource() { TypeName = "Application.Reports.TestReport, Application" }' },
                scale: 1.0
            });

Application is the main assembly.
Reports is the folder where my reports are stored, in the Application project.  
TestReport is the .cs report file.

what am i missing? please n thanks.

Edit: there is also a javascript error when the report is displayed that says:
Failed to load resource:      http://localhost:53661/api/reports/clients/115240-ff1a/parameters
I assume its related to the fact that it cant find the report but thats about all i can figure out from that.
Peter
Telerik team
 answered on 06 Dec 2013
3 answers
256 views
Hi,

I am using Telerik Reports with my Silverlight 4 application and wanted to know if there is a way to change the layout and format of the parameter controls?  For example, I want to change the width of the controls.

Please help.
Stef
Telerik team
 answered on 06 Dec 2013
1 answer
336 views
Same question but for HTML5 Report viewer.   I know the HTML5 report viewer has a template but not sure about the ASP.net report viewer, but in either case, is it possible to customize the layout and format of the parameter controls in one or both of the previous?
Stef
Telerik team
 answered on 06 Dec 2013
1 answer
53 views
Hello,

Last year, our company bought a license for "Reporting Q3 2012". And now, we need to upgrade to "Reporting Q3 2013", is the same license bought last year still working ? if yes, how ?

Thanks
JP
Top achievements
Rank 1
 answered on 05 Dec 2013
3 answers
587 views

I cannot get any of the following to work for me:

 

 

I have a WPF project that contains several Telerik Report Q3 2013 objects. The reports also have parameters and they preview just fine. During runtime, each report runs a query that fetches data from a SQL Server database and displays the results in the reports.

 

The WPF app has a menubar. At runtime, a user can go to the Reports menu, and choose to preview Report1, Report2, or Report3. There is a WPF window that hosts a report viewer control (called RptViewer). When the code behind a menu option executes, such as the Report3 menu option, the code basically does the following:

 

    private void mnuReports_View_Report3_Click(object sender, RoutedEventArgs e) {

        InstanceReportSource irSrc = new InstanceReportSource();

        RptViewer winRptView = new RptViewer();

        irSrc.ReportDocument = new Report3();

           

        winRptView.rptViewer.ReportSource = irSrc;

        winRptView.Show();

    }

This all works fine and the correct report is previewed every time. My problem is that each report stores a static connection string.

 

I intend for some of my clients to install and use this WPF app within their own network. The reports will need to access the data within their own SQL Server databases. So I need the connection strings to be updated accordingly. We already have the correct connection strings; we just need the string to be assigned to a report whenever it is loaded by the report viewer. I don’t know why I can’t get this to work.

Nasko
Telerik team
 answered on 05 Dec 2013
1 answer
310 views
Hello,
I'm trying to get a handle at runtime to the total page count of a generated report but am unable to find a property containing this data. Being able to get it from a saved PDF file would also work for me.  Any tips help would be appreciated.
Thanks
Nasko
Telerik team
 answered on 05 Dec 2013
Top users last month
Jay
Top achievements
Rank 3
Iron
Iron
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
Radek
Top achievements
Rank 2
Iron
Iron
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Richard
Top achievements
Rank 4
Bronze
Bronze
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?