Sir. I create a project in vb.net 2010 sql server 2008r2 and crystal report 13. i use this code for showing the report. Public Sub PrintSaleRInvoice() Dim PrintSale As New DataSet objsale.saleinvid = txtSaleInvid.Text PrintSale = objsale.PrintSaleInvoice() ' Procedure name PrintSale.Tables(0).TableName = "DataTable1" Dim rpt As New SaleInv rpt.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Portrait rpt.PrintOptions.PaperSource = CrystalDecisions.Shared.PaperSource.Middle rpt.SetDataSource(PrintSale) SaleRInvPrint.CrystalReportViewer1.ReportSource = rpt SaleRInvPrint.ShowDialog() End Sub and it is work fine now i want to pass some value(company name, address, contact, Licence No etc.) cr er004 from global variable which is decalerd on a "global declaration" in a module. i used for CReport dataset cr …

Member Avatar
Member Avatar
+0 forum 1

Vshost.exe has stopped working... Posted A minute ago vshost.exe has stopped working this error showing after using the Crystal Report. The error show when I closed the application. If I not use the crystal report then the error not showing. I am creating a program in vb with visual studio 2010 ultimate and crystal report Please help me..... -------------- For view a report Public Sub PrintSaleRInvoice() Dim PrintSale As New DataSet objsale.saleinvid = txtSaleInvid.Text PrintSale = objsale.PrintSaleInvoice() ' Procedure name PrintSale.Tables(0).TableName = "DataTable1" Dim rpt As New SaleInv rpt.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Portrait rpt.PrintOptions.PaperSource = CrystalDecisions.Shared.PaperSource.Middle rpt.SetDataSource(PrintSale) SaleRInvPrint.CrystalReportViewer1.ReportSource = rpt SaleRInvPrint.ShowDialog() End …

Member Avatar
Member Avatar
+0 forum 1

