I have two forms the first FrmRecipe.vb form has all my calulations and functions in it the second FrmReports has a crystal report viewer with loads of reports. I am trying to call the report as a thread so that the main from is still working however when the treads are complete my application closes I am calling Me.BeginInvoke(New MethodInvoker(AddressOf FrmReports.PrintMasterFormulationToprinter)) Can anyone point me in the right direction?

Member Avatar
Member Avatar
+0 forum 3

Hi! I'm developing an application for hospital patients information. Now, as common for hospitals, I need to add a feature for various reports.Now I would like to know if you think Crystal Reports are a good option still. I would like to present many reports which a user will choose what he wants and click "generate", the report is to be presented to him and should allow him to print the report. I ask you to please share your experience,Is Crystal Report the BEST choice here? (I'm used to display many short reports just in DataGridView but I think I …

Member Avatar
Member Avatar
+0 forum 8

'------------------------------------------------------------------------------ ' <auto-generated> ' This code was generated by a tool. ' Runtime Version:4.0.30319.17929 ' ' Changes to this file may cause incorrect behavior and will be lost if ' the code is regenerated. ' </auto-generated> '------------------------------------------------------------------------------ Option Strict Off Option Explicit On Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.ReportSource Imports CrystalDecisions.Shared Imports System Imports System.ComponentModel Public Class CrystalReport1 Inherits ReportClass Public Sub New() MyBase.New End Sub Public Overrides Property ResourceName() As String Get Return "CrystalReport1.rpt" End Get Set 'Do nothing End Set End Property Public Overrides Property NewGenerator() As Boolean Get Return true End Get Set 'Do nothing End Set End Property …

Member Avatar
Member Avatar
+0 forum 1

Hi, I have installed CR 8.5 and VB6. prepared one small prog. Now want to add CR control in VB toolbox so as to drag the same in vb form where I have to write code to print. So how to get the control please.

Member Avatar
+0 forum 0

I’m going to use main report and sub report for showing some details. Main report has InvoiceHeader Part and sub report has invoice detail part. Invoice Header and invoice detail has 2 SPs. SP_InvoiceHeader (Use for main report) ALTER PROCEDURE [dbo].[testSP1] @invnoH as varchar(20) AS BEGIN SELECT * FROM INV_HEADER WHERE INVNO=@invnoH END SP_InvoiceDetail (Use for sub Report) ALTER PROCEDURE [dbo].[testSP2] @invno as varchar(20) AS BEGIN SELECT * FROM INV_DETAIL WHERE INVNO=@invno END I create the main report and using Insert --> subreport I just add a sub report. Both reports are used above SPs seperatly. I just can pass …

Member Avatar
+0 forum 0

Hi Guys I have my Asp.net 4.0 application,it has crystal report viewer, that viewer object is not visible at run time on win 8.1 beta version and microsoft windows 2008 server, but it works fine on my persoanl pc which runs windows 8 , any idea on what is the reason ? thanks regards sumith

Member Avatar
+0 forum 0

Can anybody where i can find :crystal reports for visual studio 2012

Member Avatar
Member Avatar
+0 forum 1

I hav two tables sales (sa_no,sa_date,cu_id,total) ladger(ledger_id,cu_id,payment,payment_date) I want to display the transactions of a customer (cu_id) in one crystal report in the order of dates ,such as sa_no sa_date total ledger_id payment payment_date ie one row from sales then one row from ledger for the customer cu_id Please help me , I hav been trying for a week to solve this.

Member Avatar
Member Avatar
+0 forum 1

