|
Hi Abishek and Shameel,
Thanks for your reply.
Actually we have already generated RPT files using Crystal XI. I'm trying to use from VS.NET 2005 to let users quickly refresh with latest data. When I tried to copy the RPT files to the application folder's subfolder named Reports and hardcoded the same foldername and the filename, it gives me Missing parameters while clicking refresh icon of the CrystalReportViewer (as per the attached code). Actually the report has saved parameters in it (I verified from application using reports ParameterField's HasCurrentValue property of each field in the loop).
My intention is to let user to click refresh icon of the embedded CrystalReportViewer to refresh the report (loaded from Reports sub folder as in code) with latest DB data and using the saved parameter values. That's all. As per the below code, It shows "Missing Parameters values" mesg. and the report did not get refreshed. When I commented the this.CrystalReportSource1.ReportDocument.Refresh(); line in ReportDocument_RefreshReport funtion, it shows "The Report Application Server failed" error mesg from the viewer, but the report get overwritten as per my intention. How to avoid this "The Report Application Server failed" error mesg. I don't know what am I missing here. Pls see the assemblies and code as below...
Attaching the code as it is not properly attached in my previous reply ...
=======================
Begin - aspx.cs code
=======================
using System;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.CrystalReports;
using CrystalDecisions.Shared;
using CrystalDecisions.Web;
public partial class _Default : System.Web.UI.Page
{
private ConnectionInfo connectionInfo = new ConnectionInfo();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//ConfigureCrystalReports();
}
}
protected void CrystalReportViewer1_Init(object sender, EventArgs e)
{
ConfigureCrystalReports();
}
private void ConfigureCrystalReports()
{
string reportPath = Server.MapPath(@"Reports\Report1.rpt");
this.CrystalReportSource1.ReportDocument.Load(reportPath);
CrystalReportViewer1.Visible = false;
SetDBLogonForReport(this.CrystalReportSource1.ReportDocument);
foreach (ParameterField field in this.CrystalReportSource1.ReportDocument.ParameterFields)
{
field.HasCurrentValue = true;
}
//this.CrystalReportSource1.ReportDocument.Refresh();
CrystalReportViewer1.ReuseParameterValuesOnRefresh = true;
CrystalReportViewer1.Visible = true;
}
public void ReportDocument_RefreshReport(object sender, EventArgs e)
{
try
{
SetDBLogonForReport(this.CrystalReportSource1.ReportDocument);
CrystalReportViewer1.ReuseParameterValuesOnRefresh = true;
this.CrystalReportSource1.ReportDocument.SetDatabaseLogon("user", "passwd", "server", "");
foreach (ParameterField field in this.CrystalReportSource1.ReportDocument.ParameterFields)
{
field.HasCurrentValue = true;
field.AllowCustomValues = true;
//field.EnableNullValue = true;
}
this.CrystalReportSource1.ReportDocument.Refresh();
this.CrystalReportSource1.ReportDocument.SaveAs(@"C:\Inetpub\wwwroot\XsiteRpt\Reports\Report1.RPT", true);
}
catch (Exception ex)
{
Msg.Text = ex.Message;
}
}
public void SetDBLogonForReport(ReportDocument reportDocument)
{
Tables tables = reportDocument.Database.Tables;
connectionInfo.ServerName = "server"; //ConfigurationManager.AppSettings["DBServer"];
connectionInfo.UserID = "user"; //ConfigurationManager.AppSettings["DBUser"];
connectionInfo.Password = "passwd"; //XsiteWinRpt.ConnUtil.GetOnlyPasswordOfConnString(); //ConfigurationManager.AppSettings["DBPassword"];
foreach (CrystalDecisions.CrystalReports.Engine.Table table in reportDocument tables)
{
TableLogOnInfo tableLogonInfo = table.LogOnInfo;
tableLogonInfo.ConnectionInfo = connectionInfo;
table.ApplyLogOnInfo(tableLogonInfo);
}
}
}
=======================
End - aspx.cs.code
=======================
=======================
Begin - Assemblies
=======================
<assemblies>
<add assembly="CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
<add assembly="CrystalDecisions.Shared, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
<add assembly="CrystalDecisions.ReportSource, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
<add assembly="CrystalDecisions.Enterprise.Framework, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
<add assembly="CrystalDecisions.Enterprise.Desktop.Report, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
<add assembly="CrystalDecisions.CrystalReports.Engine, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
<add assembly="CrystalDecisions.Enterprise.InfoStore, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/><add assembly="CrystalDecisions.ReportAppServer.ClientDoc, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
</assemblies>
=======================
End - Assemblies
=======================
=======================
Begin - aspx
=======================
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Xsite.aspx.cs" Inherits="_Default" %>
<%@ Register Assembly="CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"
Namespace="CrystalDecisions.Web" TagPrefix="CR" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Refresh Report</title>
<link href="/aspnet_client/System_Web/2_0_50727/CrystalReportWebFormViewer3/css/default.css"
rel="stylesheet" type="text/css" />
<link href="/aspnet_client/System_Web/2_0_50727/CrystalReportWebFormViewer3/css/default.css"
rel="stylesheet" type="text/css" />
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Panel ID="PanelMsg" runat="server">
<br />
<asp:Label ID="Msg" runat="server" Font-Bold="False" Font-Names="Verdana" ForeColor="Navy"></asp:Label>
<br />
</asp:Panel>
<asp:Panel ID="PanelViewer" runat="server">
<CR:CrystalReportViewer ID="CrystalReportViewer1" OnReportRefresh="ReportDocument_RefreshReport" runat="server" AutoDataBind="True"
EnableDatabaseLogonPrompt="False" EnableParameterPrompt="False" ReuseParameterValuesOnRefresh="True" HasRefreshButton="True" Height="820px" OnInit="CrystalReportViewer1_Init" ReportSourceID="CrystalReportSource1" ShowAllPageIds="True" Width="1215px" />
<CR:CrystalReportSource ID="CrystalReportSource1" runat="server">
</CR:CrystalReportSource>
</asp:Panel>
</div>
</form>
</body>
</html>
=======================
End - aspx
=======================
|
|
|
|
|
Hi Abishek and Shameel,
Actually the RPT files are already saved with old data. I need to refresh only.
Thanks.
|
|
|
|
|
then what is the problem. Just use location.href or location.replace.
Better check out this :
http://grizzlyweb.com/webmaster/javascripts/refresh.asp
Hoping this helps you.
Cheers.
|
|
|
|
|
Abhishek,
I'm getting "The Report Application server failed" mesg.
That's issue while refreshing the report.
Thanks.
|
|
|
|
|
Is it a client side error. This might be a problem of not requesting the child pages from the browser.
|
|
|
|
|
I am using interop for creating excel ..
i ve cretaed the excel file.
Now i need to hide or delete some of the columns....
Can u plz tell me the code for that...
Thanks in Regardss....
|
|
|
|
|
Instead of creating Excel u can create XML and that xml u can open with Excel. and jo will easier to add and delete from Excel
Thanks,
Amit
|
|
|
|
|
Besides the XML there is a c# excel component Spire.XLS,it can creating Excel .
|
|
|
|
|
Do some experimentation yourself. Although I am not an expert in Excel Automation, I remember something like Worksheets[0].Columns collection.
|
|
|
|
|
Thanks for the Reply.....
I have found the solution....
for hiding first column
Excel.Range rangen2 = oSheet.get_Range(oSheet.Cells[5, 4]);
rangen2.EntireColumn.Hidden = true;
|
|
|
|
|
How are you using Excel with ASP.NET ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Thanks for the Reply.....
I have found the solution....
for hiding first column
Excel.Range rangen2 = oSheet.get_Range(oSheet.Cells[5, 4]);
rangen2.EntireColumn.Hidden = true;
|
|
|
|
|
Hello,
I am using :Net 3.5, ît has CSS2.1 validator, how can I migrate it to CSS3.0?
modified on Thursday, November 12, 2009 6:03 AM
|
|
|
|
|
Retrieving the COM class factory for the component with CLSID due to following error and error is 80070005
|
|
|
|
|
Check if Crystal Report is installed in Server properly.
|
|
|
|
|
in server framework is present but crystal report is not present i think there is some issue of version
|
|
|
|
|
You need to install crystal report component to the server as well to use it. I think the component you are asking for is not registered....
The component generally installs with Framework.
|
|
|
|
|
how to create a remote desktop using asp.net??
urgently!!!
Thank you...
and do you have any tutorial for build it??
i will wait for the answer...
|
|
|
|
|
Hey... This is very easy. I think there is a component for this.
Use Microsoft Terminal Services Type
If you add this to your form, you might use UserName, Password to open Terminal.
|
|
|
|
|
ok, thank you friend...
but, i want to create remote desktop software using asp.net C# language...
do you anything source code or the software made by used asp.net C#??
|
|
|
|
|
As I told you earlier.. You can easily access this component from your application.
Take a look on this article to find some insight on this :
Remote Desktop using C#.NET[^]
|
|
|
|
|
v_neil87 wrote: i will wait for the answer...
Then keep waiting. It is considered very rude around here to say you need it urgently. People here volunteer their time and your problem is not urgent to anyone but you.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
The Microsoft Terminal Services Type Library can be used only with Windows Forms applications. It cannot be used with ASP.NET. A remote desktop through web interface is a very advanced topic.
|
|
|
|
|
in gtalk,at a tme can v snt a msg like 'Hi' to all existng cntact membrs lke yahoo?
I know this is not at all relative place..but i dnt have other option
Srinivas Mateti
|
|
|
|
|
No I dont think there is any option.
sris 426 wrote: I know this is not at all relative place
Then why should you post here. Its true this is not the right place to post this query.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