Aslam o alikum, I create a report in Crystal report 9 with add command using Oracle 11g as Database with OLE DB (ADO) (Microsoft OLE DB provider for Oracle). It works fine in crystal report. I want to call this report from vb6 form. I m not using any server Machine , (VB6, ORACLE 11g, Crystal report 9 running on same PC(Machine). the code i m using is as under : this portion is defined in a Module Public RptApp As New CRAXDRT.Application Public Report As CRAXDRT.Report Public crxTable As CRAXDRT.DatabaseTable Public CPProperty As CRAXDRT.ConnectionProperty This portion is in a …

Member Avatar
+0 forum 0

hello I am trying to show Data in CrystalReport from Ms Access 2013 In button_click event String Cnstr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\parth\Documents\test.mdb;Jet OLEDB:DataBase Password=hello123" using (OleDbConnection Cn = new OleDbConnection(CnStr)) { using (OleDbCommand Cmd = new OleDbCommand("select * from Table1", Cn)) { using (OleDbDataAdapter Adp = new OleDbDataAdapter(Cmd)) { using (DataSet1 dt1 = new DataSet1()) { Adp.Fill(dt1, "DataTable1"); var rc = new ReportDocument(); rc.Load(@"C:\Users\parth\documents\visual studio 2013\Projects\FinalTest\FinalTest\CrystalReport1.rpt"); rc.SetDataSource(dt1.Tables[0]); crystalReportViewer1.ReportSource = rc; } } } } its show error on runtime as "Faild to load Database Information Error in File CrystalReport1" Pls help me out from this. if any other way to load …

Member Avatar
Member Avatar
+0 forum 1

How to auto fit text in crytal report..

Member Avatar
Member Avatar
+0 forum 1

I have a table there in SQL SERVER 2000 which has five fields[date income amount expense amount]. Now user wants to input first date & last date there in form to show records ok? To show record by one paraemeter was easy for me & I did it by following code. I mean I made one parameter & got one form with one text box & one button & one report viewer. Let me show you my code for button event what I used to show report by one parameter. Code : [CODE]Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared Public Class Form6 Inherits …

Member Avatar
Member Avatar
+0 forum 4

I can post a single line of row I selected from datagridview but I want to select specific multiple rows then display it in my crystal report. BTW I'm using VB2010. Dim cmd As New OleDbCommand("Select * From Data1 Where ID = " & Form4.DataGridView1.SelectedRows(0).Cells(0).Value.ToString() & "", Form4.con) Dim adpt As New OleDbDataAdapter(cmd) Dim DtSet As New DataSet Form4.con.Open() adpt.Fill(DtSet, "Data1") Dim crystal As New CrystalReport1 crystal.SetDataSource(DtSet.Tables("Data1")) CrystalReportViewer1.ReportSource = crystal CrystalReportViewer1.Refresh() Form4.con.Close()

Member Avatar
Member Avatar
+0 forum 3

I want to develop a simple application which runs on single computer (just runs in one mechine) and did not need network. Program has to store some data in database and show them for printing. I have no experience with real-word program so I confused here: If the program is so simple why should I use sql-server or crystal report; What is benefit of using them? What is benefit of not using them? I can use a Sqlite file or sdf file or sql-server for storing data and I can generate a html file or use crystal-report for printing the …

Member Avatar
Member Avatar
+0 forum 1

Hi everyone! I have used following code to show dates in combo boxes. Private Sub Income_Sheet_Report_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load cmbisrbdt.Items.Clear() cmbisrbdt.Text = "BEGINNING DATE" cmbisredt.Items.Clear() cmbisredt.Text = "END DATE" Me.FormBorderStyle = Windows.Forms.FormBorderStyle.None Dim con As New SqlConnection(ConnectionString) Dim com As SqlCommand = Nothing Dim reader As SqlDataReader = Nothing Try con.Open() com = New SqlCommand("Select CONVERT(varchar, dt, 105) AS TheDate From Income_sheet ORDER BY YEAR(dt) ASC, MONTH(dt) ASC, DAY(dt) ASC", con) reader = com.ExecuteReader(CommandBehavior.CloseConnection) If reader.HasRows Then cmbisrbdt.Items.Clear() cmbisredt.Items.Clear() While reader.Read If Not cmbisrbdt.Items.Contains(reader("TheDate")) Then cmbisrbdt.Items.Add(reader("TheDate")) End If If Not cmbisredt.Items.Contains(reader("TheDate")) Then cmbisredt.Items.Add(reader("TheDate")) End …

Member Avatar
Member Avatar
+0 forum 1

how can i change the value of data in crystal report base on the selected item in listview? i am using mysql and visual studio 2012

Member Avatar
Member Avatar
+0 forum 11

i was triying to load then get reportsource of my external report.rpt file but it dasnt work with this code dim report as new reportdocument report.load(filepath) report.reportsource here vb does not reconise this namespace any help urgent ?

Member Avatar
Member Avatar
+0 forum 1

Hello Folks, I am trying to create a Crystal report using data from two Access 2007 tables but it only displays the data from the first table only. when I do same with Access 2003, I am successful but it does not work in access 2007. Please help me to solve this problem. Thanks, Sammy

Member Avatar
Member Avatar
+0 forum 1

Hi, I tried to view crystal report by using crystal report viewer in Visual Studio 2010. However when i tried to declare ReportDocument, it is underlined with blue curly line. I had done the following in the code behind file. [CODE]Imports System.Data Imports System.Data.Odbc Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared Imports CrystalDecisions.Web[/CODE] the first two crystalDecisions was underlined with green curly line as well, and i had no idea how to solve it. i had done the following in asp.net page [CODE]<%@ Register Assembly="CrystalDecisions.Web, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" Namespace="CrystalDecisions.Web" TagPrefix="CR" %> ... <form ID="crystalForm" runat="server"> <div> <CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" AutoDataBind="true" EnableDatabaseLogonPrompt="False" EnableParameterPrompt="False" PrintMode="ActiveX" …

Member Avatar
Member Avatar
+0 forum 2

[B]CrystalReport asking for Username and Password but i didnt set a user and password in my database. I am using an Access database and VS8. How can I solved this. this my problem in more than 1 year which i cant solve. Please help me. THAnkz[/B]

Member Avatar
+0 forum 0

can someone help a newbie with .net the code i have is working fine to pass one parameter to crystal, can someone help me pass a second parameter called "line"? [CODE]Imports System.Windows.Forms Imports System.Data.SqlClient Imports OEE_NEW.Module1 Imports System.Data Imports System.IO Imports System.Data.SqlTypes Imports System.Windows.Forms.DataVisualization.Charting Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.ReportSource Imports CrystalDecisions.Shared Imports CrystalDecisions.Windows.Forms Public Class FrmGraphReports Dim paramFields As New ParameterFields Dim paramField As New ParameterField Dim discreteVal As New ParameterDiscreteValue Private Sub FrmGraphReports_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim rpt As New CrystalReport1() 'The report you created. Dim myConnection As SqlConnection Dim MyCommand As New SqlCommand() …

Member Avatar
Member Avatar
+0 forum 1

I am using VB6 i am create Crystal Report File at run time using CreateReportOnRuntimeDS "p2smon.dll" API function. this function will connect the .ttx file to the report. now i want to connect another one. i am creating .ttx file is at run time using CreateFieldDefFile "p2smon.dll" API function. now i want to connect the second ttx file to crystal report. Report.Database.Tables.Add function is used to connect the ttx file to crystal report. but i dont know the sytex. Thanks.

Member Avatar
Member Avatar
+0 forum 1

Hi, I'm quite new with Data Adapter on VB.NET. I'm having a problem with retrieving data on different tables. Example database: [QUOTE][B]BookInfo[/B][INDENT]BookID: HSD993Z Title: Introduction to SQL[/INDENT] [INDENT]BookID: LDJA293 Title: Advance Computer Programming[/INDENT] [INDENT]BookID: KSKL194 Title: Object Oriented Programming[/INDENT] [B]StudentInfo[/B] [INDENT]StudentID: 2938485 FullName: Michael Zip[/INDENT] [INDENT]StudentID: 2949284 FullName: Ray Williams[/INDENT] [B]BorrowerInfo[/B] [INDENT]StudentID: 2938485 BookID: KSKL194[/INDENT] [INDENT]StudentID: 2938485 BookID: HSD993Z[/INDENT][/QUOTE] To get all the list of the Students who borrowed books, the query would be [CODE]SELECT StudentInfo.FullName, BookInfo.Title FROM BookInfo, StudentInfo, BorrowerInfo WHERE BookInfo.BookID=BorrowerInfo.BookID AND StudentInfo.StudentID=BorrowerInfo.StudentID;[/CODE] Now the Fill method on DataAdapter has a parameter of DataSet and SourceTable. I'm confused …

Member Avatar
Member Avatar
+0 forum 8

Error 2 'System.Web.HttpApplicationState' does not contain a definition for 'startuppath' and no extension method 'startuppath' accepting a first argument of type 'System.Web.HttpApplicationState' could be found (are you missing a using directive or an assembly reference?) E:\Report1\global\Default.aspx.cs 77 36 E:\Report1\global\ please help me.. i want to override the connection string of crystal reports which was connected by the database experts.. now i want to override with with new connection string .. the above error is diaplaying.. the following is my code if there is any mistake please correct me... its urgent please help me.... the code is.. [CODE]using System; using System.Configuration; …

Member Avatar
Member Avatar
+0 forum 1

I am trying to make a report which gets its data from a windows form's textboxes. My code works fine but upon display of the report, a window always appear asking to enter parameter values. How can I bypass or remove this window? Here is my code: [code] Dim report As rptVoucherReceipt = New rptVoucherReceipt Dim crParameterDiscreteValue As ParameterDiscreteValue Dim crParameterFieldDefinitions As ParameterFieldDefinitions Dim crParameterFieldLocation As ParameterFieldDefinition Dim crParameterValues As ParameterValues crParameterFieldDefinitions = report.DataDefinition.ParameterFields crParameterFieldLocation = crParameterFieldDefinitions.Item("parAmtWords") crParameterValues = crParameterFieldLocation.CurrentValues crParameterDiscreteValue = New CrystalDecisions.Shared.ParameterDiscreteValue crParameterDiscreteValue.Value = frmPremPay.txtAmtWords.Text crParameterValues.Add(crParameterDiscreteValue) crParameterFieldLocation.ApplyCurrentValues(crParameterValues) crParameterFieldLocation = crParameterFieldDefinitions.Item("parPayAmt") crParameterValues = crParameterFieldLocation.CurrentValues crParameterDiscreteValue = New CrystalDecisions.Shared.ParameterDiscreteValue crParameterDiscreteValue.Value …

Member Avatar
+0 forum 0

hi ... i've created one crystal report in windows form and one crystalreportviewer .. the following is my code.. in form1.cs file try { ExportOptions CrExportOptions; DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions(); PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions(); CrDiskFileDestinationOptions.DiskFileName = "c:\\csharp.net-informations.pdf"; CrExportOptions = cryRpt.ExportOptions; { CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat; CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions; CrExportOptions.FormatOptions = CrFormatTypeOptions; } cryRpt.Export(); } the above code is saving the file into pdf into specified path.. but i dont want to save a file i should get direct print preview and have a option to print .. As we do in web application using crystal report …

Member Avatar
+0 forum 0

hi... i've two crystal reports one is in D: drive name employee.rpt with 5 textobject and another report is in E: drive name employee.rpt with 15 textobject... now i want to write a program to overwrite the D drives report with E drives reports i.e i want to replace the 5 textobject with 15 textobject.. overwriting the reports while it is executing .. is there any code for it please help me.. its urgent..

Member Avatar
+0 forum 0

hi.. i've created one crystal report. and one global resource file .. in crystal report there's one text object with id Text1. and i want to take the values of resource file i've got it CrystalDecisions.CrystalReports.Engine.TextObject Dtemp1 = ((CrystalDecisions.CrystalReports.Engine.TextObject)myreport.ReportDefinition.Sections["section1"].ReportObjects["Text1"]); Dtemp1.Text = Resources.Resource.ResourceManager.GetString("Dsec1"); it is showing the correct value want i want but when i give print it is disappearing.. how to solve this please help me..

Member Avatar
+0 forum 0

hi.. i've created a crystal report and one crystal report viewer in windows form. i've two form form1 and form2 in form2 i've kept one button called print. when i press this button it should print the document into .pdf format. without using the crystal report viewers print button. please help me

Member Avatar
Member Avatar
+0 forum 2

hi.. i've one crystal report. i want the report header as "employee database". i dont want to right click->insert and goto text object and insert. i've one aspx page and aspx.cs page also. now i want the "employee database" header to be printed from .cs file. i dont want to pass by parameter also.. i.e is there any option in .cs file something like ReportDocument myreport = new ReportDocument(); myreport.Load(MapPath("~/" + "emp.rpt")); myReport.Reportheader="Employee database"; i hope u have understood this. only thing is from .cs file i want to print the header as employee database. i dont want by passing …

Member Avatar
+0 forum 0

hi.. i want to override the connection string of crystal reports.. is there any way that i use the connection string as shared datasource. MY PROBLEM BEGINS: i've 50 reports with the connection string vsspl-005\sqlexoress but i've changed my connection string vsspl-002\sqlexpress. there is only one way that i dont want to do i.e individually change the connection string of each crystal report using database experts.. is there any way that the connection string should be assigned as shared datasource.. or any other way.. Please please help me i'm trying this since from one week.. inform me whether it is …

Member Avatar
+0 forum 0

hi.. to all i've connected my crystal report to my database using database experts. now my problem is i want to display the total no of records.. in each page .. i.e in database there are 50 records when i execute.. it takes two page to print.. now in first page there are 30 records and in second page there are 20.. i want to display the value 30 at the end of page and 20 at the end of page. i.e how much the page contains the records that much it should print in page footer please help me …

Member Avatar
+0 forum 0

hi.. i'm using the database on live .. i may do hosting on different system and ip is changed.. please help me the below code runs well when i remove the ispostback condition.. but when i keep that when page is loaded it works well but when i give print the database is displayed which i've connected to the report using database experts... please i want to overwrite the connection string when i press print button also .. please can u add that code and make modification i dont know were to add that code. the following is my code …

Member Avatar
+0 forum 0

emp database(connection string vsspl-005\sqlexpress)employee database(connection string vsspl-002\sqlexpress) runtime employee database when i give print button emp database the above 4 fig display the problem.. please help me.. since i'm trying from last 4 days i've one crystal report which is connected to the database using database expert and connection string is vsspl-005\sqlexpress and i want to override the connection string to vsspl-002\sqlexpress.. i've writen the connection string in webconfig file it is working well.. for example. the report is connected to the emp database using database experts.. and the overriding string is connected to the employee database in webconfig file.. …

Member Avatar
+0 forum 0

hi... i've 50 crystal reports which is connected to the database directly without using any dataset.. and the connection string is vsspl-002\\sqlexpress.. now my problem is i've shifted the database to another location.. and my connection string is vsspl-008\\sqlexpress.. now i dont want to change the connection string for each report individually.. is there any solution that to change only once and it apply to all the reports... please help me it urgent....

Member Avatar
+0 forum 0

How should I create custom formula for specific field in crystal report? I have a field of result. It shows something like that PASS PASS PASS PASS or PASS FAIL PASS PASS Now I want to make a custom formula to show grand result. If that specific(result) field keeps all PASS value then it will show PASS there in grand result else it will show FAIL(If result field keeps at least one fail value.) I dont have enough idea about crystal report scripting so would you please show me example? I am just a beginner so please add example with …

Member Avatar
+0 forum 0

The End.