I am creating crystal report in ASP.NET and C#.I am creating a crystal report.All are going fine if I give textbox for search parameter but when I give combobox for search parameter then it does not generate report.Data does not come into DATATABLE.Where I am doing wrong? sql = "select Fund_Allocation.ProjectID,Fund_Allocation.HeadType,Fund_Allocation.GroupName,Fund_Allocation.SubGroupName,Fund_Allocation.Name,Fund_Allocation.FundID,sum(DISTINCT(Fund_Allocation.amt)) as total,sum(DISTINCT(File_Sanction.FundAllocated))as Booked,sum(DISTINCT(File_Purchase.BillAmt))as Expenditure from Fund_Allocation LEFT JOIN File_Sanction on Fund_Allocation.FundID=File_Sanction.FundID left join File_Purchase on Fund_Allocation.FundID=File_Purchase.FundID where Fund_Allocation.ProjectID = '" + ComboBox2.Text + "' AND Fund_Allocation.FinacialYear='" + ComboBox1.Text + "' AND Fund_Allocation.HeadType='" + ComboBox3.Text + "' AND (File_Sanction.SanctionDate>='" + TextBox4.Text + "' AND File_Sanction.SanctionDate<='" + TextBox5.Text + "' or …

Member Avatar
Member Avatar
+0 forum 2

Please help me why do I get this error. Thank you!

Member Avatar
Member Avatar
+0 forum 2

Hello, I have created a report using SAP Crystal Report on Visual Studio 2010. As datasource, a interal dataset is used to populate the report which is included in my project. Everything seems to work fine until during runtime when I load the report onto the report viewer, it keep telling me to end a username and a password when I using a dataset that has no form of security nor authentication. I've found older posts and tried multiple suggestions but no luck. I've have posted my codes and what I've tried so far. I would appreciate your help. my …

Member Avatar
Member Avatar
+0 forum 2

hi I'm having problems in my crystal report where all the selected rows in my datagrid will show up in my crystal report but instead it showing me an exception selectcommand.connection has not been initialized here's my code in my form where the datagrid is: Dim cmd As OleDbCommand = New OleDbCommand("SELECT Data1.ID, Data1.DateFile as [Date File] , Data1.Plate as [Plate #], Data1.Driver as Driver, Data1.EmpID as EmpID, Data1.OdometerBefore As [Odometer Before], Data1.OdometerAfter As [Odometer After], Data1.Gas as Gas, Data1.CostofGas as [Cost of Gas] FROM Data1", con) con.Open() adpt = New OleDbDataAdapter(cmd) 'Here one CommandBuilder object is required. 'It will …

Member Avatar
Member Avatar
+0 forum 2

Hi all, I have installed SAP Crystal report for Visual Studio 2010 successfully on PC(.NET4.0, Windows Vista, Visual Studio Ultimate 2010). Now When I am going to add rpt file in my existing project, It automatically create .mht file and not .rpt file, that .mht file containing instructions and link to install SAP crystal report which I have installed already. Anyone can tell me, what I have to do to create an .rpt file to generate Crystal Report?

Member Avatar
Member Avatar
+0 forum 2

hi guys , i am buliding the application using vb.net vs2010 ,mysql server workbench 5.2 . it works fine about the database connection and inserting and all sql operation with the mysql but now the problem is that unable to make the crystal report using that mysql it not supporting the connection of the database (table) to report it .plz help me solution for this problem any one have idel how to report it r connection with the report to mysql database ......

Member Avatar
Member Avatar
+0 forum 1

I was here looking for a solution that I didn't find, but have since figured it out so I thought I'd post it as I doubt I'm the only one who has had the need. The issue is - How do you have Crystal print to a 'Named Printer' without resetting the Windows Detault Printer, in other words - my default printer is a workgroup laser, and I also want to print to a small thermal label printer. The OCX provides the appropriate properties to do so, but it isn't just setting the Named Printer. Per Crystal Help, you have …

Member Avatar
+0 forum 0

I want to try to show barcode in crystal report and print it on a printer through a crystal report, there is of a friend who can give me an example of a small program thanks in advance

Member Avatar
+0 forum 0

