Crystal Reports :: Connection To Db Seems To Be Hard Coded?
Apr 7, 2010
I built a crystal report using crystal report 2008, and have it working fine aganist my test db. in my c# code that loads the report I put this in:
[Code]....
but problem is when i pushed this change to production, the report was stilling pulling test data, even though the web.config entry (LocalSqlServer) was updated in production to use production db. Could I have setup the crystal file incorrectly? When I'm creating the crystal file and connecting it to the db, is there something that I need to check or uncheck to tell it I'm going to dynamically supply the db connection rather than having it use the one I used to setup the report?
The simple website I am trying to build is a list of banks with their corresponding website. I also wanted the ability to add banks/website with the use of some text boxes and a button click event. I've got this fully working until I publish it. When I try to run it on the webserver it say it can not find the specified file c:windowssystem32inetservURLs.xml Now I understand the problem I just can not seem to fix it with out hard coding the path of the file into code.
Partial Class _Default Inherits System.Web.UI.Page Protected Sub btnAdd_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnAdd.Click ' Load the Document Dim Doc As New XmlDocument Doc.Load("URLs.xml") 'Create a New Element Dim bankNode As XmlNode bankNode = Doc.CreateElement("bank") 'create and add sub elements for this node Dim nameNode, addressNode, dateNode As XmlNode ' nameNode = Doc.CreateElement("name") addressNode = Doc.CreateElement("address") dateNode = Doc.CreateElement("date") bankNode.AppendChild(nameNode) bankNode.AppendChild(addressNode) bankNode.AppendChild(dateNode) 'add the text data nameNode.AppendChild(Doc.CreateTextNode(tbWebsite.Text)) addressNode.AppendChild(Doc.CreateTextNode(tbAddress.Text)) dateNode.AppendChild(Doc.CreateTextNode(DateTime.Today)) 'add the new element to the end of the list Doc.DocumentElement.AppendChild(bankNode) 'save it Doc.Save("URLS.xml") End Sub End Class
I am running a LINQ query which populates a list used by a DropDownList, I need to insert an "Unassigned" value to the list. The function below queries the values correctly from the db but does not insert the "Unaasinged" value to the list.
As the title says then the question is relative simple however I cant decide whether a resource file with strings in is better than hard-coded strings...
I want to use this to insert and edit values from a db. For example when adding a record the user selects 'One Day Shoots' and 1 gets inserted into the database. Then if the user goes to edit the page since the value in the db is 1 then the 'One Day Shoots' is selected.
One way I considered accomplishing this was by using a hidden feild - when the user selects something in the dropdown list the field is updated with the value, then when the user actually adds the record the value in the feild is submitted. I'm pretty sure this would work but is there a better way?
I'm relativley new to ASP and am using VB for the coding. I have a page that has a few fields on it, one being a drop down list that get's populated from a SQL Server.
I used the GUI to generate this form (see below), the connectionstring:Prod1ConnectionString that is stored in the web config file is hard coded. I want to change that I use the connection string that is passed as a Session parameter. I've been looking for hours for an example of how to remove the connectionstring from the web code and place the proper code in code behind script on the load_page event.
Is there anyway to use a connection string from web.config for Crystal Report? The problem I'm having is that I develop on two different computers and on each I use a different IP to connect to the SQL Server. And when I deploy to a web server I use "localhost". So each time I get prompted for changes from the Crystal Report...
When i run the application locally it works fine but when i publish it n access from it it gives the error asEither the Crystal Reports registry key permissions are insufficient or the Crystal Reports runtime is not installed correctly.
I have serveral databases with same tables. I created a crystal report to show the report for respective logins from the database. I have a problem in it. In crystal report when i changing the database it should not change the respective table. It loads only the table what we give in the connection string first time.
I wanted to post my problem and solution since I've gotten some good information on this board. When deploying my Visual Studio 2008 C# .NET 2.0 web application Production, I encountered some problems, which is not unusual. What was unusual is that my Crystal Reports .NET reports that use the Report Viewer control would not work; they errored out with:
note: Crystal Report works fine in dev environment....
Logon failed. Details: ADO Error Code: 0x Source: ADODB.Connection Description: Provider cannot be found. It may not be properly installed. Unable to connect: incorrect log on parameters.We are using Oracle 11g 64 bit as database. We establish crystal report database connection by two ways,
1. Microsoft OLE DB Provider for Oracle
2. Microsoft OLE DB Provider for ODBC
but we got the same error in report module when we using two methods.
I'm new to Visual Studio.NET . I need to integrate the crystal reports into an ASP.NET application. I generated Crystal report with the help of crystal report XI developer edition(Stand alone version and NOT from the one which comes from visual studio).
How to integrate this report with the web application.
We have quite a few reports which were developed earlier in Crystal Reports 8.5. We are now planning to use these reports in our web application developed in VS 2008 (C#).
What dlls are needed for calling 8.5 in the application and how should they be added to the application while shipping it to the client?
They are also struggling to get the code running. Would also need the code to call the report with parameters.
I have already generated crystal reports but i've made them static. but now i want to make the user to select the criteria for generating the reports. for eg., in one of them i want to show monthwise data so user should be able to select the month and year and that would be passed as parameter and compared to the existing data. provide me with proper exact code that can be used for giving parameters in such a report using C#.
In my system Visual studio 2008 with sp1 and Crystal Reports XI Release 2.In Visaul studio 2008 ,while adding add reference it showing crystal reports version 10 instead of 11.How to solve the version problem.
I am considering using Crystal Report 2008 as my tool of creating reports on my webpage.The only problem which I'm facing is that I have no control of the remote server which hosts my site (besides uploading files). I can't run a MSI to deploy the CR runfiles.I can't find anywhere in the CR user manual of how to deploy the runtime files without running the msi, and I'm not even sure it's possible.Have anyone deployed CR 2008 without running the MSI and without having to register any files?
I have a field in my dataset with type nvarchar(1000). when I link it to crystal reports, it converts it to a field of type string with length set to 100. As a result of that, the string in that field is being truncated on the report. How can I increase the string length to 1000? (I already checked the "Can grow" option).
I have developed few crystal reports using VS.2005 and now i want to deploy the same on my web server which is running Windows 2003 server and got installed only .net frame work 2.0.... so now i want to know how can i run those reports successfully and i have downloaded CRRedist2005_X86.msi and even crXIsp3 and 4 _net_server from business objects page and i do have Crystal Reports XI original CD.... while by using them can i run crystal reports on my web pages.
Reports Error when publishing a Website on to the Web Server---- The type initializer for 'CrystalDecisions.Shared.CrystalReportClientScriptManager' threw an exception
I'm working on a site that ws developed using VS 2005 and the server where the site is running has Crystal Reports for .net 2.0 (ver 10.2.36)I will be making changes. I just ported the website to my local computer, and build the site using VS 2008, that comes with Crystal R. Basic.I haven't tested all the functionality of the site, so I'm not sure since all the pages that use C. Reports work ok.My main concern is about publishing the site I compiled to the server. Will things work, if I have Crystal R. Basic and the server has Crystal R. for .net 2.0.
I have a web application designed using VS2008 & Crystal Reports for VS2008 (Ver. 10.5.3700). I'm using Framework 2.0 for deployment.
My development system is WinXp and my deployment system is Win2003 Server.
Here is what i have done -
1) Added a Crystal Report to my project "rptReport.rpt"
2) Added a Crystal Report Source (crSource) to my .aspx page.
3) Added Crystal Report Viewer to my page, with crSource as its Report Source.
This works fine when i run it on my development machine. But Gives a "Load Report Failed" error on my deployment machine. This is what i have already tried doing on deployment server:
1) Giving IIS_WPG full control to temp folder.
2) Publishing with "Allow this precompiled site to be updatable." checked/unchecked.
Crystal reports are properly working on my local pc but not on server. I am using vs 2008 and install crystal report for Visual basic 2008 on server.but parameter count for CrystalReport is zero on server.
