Crystal Report uses Javascript to achieve Export functionality, Check whether the javascripts files are all available in the server. Check in the aspnet_client folder.

N.Surendra Prasad

What you expect this piece of code to do? Please refrain your question.

N.Surendra Prasad

What is the browser you are using and what is the error message you are getting?

N.Surendra Prasad

Hi, I have an click once application. The prerequisites which i have mentioned is .net Framework 2.0. If the prerequisite is not there, in publish.html, i get a button to download it, else the Run button will install the application (which is developed by me) . This works fine in all the machines, except for one in which i have the following versions of .NET Framework, .NET Framework 3.0 Service Pack 2 3.2.30729 .NET Framework 3.5 SP1 3.5.30729 .NET Framework 2.0 Service Pack 2 2.2.30729 In this machine even though we have Framework 2.0 and higher versions, i am getting the button to download Framework. This is not correct. Can any one help me on how to overcome this problem.

N.Surendra Prasad

The Data Access code is embedeed in my page. I donot have a separate DLL for that.

N.Surendra Prasad

Yes, i published it through Visual Studio.

N.Surendra Prasad

Yes, 64 bit .net framework is installed in that machine.

N.Surendra Prasad

Hi, I have an website which has few pages accessing data in an old method(The ADODB method) and few pages using the ODBC method. All the pages works fine in an 32 bit XP machine. We have a server with 64 bit, when i deployed this website in that server, i got the following error, Class not registered Exception Details: System.Runtime.InteropServices.COMException: Class not registered Stack Trace: [COMException (0x80040154): Class not registered] ADODB.ConnectionClass.Open(String ConnectionString, String UserID, String Password, Int32 Options) +0 When it tries to opdn the ADODB connection, it fails. I have installed MDAC 2.8 in that server. Do i have to do anything more to get it work. Any suggestions would be of great use.

N.Surendra Prasad

This can be done in different ways, it depends on how you get the source data. 1) If you can get the source data in XML format, then you can design an XSL and present the XML as such. 2) You can frame html with the source data and render the html to the page. 3) you can use Gridview or datagrid without pagination (but this will be slow). The best method is the first one.

N.Surendra Prasad

I have a .net web project where we use Crystal report(which comes along with VS 2005) for few of the reports. It works fine in the localhost, but when run in the server it throws the following error Also i have an XML file which will be read by an dataset and this dataset will be provided as datasource to the report. Error: Type 'http://schemas.microsoft.com/sqlserver/2004/sqltypes:varchar' is not declared, or is not a simple type. Stack Trace: [XmlSchemaException: Type 'http://schemas.microsoft.com/sqlserver/2004/sqltypes:varchar' is not declared, or is not a simple type.] System.Xml.Schema.XmlSchemaSet.InternalValidationCallback(Object sender, ValidationEventArgs e) +1081039 System.Xml.Schema.BaseProcessor.SendValidationEvent(XmlSchemaException e, XmlSeverityType severity) +67 System.Xml.Schema.Compiler.CompileElement(XmlSchemaElement xe) +2134 System.Xml.Schema.Compiler.Compile() +823 System.Xml.Schema.Compiler.Execute(XmlSchemaSet schemaSet, SchemaInfo schemaCompiledInfo) +17 System.Xml.Schema.XmlSchemaSet.Compile() +292 System.Data.DataSet.ReadXSDSchema(XmlReader reader, Boolean denyResolving) +301 System.Data.XmlDataLoader.ProcessXsdSchema() +144 System.Data.XmlDataLoader.LoadData(XmlReader reader) +1657577 System.Data.DataSet.ReadXml(XmlReader reader, Boolean denyResolving) +900 System.Data.DataSet.ReadXml(String fileName) +62 Reports_CrystalPage.Page_Load(Object sender, EventArgs e) +239 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061 Any help would be of great use.

N.Surendra Prasad

Hi, I have an windows application which is deployed through a website. Now i have included the .net Framework 2.0 as one of the prerequistes through the publish wizard. I have also given a URL from which the application will be loaded. Since this application will be deployed in multiple servers, we cannot hardcore the URL from which the application should be downloaded. So, i am passing parameters to the setup.exe to take it from the current server in which it is running.(this all works fine). I get the following error when setup.exe runs, The following package files could not be found: C:\Documents and Settings\Administrator\Local Settings\Temporary Internet Files\Content.IE5\BZ1NHQ5E\dotnetfx\dotnetfx.exe Do anyone know why this happens? Regards N.Surendra Prasad ;)

Hi, I have an XML file which is stored in a folder named XML and i have an RPT file (stored in CrystalReports folder) which has been designed by using this XML file as datasource. The report works fine in my local machine. But, when released in the server it is not working, it is giving the message like "Database logon failed". My Code behind, repDoc = New CrystalDecisions.CrystalReports.Engine.ReportDocument repDoc.Load(Server.MapPath("~/Reports/CrystalReport/MyReport.rpt"), CrystalDecisions.Shared.OpenReportMethod.OpenReportByDefault) repDoc.SetDataSource(Server.MapPath("~/Reports/XML/MyXML.xml")) CrystalReportSource.Report.FileName = Server.MapPath("~/Reports/CrystalReport/MyReport.rpt") Do anyone know why it is not working. Regards N.Surendra Prasad ;)

try this on your body onload event document.body.style.overflow='hidden'; Regards N.Surendra Prasad ;)

I have already done that, but no use. It will work until i close the project. Once i open it and run it, it will take me to default.aspx page. The issue here is: The entry(start up page option which i selected) is not getting saved in my solution file. This works fine for my other projects, only one particular project has this issue.

Hi, In my project, i made one of the page as Startup Page, by right clicking on that aspx file and selecting "set as startup page". This works fine, but this is not saved in my solution file, so each and every time, i open the project, i need to do this task, else it is taking me to default.aspx page. Do any one know, how to make this work, i donot want to set the page as start up page, each and every time i open the project. Any reply to this would be of great help to me. :-O N.Surendra Prasad

Do you have any sample on how to use this?

is it possible to format the number 150000 to 1,50,000. I tried formatting using DataformatString but, it displays 150,000. Do anyone know how to format a number to indian currency. N.Surendra Prasad

Assume the following is your gridview rowediting event private sub gridview_rowediting() 'this will be your code. gridview.editindex = e.neweditindex(); 'call the function which loads your data - see be :) low loadData() end sub 'This is the function which loads data in your grid. private sub loadData() query = "select * from ..." . . . gridview.datasource = dataTable gridview.databind() end sub

;) In the rowEditing and rowUpdating events, call the function which will load your grid. In your above example, after setting the newEditIndex, you need to load your grid again. Surendra Prasad

Hi Navaneeth, I tried using the cnn variable from File2, it throws the error "variable cnn not declared" N.Surendra Prasad Winning doesn't always mean being first, winning means you're doing better than you've done before.