Friends .. how my code working fine with two buttons (PDF and RTF) but the last portion for HTML converting its not working .. please help Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared Imports System.Diagnostics Imports System.IO Public Class Form1 Dim myReportDocument As New ReportDocument Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load myReportDocument.Load("d:\test\S111.rpt") CrystalReportViewer1.ReportSource = myReportDocument CrystalReportViewer1.Refresh() End Sub Private Sub BtnText_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnText.Click Try Dim CrExportOptions As ExportOptions Dim CrDiskFileDestinationOptions As New DiskFileDestinationOptions() Dim CrFormatTypeOptions As New PdfRtfWordFormatOptions CrDiskFileDestinationOptions.DiskFileName = "d:\test\check.pdf" CrExportOptions = myReportDocument.ExportOptions With CrExportOptions .ExportDestinationType = ExportDestinationType.DiskFile .ExportFormatType …

Member Avatar
Member Avatar
+0 forum 2

hello Everyone I am facing problem in Crystal reports in SelectionFormula Line. When I generate the Report it says A NUMBER IS REQUIRED HERE . I have tried many things converting to strings to integer but no luck. Any help will be appreciated. My Code for the Report is below.. pendingorderreportviewer por = new pendingorderreportviewer(); rptpendingorders rpt = new rptpendingorders(); DataSet1 ds1 = new DataSet1(); salesTableAdapter.Fill(ds1.sales); sale_detailsTableAdapter.Fill(ds1.sale_details); rpt.SetDataSource(ds1); por.crystalReportViewer1.ReportSource = rpt; por.crystalReportViewer1.SelectionFormula = "{sales.invoice_no}='" + comboBox1.Text + "'"; por.Show(); invoice_no in the sales table is int. thanks in Advance

Member Avatar
+0 forum 0

I'm trying to display a Report with Crystal Report Viewer, in the Design looks fine, but it doesn't seem to load when I enter the website... <form id="form1" runat="server"> <CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" AutoDataBind="True" GroupTreeImagesFolderUrl="" Height="1202px" ReportSourceID="CrystalReportSource1" ToolbarImagesFolderUrl="" ToolPanelWidth="200px" Width="1104px" /> <CR:CrystalReportSource ID="CrystalReportSource1" runat="server"> <Report FileName="ReporteReciboFecha.rpt"> </Report> </CR:CrystalReportSource> </form>

Member Avatar
+0 forum 0

Hi, Im working on a project in asp.net with C#, I have done a report (using Crystal Reports) but I can't find a way to show it in my site. I create a new .aspx which has a Crystal Report Viewer (connected with the Report previously created) and I have a button which opens this .aspx file protected void btn_Recibo_Click(object sender, EventArgs e) { Response.Redirect("ReporteReciboFecha.aspx"); } But when I click in the button it does redirect me to the aspx form, but it stays in white, it doesn't show anything.

Member Avatar
Member Avatar
+0 forum 1

I have an application, i'm using C# wtih asp.net I need to generate reports with my database (mysql), so I downloaded Crystal Reports. I'm trying to make the connection between Crystal Reports and my database, for that I've Add the User Data Source (MySQL ODBC 5.1 Driver) in the ODBC Data Source Administrator. That works fine, the Test Connection with my db is succesfull. The problem is, that when I try to add the Data Source in Crystal Reports, I select the data source, fill the connection information and when I click FINISH, this error shows up: *ERROR [IM014] [Microsoft][ODBC …

Member Avatar
+0 forum 0

Make Setup Of Project Then Crystal Reports Keeps Old Database Path When i make Setup of my project then my crystal reports keeps old database path how can i resolve it please help me.

Member Avatar
Member Avatar
+0 forum 1

i have the following code in my php script. it's for displaying a Crystal Report file. $cr = new COM( "crystalruntime.application" ); if ( $cr ) { $cr->OpenReport( "SelectExpert1.rpt", 1 ); } if i try to access the file with this code on my browser i get the following error. Fatal error: Uncaught exception 'com_exception' with message '<b>Source:</b> Crystal Reports ActiveX Designer<br/><b>Description:</b> File not found. Details: error' in C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\moonlight\idtest.php:5 Stack trace: #0 C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\moonlight\idtest.php(5): com->OpenReport('SelectExpert1.r...', 1) #1 {main} thrown in C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\moonlight\idtest.php on line 5 what could be the solution …

