Crystal Reports :: How To Use Application To Connect Different Database On The Server
Jun 21, 2010
i have created several crystal report for my web application, i need to use my application to connect different database on the server which has no problem in the application but when i open the reports created using crystal report, it still connected to the database configured. how can i fix this, is there other way than to use another copy of the application and configure it manually at the each of the reports. i do have pass the logon information to the report using vb.net in which i get the info from the web.config
Dim A As ConnStr = New ConnStr
With ConnInfo
.ServerName = A.getServerName()
.DatabaseName = A.getDBName()
.UserID = A.getUser()
.Password = A.getPwd()
End With
my problem is how to make crystal report to uses all the logon info passed and not use the infor set in the report file
View 4 Replies
Similar Messages:
May 7, 2015
I'm developing asp.net website connected to a Azure Database, is there a Reporting tool in Visual Studio that can connect Azure Sql Database?
View 1 Replies
Nov 9, 2010
to print a crystal report from the server's printer with a button on the web application.Assume that I have a ASP .NET Web Application, When i press the "print" button on the web application, the server which holds the web application prints the specific crystal report with specific data set. Is this possible? How I am going to make this happened?I am sorry to say that I'm very new to all these web programming,
View 3 Replies
Jun 13, 2010
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.
View 1 Replies
Feb 28, 2011
I have an vb 2005 asp application that will show a crystal report based upon a user selection which is a job number.On my development machine all work fine and the report is being shown every time.When I publish the application the web server it works for most part. Every so often for selected job numbers the report that will not display. When this happens there is a text being displayed above the business object banner:The Report Application Server failed I have checked the event log and there is no entries. Also there is no stack trace. The application seems to complete normally. I have compared the registry entries in HKEY_LOCAL_MACHINESOFTWARECrystal Decisions and they are the same id evelopment and production. I am referencingCrystalDecisions.CrystalReports.Engine version11.5.3700.0I am clueless and hoping that someone could suggest where to start looking
View 2 Replies
Feb 15, 2010
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?
View 8 Replies
Feb 21, 2011
I am trying to deploy crystal reports 2008 on shared server. Before publishing on the remote server i published it on the localhost while connecting it to remote sql server 2008 database. The report is shown perfactly but when i publish it on shared server it prompt me for login credentials. My hosting provider is arvixe and it support crystal report. In my popup database field is empty and locked use name field show the correct user name and password field is empty. I read somewhere it may be due to version conflict between my version and version on server.
View 9 Replies
Feb 9, 2010
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.
View 1 Replies
Apr 25, 2010
I have a crystal report using store procedure with DSN Name: 192.168.0.3. when I keep the connection to this server it's OK
But when i change the logon info and disconnect to the server to connect to My PC it appear the error :
"Unable to connect: Incorrect log on parameter"
[code]....
View 3 Replies
Aug 5, 2010
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.
View 2 Replies
Sep 28, 2010
how to connect an asp.net application running in local IIS to a database residing in a remote web server ?
View 2 Replies
Dec 17, 2010
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.
CrystalReportViewer.ReportSource = Session("Rpt" & Request.QueryString("ReportGroup") & Request.QueryString("ReportCode"))[code]....
View 6 Replies
Jan 4, 2011
why does my crystal reports not loading on the server
View 4 Replies
Sep 17, 2010
We have just migrated our Application's reports from Crystal Report 10 To 12. But on conversion everything goes fine.Except the reports which are built on Typed data sets started genrating the Message "The report you requested requires further information".
with the login parameters dispalying on the page.{Note: we are using Visual Studio 2005 (framework2.0)}
e.g
Server name
Database name
user
password
View 1 Replies
Nov 28, 2010
My report does not use data from a database. It uses a code generated dataset. How do I give crystal reports the necessary logon data to avoid database logon failures.
View 1 Replies
May 29, 2010
Runtime Error Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine. Details: To enable the details of this specific error message to be viewable on remote machines, please create a tag within a "web.config" configuration file located in the root directory of the current web application. This tag should then have its "mode" attribute set to "Off". Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's configuration tag to point to a custom error page URL. ----------------------------------- This error will be display when I am try to show the Crystal Report. Can anybody tell me what Property I have to ser in Windows Server 2008 R2 or in IIS7???
View 1 Replies
Jun 22, 2010
I installed Visual Web develperTrying to get a crystal report to show in the form but therte are no Crystal obhject to select Installed Visual Studio 2008 I can add an Item for Crystal now in form show the form and I see it has menu bar for crystal viewer and I see the report Now if I move the webpage to our server which has IIS 7.0, ASP.net 3.5 what else do I need to install on the server so it wil show the crystal report in the form?
View 5 Replies
Mar 8, 2010
I'm getting so frustrated with not being able to find the answers to my extremely simple (or so it seems) questions.I'm using Visual Studio 2008,and I am trying to use a non-local database as my data source.This must be possible to do somehow,but I can't figure out how.It wants to be able to connect to a database,and it's not going to be able to.
with a workaround?Would it be easier to just make an asp.net page with a gridview than trying to make an actual crystal report?
View 3 Replies
Jul 16, 2010
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.
View 9 Replies
Jun 8, 2012
in my web Application, i have set the Connection String in Class as Follows :
public
class
clsConnection
{
publicSqlConnection con = newSqlConnection(@"server=desire5SQLEXPRESS;uid=sa;pwd=desire;database=DesireSchool ;"
);
}
Now i want to use this Connection StringĀ for Crystal Report,i have tried by using Object of this classHow can i Use this Connection StringĀ For Crystal Report .
View 1 Replies
Apr 6, 2010
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#.
View 3 Replies
Feb 12, 2011
Trying to preview a crystal report in pdf format in web application by passing parameter but showing error message:
crReportDocument.Export()
missing parameter value
<CODE>
Dim crExportOptions As ExportOptions
Dim crDiskFileDestinationOptions As DiskFileDestinationOptions
Dim Fname As String
crReportDocument.Load(Session("rptFileName"))
CrystalReportViewer1.ReportSource = crReportDocument
CrystalReportViewer1.RefreshReport()
CrystalReportViewer1.ParameterFieldInfo.Clear()
Fname = "C:TempTemp.pdf"
crDiskFileDestinationOptions = New DiskFileDestinationOptions()
crDiskFileDestinationOptions.DiskFileName = Fname
crExportOptions = crReportDocument.ExportOptions
With crExportOptions
.DestinationOptions = crDiskFileDestinationOptions
.ExportDestinationType = ExportDestinationType.DiskFile
.ExportFormatType = ExportFormatType.PortableDocFormat
End With
If Session("rptType") = "PrintOption0" Then ' Without Parameter
' no need to do anything
ElseIf Session("rptType") = "PrintOption1" Then ' One Parameter
paramField.Name = "@UserID"
paramDiscreteValue1.Value = Session("rptParameter1")
paramField.CurrentValues.Add(paramDiscreteValue1)
paramFields.Add(paramField)
CrystalReportViewer1.ParameterFieldInfo = paramFields
End If
crReportDocument.Export()
Response.ClearContent()
Response.ClearHeaders()
Response.ContentType = "application/pdf"
Response.WriteFile(Fname)
Response.Flush()
Response.Close()
' delete the exported file from disk
System.IO.File.Delete(Fname)
</CODE>
View 2 Replies
Jul 30, 2010
The application basically displays a list of reports and allows the user to select a particular report to run. Once the report is selected, the appropriate parameter screen is displayed. The parameter screen contains options for displaying the report either as an Excel Spreadsheet or a PDF document.
When I run the application from within visual studio, it works fine. The reports display correctly in both formats.
THe problem is that once I publish the application (via msi installation file) to a Windows 2003 web server, the reports won't display. THe system just hangs. I added debug statements and the code is hanging during the ReportDocument.Load(Server.MapPath("/assetreport.rpt") command.
My deployment project includes the correct msm for Crystal Report 12 and the Web server also has the full blown version of Crystal Reports 12 installed.
View 5 Replies
Jan 4, 2011
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.
View 1 Replies
Sep 1, 2010
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).
View 3 Replies