|
Hi everyone,
I'd like to know if it is possible to work with VS.NET this way:
a) using ADO.NET in order to access Oracle database
b) using Crystal Reports 9 to access this XSD file created from dataset
c) so, the Web application should be able to capture parameters in order to feed the report outside the application thru this XSD file. Also, Crystal Application Server (RAS9) would be responsible to run the reports (not the Crystal embeded on VS.Net) and shows up from the Crystal Viewer.
d) this way, we'd like to avoid the recompilation and redployment when the report design changes.
Anybody can tell me if it is suitable?
thanks
|
|
|
|
|
I am using VS.Net to set up a DataSet (xsd). starting from him I set up a report in crystal reports 10 that I want to publish in a paste that the RAS 9 have access permission, but I am not getting to turn the report crystal.
This informing the following mistake:
--------------------------------------------------------------------------------
Error in File C:\WINDOWS\TEMP\{7243DB8C-36BF-4227-8137-B78BC196C5F0}.rpt: The request could not be submitted for background processing.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.COMException: Error in File C:\WINDOWS\TEMP\{7243DB8C-36BF-4227-8137-B78BC196C5F0}.rpt: The request could not be submitted for background processing.
Source Error:
Line 69: crs.ReportAppServer = "192.168.0.105"
Line 70:
Line 71: crs.Open("C:\Program Files\Crystal Decisions\Report Application Server 9\Reports\Teste.rpt")
Line 72: '.Report.FileName = "C:\Program Files\Crystal Decisions\Report Application Server 9\Reports\Teste.rpt"
Line 73: crs.DatabaseController.SetDataSource(dsRelatorio)
Source File: C:\Crystal\RASNET\ras9_vbnet_web_DiscreteParam\WFrmReport.aspx.vb Line: 71
--------------------------------------------------------------------------------
Segue o codigo do sistema.
-------------------------------------------------------------------------------
Imports System.Data
Imports System.Data.OleDb
Imports CrystalDecisions.Web
Imports CrystalDecisions.ReportAppServer.ClientDoc
Imports CrystalDecisions.ReportAppServer.Controllers
Imports CrystalDecisions.ReportAppServer.DataDefModel
Public Class WFrmReport
Inherits System.Web.UI.Page
Dim mdb_path As String = "C:\Program Files\Crystal Decisions\Report Application Server 9\Samples\En\Databases\xtremeteste.mdb"
Private conn As New OleDbConnection
Dim crs As ReportClientDocument
Public Sub PreencheDataSet()
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & mdb_path
Dim da As New OleDbDataAdapter( _
"Select OrderId From Orders ", _
conn)
Dim daCustomer As New OleDbDataAdapter( _
"Select * from Customer ", _
conn)
Dim daOrder As New OleDbDataAdapter( _
"Select * from Orders ", _
conn)
Dim dsRelatorio As New dsxtreme
conn.Open()
daCustomer.Fill(dsRelatorio.Customer)
daOrder.Fill(dsRelatorio.Orders)
conn.Close()
crs = New ReportClientDocument
crs.ReportAppServer = "192.168.0.105"
crs.Open("C:\Program Files\Crystal Decisions\Report Application Server 9\Reports\Teste.rpt")
crs.DatabaseController.SetDataSource(dsRelatorio)
'crs.ReportDocument.SetDataSource(dsRelatorio)
CrystalReportViewer1.ReportSource = crs
CrystalReportViewer1.DataBind()
End Sub
Public Sub InicializaReport()
PreencheDataSet()
End Sub
#Region " Web Form Designer Generated Code "
'This call is required by the Web Form Designer.
<system.diagnostics.debuggerstepthrough()> Private Sub InitializeComponent()
End Sub
Protected WithEvents CrystalReportViewer1 As CrystalDecisions.Web.CrystalReportViewer
'NOTE: The following placeholder declaration is required by the Web Form Designer.
'Do not delete or move it.
Private designerPlaceholderDeclaration As System.Object
Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: This method call is required by the Web Form Designer
'Do not modify it using the code editor.
InitializeComponent()
InicializaReport()
End Sub
#End Region
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Put user code to initialize the page here
End Sub
End Class
-------------------------------------------------------------------------------
I am using ASP.NET 2003 with Crystal Reports 10 and with the RAS 9 with report servant.
Thanks
|
|
|
|
|
respected sir
i hav made a datagrid and bind it to database.anyone can update and delete the records with the help of this grid.
now i hav to search the records.
for that i am opening a modal dialog box.and on the basis of search criteria
it shows the records in a grid in modal dialog.Here for the searched records i hav also given the functionality to update and delete.
i hav updated some of the records here.
upto this everything is working fine.
now when i m going to close modal dialog box(either by a back button or using browser) i want to bind the parent's grid by updated records.
i have tried to refresh parent and used this javascript function on
click of the back button.
function Closewindow()
{
opener.location.reload(true);
self.close();
}
but it only refreshes my parent window.
which is not my objective.
any suggetion
Ajay
|
|
|
|
|
Hi
how i can add a "marquee" to my web page using ASP.NET ??????????
|
|
|
|
|
Javascript, don't use the <marquee> tag.
|
|
|
|
|
thanks,
but can u give me an example of this
and what is the parameter of it ........
|
|
|
|
|
hope this link may assist u..
http://www.javascriptkit.com/javatutors/marquee4.shtml
|
|
|
|
|
|
|
I have an application which communicates with WebServcie when.I installed the application and the WS on a srever of test,i've got all the results i'm waiting for.But when I installed the Web site and the WS on the WEBFARM, the Web site did no longer communicate with the WS. The site can communicate with the WS installed on the server of test.And another site installed on a site different from the WEBFARM can communicate with the WS installed on the WEBFARM.
The problem is that the Web site installed in WEBFARM cannot communicates with the WS installed on the same WEBFARM. What to do!
Here is a snapshot of the debugging window showing the emerged errors:
A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SocketException (0x274c): A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond]
System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) +1002066
System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP) +33
System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception) +431
[WebException: Unable to connect to the remote server]
System.Net.HttpWebRequest.GetRequestStream() +1504445
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) +103
PTF2_EVALTA.InfoAgent.test(String chaine) in d:\BuildAreas\mk_build\PTF2_EVALTA\V0.013\PROJECTS\PTF2_EVALTA\Web References\PTF2_EIDS_WebService\Reference.cs:90
PTF2_EVALTA.WebForm1.Page_Load(Object sender, EventArgs e) in d:\BuildAreas\mk_build\PTF2_EVALTA\V0.013\PROJECTS\PTF2_EVALTA\PTF2_EVALTA_APP\WebForm1.aspx.cs:34
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061
mouadh trabelsi
|
|
|
|
|
HI Check for the Firewall make it Off and try once again
|
|
|
|
|
thanks for ur reply
I already try this solution it didn't work
mouadh trabelsi
|
|
|
|
|
Hi Friends,
Anybody know AspMaxRequestEntityAllowed Metabase Property (IIS 6.0)? I want to know what is the drawback if this value is set to maximum (default-200k and Max - 1GB)?
|
|
|
|
|
|
Thanks for replying Vasudeven..
I have read all these articles. Microsoft have three more article regarding the same with different colors. My need is to know the drawbacks if I set the value to maximum (1GB).
|
|
|
|
|
Hi,
I'm having trouble reading the text displayed in a HyperLinkField inside a GridView during a loop. I have no trouble reading BoundField and Checkboxes.
For Each gRow In GridView1.Rows ' Loop the gridview
' get the checkbox object inside a TemplateField
Dim Chkbox As CheckBox = CType(gRow.Cells(0).Controls(1), CheckBox)
If Not Chkbox.Checked Then
' Read from a normal BoundField, works ok
cmd.Parameters.AddWithValue("@ProjectName", gRow.Cells(8).Text)
' Read from a HyperLinkField = ERROR
Dim hlf As HyperLinkField = CType(gRow.Cells(3).Controls(0), HyperLinkField)
' Don't know if next line is valid, but reflects what I want to do.
cmd.Parameters.AddWithValue("@NextField", hlf.Text)
cmd.ExecuteNonQuery()
cmd.Parameters.Clear()
End If
Next
Thanks!
abohlin
|
|
|
|
|
i wanna use a scanner from my web page and i want the scanned picture directly online and not on disk. can u help plz.
vina
|
|
|
|
|
You'd need to automatically open up the scanner's TWAIN interface, fire off a scan automatically and save it on the webserver somewhere automatically (off the top of my head). How do you do that? Probably with a lot of nasty C code!?
|
|
|
|
|
Hi
I’m converting a project from visual studio 2003 to visual studio 2005. The problem is:
In the 2003 project I got a folder (called businessLayer) containing all the .cs business classes and one of these classes is referencing a user control in another folder after converting the businessLayer folder became under app_code folder so it can’t see the folder containing the user control so I put the cs files in a folder (also called businessLayer) out of the app_code folder but the all the controls can’t access the new folder out of app_code while they can see another folder containing another user controls.
So what can I do to overcome this problem, any idea
shaimmaa
|
|
|
|
|
Why is your business layer using a UserControl? You would be better to look at changing that, ideally the business logic doesn't need to have access to anything on the view.
|
|
|
|
|
Hi
Am having a web page with many textboxes and 3 buttons(button1,button2,button3).
Since there are many textboxes,the user can enter value in them with no tab order,according to his convenience.
My requirement is that -- Wherever the cursor is focussing(any of the textboxes),when the user clicks 'Enter' key,it should activate the Button1's Click event.
Can anyone help me how to do this?
Thanks!
|
|
|
|
|
|
Thanks Deepak
I tried like this...
<br />
function buttonClick()<br />
{<br />
if ((window.event.which == 13) || (window.event.keyCode == 13)) <br />
{<br />
document.getElementById('btnDisplay').click();<br />
return true;<br />
} <br />
else <br />
return false;<br />
}<br />
And in Code behind, i tried as
<br />
HtmlForm form1 = (HtmlForm)Page.FindControl("Form1");<br />
form1.Attributes.Add("onkeydown","javascript:buttonClick()");<br />
Is this correct ?
In which event actually i need to call the Javascript?
Please help me!
|
|
|
|
|
the logic is right but thw way u implemented is not right.....
do one thing
function buttonClick()<br />
{<br />
if ((window.event.which == 13) || (window.event.keyCode == 13)) <br />
{<br />
alert("Got U!!")<br />
return true;<br />
} <br />
else <br />
return false;<br />
}<br />
function OnPageLoad()<br />
{ <br />
document.getElementById("Button").onkeydown=buttonClick;<br />
document.forms["FORM_NAME"].onkeydown=buttonClick;<br />
}<br />
<br />
<body onload="OnPageLoad()">
|
|
|
|
|
Thanks friend!
But there's no attribute 'removed' in <body..> tag.
is it enough that i just include that attribute?
Can you please help me?
|
|
|
|