Member Avatar
Member Avatar
+0 forum 6

Hello! I'm trying to fill a Crystal Reports in a generic way. This is because I don't have direct access to the database, I just call a service that returns a DataTable. I'm no expert in C# or Crystal Reports, is there any way to fill a Crystal report without knowing the columns I'm receiving? This is what I've tried so far: dt = new DataTable(); dt = getData(); var rpt = new ReportDocument(); rpt.Load(@"CrystalReport1.rpt"); rpt.SetDataSource(dt); crystalReportViewer1.ReportSource = rpt; var paramFields = new ParameterFields(); var paramField = new ParameterField {Name = "col1"}; var paramDiscreteValue = new ParameterDiscreteValue {Value = "Descripcion"}; …

Member Avatar
+0 forum 0

hii i am stuck with a problem as i am using VS 2010 and developing an app in vb.net. i require crystal report so i downloaded from SAP the exe and installed but i cannot find the crystal report menu in add new item of right click of application so i cannot create crystal report and i can see crystal report viewer in toolbox...so please help me fast to over come this problem...

Member Avatar
Member Avatar
+0 forum 3

hello, i am trying to enter the form textbox.text in my crystal report, but getting error. code is Dim RptForm As CrystalDecisions.CrystalReports.Engine.ReportDocument Dim T As CrystalDecisions.CrystalReports.Engine.TextObject RptForm = New CRrollnumberba1 T = RptForm.ReportDefinition.Sections(0).ReportObjects("?SUBJECTNAME") T.Text = txtsubject.Text the error showing "Index was outside the bounds of the array." at 4th line. and when i change the name of crystal report textbox name Dim RptForm As CrystalDecisions.CrystalReports.Engine.ReportDocument Dim T As CrystalDecisions.CrystalReports.Engine.TextObject RptForm = New CRrollnumberba1 T = RptForm.ReportDefinition.Sections(0).ReportObjects("SUBJECTNAME") T.Text = txtsubject.Text i am getting error-Unable to cast object of type 'CrystalDecisions.CrystalReports.Engine.FieldObject' to type 'CrystalDecisions.CrystalReports.Engine.TextObject.please help me for this.............

Member Avatar
Member Avatar
+0 forum 1

I created a Crystal Report and added few text fields and database fields in it. But in report preview section, only report header and page header is visible. Details section is not visible at all. Plzz help.. ![8dccf3f1cd9578565f563b200a56fcc5](/attachments/large/3/8dccf3f1cd9578565f563b200a56fcc5.png "8dccf3f1cd9578565f563b200a56fcc5") ![c0e34b6d7fb3137bbb5d029330f38b44](/attachments/large/3/c0e34b6d7fb3137bbb5d029330f38b44.png "c0e34b6d7fb3137bbb5d029330f38b44")

Member Avatar
Member Avatar
+0 forum 1

Hello i encounter a error on my crystal report. I don't know to fix this. Can you help me? thank you

Member Avatar
Member Avatar
+0 forum 1

How to display image or picture from database to crystal report.In database i have only picture name.n picture are store in folder.

Member Avatar
Member Avatar
+0 forum 2

Hi, im using crystal report on my project. It working very well but I just want o make it more flexible. I have textobjects with of course text in it. They are not bound since they are just additional information on my report. How can i make those textobject editable during runtime? Something like on mouse click, i may able to edit it like in what we do in design? do i need to add program in my project? Im using vb.net 2010 I use this code to call my report Dim sett As New DataSet1 Dim oRpt As New …

Member Avatar
Member Avatar
+0 forum 5

The End.