Telerik Forums
Reporting Forum
10 answers
659 views
Hi,

I have managed to get all report functionality working with a SQL Express database (in web application), but when I try to connect to a SQL Server Compact database, I get the following error: 

An error has occurred while processing Report 'OutstandingPayments':
Unable to establish a connection to the database. Please, verify that your connection string is valid. In case you use a named connection string from the application configuration file, make sure the name is correct and the connection string settings are present in the configuration file of your application.
------------- InnerException -------------
Unable to find the requested .Net Framework Data Provider. It may not be installed.


The code behind the report designer is this:

this.sqlDataSource1.ConnectionString = "Data Source=\"C:\\Users\\Amecily\\Desktop\\Wits\\DFP v2.1\\Latest\\DFPProductions_Default" +
   "\\DFPProductions_Default\\App_Data\\DFP.sdf\"";
           this.sqlDataSource1.Name = "sqlDataSource1";
           this.sqlDataSource1.ProviderName = "Microsoft.SqlServerCe.Client.4.0";
           this.sqlDataSource1.SelectCommand = resources.GetString("sqlDataSource1.SelectCommand");

Is there something I need to do to the connection string?

Thanks,
Amy
Hinata
Top achievements
Rank 1
 answered on 11 Dec 2013
2 answers
284 views
Hello
Is there template available to use with font awesome version 4+?

Regards
Marcin
Marcin
Top achievements
Rank 1
Veteran
 answered on 11 Dec 2013
1 answer
125 views
Am I missing something?  I go to the demos on reporting, I see a demo "Invoice" that is nearly identical to what i'm looking to do.  I don't see the code pages like in the other products.

I just need to see the html/javascript mockup, and i'd like to bind my report to a class.  If that's possible.

Thanks
Stef
Telerik team
 answered on 11 Dec 2013
1 answer
78 views
Hi

I've gone through the quickstart tutorial to display a report, but intellisense underlines the report viewer with the following error:

unknown type or namespace 'Reportviewer' of 'Telerik'

It doesn't look like the reports have registered properly.

Andy
Stef
Telerik team
 answered on 10 Dec 2013
1 answer
139 views
We have a report that is developed using the standalone designer. The xaxis scale is a date value. We are trying to configure the chart to show only every 3rd or 4th axis value; however in order to do that the scale needs to be changed to DateTime. When we try to do that in the designer, it crashes.

Also, is it possible to programmatically interact with reports in the standalone designer? In the VS designer you can access code-behind, but it doesn't seem clear if there is any way to do that with TRDX files.
Nasko
Telerik team
 answered on 10 Dec 2013
5 answers
834 views
Hi,

I'm having Telerik.Reporting.OpenXmlRendering.dll, DocumentFormat.OpenXml.dll in my dev server. But while executing the report, its showing the error, 'DOCX rendering format is not available.'. But when I tried to debug in my local pc, its working fine.

Please help me on this...


Thanks,
Mahesh O A
thelostleaf
Top achievements
Rank 2
 answered on 09 Dec 2013
8 answers
1.3K+ views
Hi -
I read in the Telerik documentation that you may export to word but I do not have that option in the asp.net report viewer.
How do I get this option to show.
Thanks
Andy
SOFIENE
Top achievements
Rank 1
 answered on 09 Dec 2013
1 answer
352 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
274 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
623 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
Top users last month
Simon
Top achievements
Rank 2
Iron
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Grant
Top achievements
Rank 3
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?