[crystalreport] Forum Topics

hi everyone can you give an example of coding in vb.net vs2010 how to make a report in crystal report 2013 with sub report thanks for advanced

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] …

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 = …

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 …

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 …

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 …

How to auto fit text in crytal report..

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 …

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 …

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 …

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 …

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

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 ?

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 …

[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]

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 …

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 …

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] …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …