Unable to discover a solution to this issue in other forum posts. I have an VS2010 Framework 4 ASP.Net application that uses a Telerik report. I actually have two problems to solve today.
1) I started out to fix a bug where the report parameter seems to have been ignored for a master/detail report. The data coming back is the record related to the default parameter value.
2) In the process if trying to get back into Design mode, I am forced to comment out the connection string code in Sub New() for the master report and all sub reports. After doing this and setting the default parameter to zero I now get the OCIEnvCreate failed error and can't find out how to resolve it. Oracle Home is not the problem as it worked fine in Design mode and App mode before I commented out the connection string code. I also validated that the connection string in app.config had the correct userid and password (I had changed the userid to something invalid so that I could certify that the report was using the web.config connection string at runtime vs the app.config string used at Design time.) It is in fact correct.
The (commented out) code in the Master report is given below. All subreports (there are five of them) have the identical code sans the property code.
I have to say this is extremely irritating and frustrating to have to comment and uncomment these code snippets to work in design vs run mode. I consider this a bug, and it really needs to be fixed. It's a major source of wasted development time. Once things get bollixed up one has to 'Clean' the project, recompile, sometimes exit the IDE and restart it, and in two cases last week I had to restore files from the day before to get back to a certain starting point.
If anyone knows a solution to this issue, I would be extremely grateful for any help that can be rendered!
Regards,
Rich
(
Partial
Public Class RequisitionMasterReport
Inherits Telerik.Reporting.Report
Public Sub New()
InitializeComponent()
'Me.DataSource.ConnectionString = ConfigurationManager.ConnectionStrings("WFL_TelerikReports").ConnectionString
'Me.DataSource.ProviderName = ConfigurationManager.ConnectionStrings("WFL_TelerikReports").ProviderName
End Sub
Public Property RequisitionObjectID As Integer
Get
Return Me.ReportParameters("ReqOI").Value
End Get
Set(ByVal value As Integer)
Me.ReportParameters("ReqOI").Value = value
End Set
End Property
End
Class
)