Forum Topics Tagged [crystal-report]

Hello Friends, I Developed application in C# with crystal reports and created setup file in third party (Advance) Installer.When i installed my application on client system application is working but when i click on report it dosent work and generates error :System.TypeInitializationException: The type initializer for 'CrystalDecisions.Shared.SharedUtils' threw an exception. ---> System.IO.FileNotFoundException: Could not load file or assembly 'log4net, Version=1.2.10.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified. at CrystalDecisions.Shared.SharedUtils..cctor() --- End of inner exception stack trace --- at CrystalDecisions.Shared.SharedUtils.get_CurrentControl() at CrystalDecisions.Shared.SharedUtils.GetEffectiveCulture() at CrystalDecisions.Shared.LocaleManager..ctor() at CrystalDecisions.Windows.Forms.CrystalReportViewer.InitReportViewer() at CrystalDecisions.Windows.Forms.CrystalReportViewer..ctor() at TestPro.StkPosRep.InitializeComponent() in E:\TestPro\TestPro\Reports Forms\StkPosRep.Designer.cs:line 34 …

Hi all I just started using Crystal reports in vs2010. I have created a Dataset in the Designer and pulled data from an access DB. The dataset is being populated fine. My Issue is when I assign the dataset to crystal database expert and drag the columns to the report no data was displayed. So intead applying multiple columns to CR I only assigned one and this column displays data, but the data is wrong it displays colors and I don't have any table with colors in my DB. I'm wondering if I need to change any settings to have …

Can html program run Crystal Report? If yes can I have a sample code. I am now learning to write html programs. I know how to develope Crystal Report and I have many Crystal I want the html program to link to. Please help.

ewr

when I will make a report on vb6 using crystal report 8.5, the error message "Visual Basic has stopped working" what is causing the above?

I made a report in VB6 program using crystal report. Here I've made a connection between crystal reports, This is my coding CR_Summary.ReportFileName = "E: \ Report \ payments1.rpt" CR_Summary.Connect = "& OpenDB &" CR_Summary.WindowState = crptMaximized CR_Summary.ReplaceSelectionFormula "iCHECK_PAYMENT.PAYMENT_TYPE {} ​​= '" & C_Payment.Text & "'" CR_Summary.Action = 1 My connection is "OpenDB" when the program is run and want to see the report it appears the error message "Error Detected by Database DLL" and this error "Can not open sql server" I do not know why I can display an error message like that, when I tried another report …

Hello everyone. I would like to ask for your help, I've been stuck in this problem for wholde day. every time I run this code it gives me an error of "The report has no tables" even though I have a dataset. my dataset is datatable that came from the data from my listview. Here is my code: If ListView1.Items.Count <= 0 Then ' do nothing here Else 'print the number of item in listview MsgBox(ListView1.Items.Count) Dim mytable As DataTable = New DataTable("Employeelogs") ' create static field from column name = <fieldname> ... </fieldname> mytable.Columns.Add("field1") mytable.Columns.Add("field2") mytable.Columns.Add("field3") mytable.Columns.Add("field4") mytable.Columns.Add("field5") For …

hi, i have just migrated from CR8.5 to CR9. now i want to run/display Crystal Report 9 on client machine without installing it there. so, which .dll required for this situation? thanks, krunal

please help how i enable the crystal report viewer in mentiom image control

I had done my CR with version 8.0 and I can load the report successful with asp.net coding but failed to do the same for asp. Does anyone have any code sample or any reference? I had googled it but failed to get any answer. Thanks in advance.

hi i am currently using visual studio 2010 i want to create a report in my application! this form contains a two textboxes, a button and a crystal report viewer the two text boxes must take the todate and fromdate and when you press the button the report must display data belonging to those dates (i also have a field in my database called agreement_date and theses dates need to get filtered from this field) i am currently using the following link [url]http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-date-to-date.htm[/url] but since it is in visual studio 2005 version it is making things complicated! can someone please …

I need some help with Crystal Report and really couldn't find it via Google. I have a report which is like an 8 columns table and the thing is I only want to print out the 7 last ones but not the 1st. Using "Suppress" won't allow me to view the 1st column through CrystalReportViewer, are there some other ways? Please show me carefully cuz I'm only a newbie.

Can someone please tell me what i am doing wrong with this code. I have created a dataset and want to push that data into crystal reports. [CODE] Dim rpt As New CrystalReport1() 'The report you created. Dim myConnection As SqlConnection Dim MyCommand As New SqlCommand() Dim myDA As New SqlDataAdapter() Dim myDS As New DataSet2() 'The DataSet you created. Try myConnection = New SqlConnection("Data Source=localhost;Initial Catalog=maintsystem;Persist Security Info=True;User ID=mbish;Password=mbish") MyCommand.Connection = myConnection MyCommand.CommandText = "SELECT * FROM Hardware" MyCommand.CommandType = CommandType.Text myDA.SelectCommand = MyCommand myDA.Fill(myDS, "dataset2") rpt.SetDataSource(myDS) CrystalReportViewer1.ReportSource = "c:\CrystalReport2.rpt" Catch Excep As Exception MessageBox.Show(Excep.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error) End …

Bonjour à tous ! Question je pense assez simple, j'ai une bdd sql server 2008 avec 3 tables. Lors de mon premier test (je suis nouveau dans CR) j'ai mis toutes les tables dans le rapport. Même en retirant les liens, il me mixe les données bizarrement. J'en ai conclut qu'il fallait passer par des sous états. J'ai donc inclut un état, dans mon rapport principal. Quand je lance le site, le rapport principal s'affiche, il contient bien les noms de colonnes du sous rapport, mais aucune données ne s'affichent... Avec mon premier rapport j'envoyais les données dans le page …

afternoon all hope someone can help, i want to populate a report and print it directly without the user hitting the print button. i have this working in a diffrent project but for some reason it wont work in this one. i get the error missing parameter, on the last line of my code hope someone can help [CODE] Dim paramFields As New ParameterFields Dim paramField As New ParameterField Dim discreteVal As New ParameterDiscreteValue Private Sub IndlabelRep_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim rpt As New IndLabel() 'The report you created. Dim myConnection As SqlConnection Dim …

Hi everyone, I hope you could help me with my problem I am a fresh graduate and I am working now as a developer in a good company By the way, I am not the one who developed this tool, it's the previous programmer and they gave the project to me to update it however, when I try to run the application in my local computer I am getting this error: Argument not specified for parameter 'XLSFile' of 'Public Sub New(XMLFile As String, XLSFile As String)'. The error points to the code below in bold letter: [code] Protected Sub Button1_Click(ByVal …

please help me.. I don't know ho to make that. Thanks

Hi all i have been dancing around this problem for a couple of weeks now and have not got any closer. Description: i have created a crystal report in SQL5 and exported it fine but now i have gone to open it in visual studio 2008 and it does not recognise it as a report, nor does it open it. I created a new report in vs8 and exported it and that works fine with out a hitch. They are both in the same encoding as far as i can see but i still haven't found a proper way of …

hi... i have one application.. when i run that application the data is shown correctly and also with proper alignment.. i have hosted that application.. but in hosted application the report header size is reduced and the bank name and the narration values are same..(those should be separate) the problem occur only in hosted application.... check the attachment for image.. please help me... i am totally confused... help me.....

Hi, in my project I need to allow the user (admin user) to have the ability to run custom queries on the database. Ive done this pretty simply whwer the user enters their query and the reults are set to a datagridview. It would also be great however to allow the user to print the results of their custom query. For this I thought the easiest thing to do would be to use a crystal report. However the problem Im encountering is that because the dataset that the datagrid is populated from is empty until the user fires the query, …

Morning, Please a clever person help me, i am using VS2010, I have a form with a button with the following code. [CODE]Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles Button1.Click Dim cryRpt As New ReportDocument Dim crtableLogoninfos As New TableLogOnInfos Dim crtableLogoninfo As New TableLogOnInfo Dim crConnectionInfo As New ConnectionInfo Dim CrTables As Tables Dim CrTable As Table cryRpt.Load("c:\CrystalReport2.rpt") With crConnectionInfo .ServerName = "Localhost" .DatabaseName = "MaintSystem" .UserID = "mbish" .Password = "mbish" End With CrTables = cryRpt.Database.Tables For Each CrTable In CrTables crtableLogoninfo = CrTable.LogOnInfo crtableLogoninfo.ConnectionInfo = …

Please be kind enough to let me know how to create Crystal Reports for Visual Studio 2005 for a Client Server application? The problem I faced is that when I created Crystal Reports for Visual Studio 2005 where the Crystal Report is displayed in the client application it does not get refreshed with data entered. It only displays data that was entered during the time of development. I think this is probably because the database path changes when deployed in a new environment while the Crystal report keeps refering to the database location at development time. Pls. assist me in …