|
Respected Sir,
I have developed a web application in VS 2005.
It has a report created in Crystal report.
It works fine on my development machine or even on my web server (while the project is running locally on web server itself).
But i am not able to get that repport after deploying the project on my server and accessing from client.
i am using the URL like http://PublicIP/ProjectName/frmLogin.aspx
It shows me the error "Load Report Failed."
I have googled a lot but can not get any idea....
My code is------
Dim rptRefForm As RptShowRefForm
Dim ref_no, year As Integer
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If Not Page.IsPostBack Then
ShowReport()
End If
End Sub
Private Sub ShowReport()
Try
conn = New SqlConnection(constr)
cmd = New SqlCommand("spr_getReport", conn)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add(New SqlParameter("@ref_no_toShow", Glb_RefNo))
cmd.Parameters.Add(New SqlParameter("@FinYear", Glb_FinYearFrom))
dadapter = New SqlDataAdapter(cmd)
ds = New DataSet
dadapter.Fill(ds)
rptRefForm = New RptShowRefForm
rptRefForm.Refresh()
rptRefForm.SetDataSource(ds.Tables(0)) rptRefForm.SetDatabaseLogon("DBUserName", "DBPWD")
CrystalReportViewer1.ReportSource = rptRefForm
CrystalReportViewer1.DataBind()
conn.Close()
Catch ex As Exception
lblError.Text = ex.Message
End Try
End Sub
And on click of a button i want to export this report in to PDF format...
for that i m using...
Private Sub btnExport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExport.Click
Dim oStream As New MemoryStream ' // using System.IO
'this contains the value of the selected export format.
ShowReport()
oStream = rptRefForm.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat)
Response.Clear()
Response.Buffer = True
Response.ContentType = "application/pdf"
Try
Response.BinaryWrite(oStream.ToArray())
Response.End()
Catch err As Exception
Response.Write("< BR >")
Response.Write(err.Message.ToString)
End Try
End Sub
Please assist me how can i run that report from the client...
What is the problem..Is there any security issue.....
I will be highly obligue..
Ajay Kumar
|
|
|
|
|
|
Hello Sir
I have already installed Crystal reports for .Net Framework 2.0.
But still the same error..
Infact i have installed VS2005 on my web server.
But Of no use....
Suggest something Plz...
|
|
|
|
|
Sir
I m giving the stacktrace and message of my exception object which generates when i m trying to access my web site from the public IP..
StackTrace:----
at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened() at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename, OpenReportMethod openMethod, Int16 parentJob) at CrystalDecisions.CrystalReports.Engine.ReportClass.Load(String reportName, OpenReportMethod openMethod, Int16 parentJob) at CrystalDecisions.CrystalReports.Engine.ReportDocument.EnsureLoadReport() at CrystalDecisions.CrystalReports.Engine.ReportDocument.get_FormatEngine() at CrystalDecisions.CrystalReports.Engine.ReportDocument.Refresh() at Mktg_Artwork.frmDisplayRpt.ShowReport() in C:\Inetpub\wwwroot\Mktg-Artwork\frmDisplayRpt.aspx.vb:line
Message:---
Load Report Failed.
However i have already installed crystal reports for .net framework2.0 on web server
Infact I have installed VS2005 on my web server.
Still facing the above problem..
Please Sir,help me out....
Ajay Kumar
|
|
|
|
|
I have a weird problem where the Text specified for my RadioButtons doesn't show when the buttons are inside a table column. Any ideas why this is happening?
|
|
|
|
|
post your code so we can see what is happening.
Maybe the columns arent wide enough to hold the text..
|
|
|
|
|
It only works as is, but without the width attribute, the TD seems to extend off the bounds of the designer. Setting decreasing widths I saw the text creeping out from the right.
[table]
[tr]
[td]
[asp:RadioButton runat="server" ID="optClosedJobs" Width="220px" GroupName="ArchiveType" Text="Export Documents for Closed Jobs" /]
[/td]
[td][/td]
[/tr]
[/table]
|
|
|
|
|
Basically the radiobutton displays ok for me with no widht and then when I put the width in it depends how wide I set it to how much you can see, what is the oringinal problem then?
|
|
|
|
|
eyeseetee wrote: what is the oringinal problem then?
Maybe it's because he is using '[' and ']' instead of of '<' and '>'
|
|
|
|
|
How does one post HTML without 'escaping' special chars?
|
|
|
|
|
Brady Kelly wrote: How does one post HTML without 'escaping' special chars?
<body>
<h1>You have to read the posting instructions for the site, some of which are on the page you are using to post your message.</h1>
<h2>How does one approach doing software development without learning that reading instructions (documentation) is extremely important?</h2>
<comment>But yeah I agree with you, this is very funny</comment>
</body>
led mike
|
|
|
|
|
It actually isn't for want of looking for those instructions I asked. Maybe my mind was on other things, and still is, because I genuinely don't see any such instructions.
|
|
|
|
|
i have adsl and windows xp pro
i test the send email through iis smtp server
the aplication finish but me email no sent
EPSendMail v1.0.2999.36948
Console application to send smtp mail
Sending email message
From --> test@test.com
To --> raquidd@yahoo.com
Subject --> test
Message --> test
SMTP Server --> 127.0.0.1
the only think is the test@test.com
if i use window xp and i not count how i can do
have the email in the Mailroot Queue
i found a article about
Ensure that your machine is able to resolve MX
records for the destination domain in the DNS"
i trying to follow the article but i dont understand the part with
i configure with me isp
is possible i send emai Through me isp without ask it
thanks for the time
|
|
|
|
|
You need to check all your e-mail settings as it sounds like the e-mail is not getting sent through the mail server
look up articles as well because the code is very simple to get it started
|
|
|
|
|
Hi all
Iam exporting a table to word. it is working ok. However my client do not want the popup msg (open,save,cancel) to appear. Instead he wants to open the word document directly. Is this possible? How?
|
|
|
|
|
If you are using vs.net 2.0,
In
Response.AddHeader("Content-disposition", "attachment; filename=test.doc");
replace attachment with inline.
Should solve your problem.
I was born dumb!!
Programming made me laugh !!!
--sid--
|
|
|
|
|
Yes iam using 2.0, however it didnt work. can u plz guide me to a link or place it is done b4 or could u just show me how how to write the code for it. thanks in advance.
|
|
|
|
|
I've taken a div to show or hide some information in Master Page's content page and it's working. But if i click on "Submit" button given inside the div then div is being hidden to show or display the div until it is closed i've used the code given below.
HtmlControl frame1 = (HtmlControl)this.FindControl("divCityInformation");
frame1.Visible = true;
But it's showing and error Object reference not set to an instance of an object
modified on Wednesday, March 19, 2008 7:53 AM
|
|
|
|
|
you need to check what page your masterpage is on, some things you put in masterpage cant be used as they conflict with the pages that are using masterpage
try putting a simple webpage up with masterpage as its linked page and go from there
post what other errors you get
object reference usually means you have created a control but not referenced e.g.
aspbutton onlcik="something"
but you havent declared the onclick
make sense!!
|
|
|
|
|
I see you have changed your post.
If I am making sense of your problem, you are trying to access a control in a hidden div?you can't do this.
This might explain the object reference error
|
|
|
|
|
yes you are right But friend that problem i've solved. Please suggest me what should i do now.
|
|
|
|
|
post all your code and I can see whats going on
|
|
|
|
|
<script language="javascript">
function showDiv()
{
e=document.getElementById("<%=divCityInformation.ClientID%>");
//e=document.getElementById('divCityInformation');
if(e.style.display=="none")
{
e.style.display="block";
}
else
{
e.style.display="none";
}
}
</script>
===================
<a href="#" onclick="showDiv();" class="manojLink" title="Click Here To Enter New City">Click Here To Enter New City</a>
===================
<div id="divCityInformation" style="border:solid 1px black; width:400px;top:125px;left:250px;position:absolute;display:none; background-color:#efefef;" runat="server">
<table border="0" cellpadding="0" cellspacing="0" style="width: 100%">
<tr>
<td colspan="2" align="right" class="manojHeaderStrip1">
New City Information
<a href="#" onclick="showDiv();" title="Close" style="text-align:right;color:Red;color:White;font-size:8.5pt;">[Close]</a>
</td>
</tr>
<tr>
<td colspan="2" height="20">
</td>
</tr>
<tr>
<td style="width: 50%" class="manojTDRight">
Enter City Name</td>
<td style="width: 100px">
<asp:TextBox ID="txtCityName" runat="server" CssClass="manojTextBox1"></asp:TextBox></td>
</tr>
<tr>
<td colspan="2" style="height:7px;">
</td>
</tr>
<tr>
<td style="width: 50%" class="manojTDRight">
Enter Column No.</td>
<td style="width: 100px">
<asp:DropDownList ID="ddlColumn" runat="server" Width="150">
<asp:ListItem Selected="True">1</asp:ListItem>
<asp:ListItem>2</asp:ListItem>
<asp:ListItem>3</asp:ListItem>
</asp:DropDownList></td>
</tr>
<tr>
<td style="width: 50%" height="10">
</td>
<td style="width: 100px">
</td>
</tr>
<tr>
<td style="width: 50%" class="manojTDRight">
<input type="submit" id="Submit1" value="Submit" runat="server" onserverclick="Submit1_ServerClick" />
</td>
<td style="width: 100px" class="manojTDLeft">
<input type="reset" id="Reset1" />
</td>
</tr>
<tr>
<td class="manojTDRight" height="10" style="width: 50%">
</td>
<td class="manojTDLeft" style="width: 100px">
</td>
</tr>
<tr>
<td class="manojTDRight" colspan="2" height="10">
<asp:Label ID="Label1" runat="server"></asp:Label></td>
</tr>
</table>
</div>
======================================
protected void Submit1_ServerClick(object sender, EventArgs e)
{
HtmlControl frame1 = (HtmlControl)this.FindControl("divCityInformation");
frame1.Visible = true;
}
|
|
|
|
|
I've just tested the code and it works
Try putting the following code in a .cs file if you havent already. like a code behind file
protected void Submit1_ServerClick(object sender, EventArgs e)
{
HtmlControl frame1 = (HtmlControl)this.FindControl("divCityInformation");
frame1.Visible = true;
}
|
|
|
|
|
Hi,
How I will display Yes, No, Cancel, 3 buttons in javascript message box. There is no problem to create two buttons.
Thanks in advance
|
|
|
|