[crystal] Forum Topics

Hi, I let say I use this code to retrieve date from database SELECT Table.Date FROM Table The format is 01/09/2013 (dd/mm/yyyy) How will i format this to get 09-Jan-2013 output then print this format to crystal report? I'm using dataset to connect data to crytal report I just noticed …

Hello people, I am new to crystal report. Normally, I would insert columns in the crystal report viewer and then look at the records at the Main Report Viewer. All the rows/records in that particular columns of that table will be shown. And then I found out about this SQL …

hi friends. i want to add a picture a picture in crystal report from database at runtime and show in crystal report using VB.VET . i'm using Microsoft access database, visual stodio 2010 and SAP crystal report 2010. please help me i m so abset.

hi i have following code in c# on button_click ReportDocument cryRpt = new ReportDocument(); TableLogOnInfos crtableLogoninfos = new TableLogOnInfos(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables ; cryRpt.Load(@"c:\users\shahaiali\documents\visual studio 2010\Projects\CrystalReportTesting\CrystalReport1.rpt"); crConnectionInfo.ServerName = "ShaHaiAli-PC"; crConnectionInfo.DatabaseName = "StudentInfo"; crConnectionInfo.UserID = "user"; crConnectionInfo.Password = "pass"; CrTables = cryRpt.Database.Tables …

This is my Exceptio on Run Time {"Could not load file or assembly 'file:///C:\\Program Files (x86)\\SAP BusinessObjects\\Crystal Reports for .NET Framework 4.0\\Common\\SAP BusinessObjects Enterprise XI 4.0\\win32_x86\\dotnet1\\crdb_adoplus.dll' or one of its dependencies. The system cannot find the file specified.":"file:///C:\\Program Files (x86)\\SAP BusinessObjects\\Crystal Reports for .NET Framework 4.0\\Common\\SAP BusinessObjects Enterprise XI 4.0\\win32_x86\\dotnet1\\crdb_adoplus.dll"}

Hi All, I would like to thank this community for the enormous help to develop my skills. Thanks. I have 2 databases and a single report form and a crystal reportviewer. The User can select the database which he want to work (Each of them belongs to different warehouse) So …

hi, frnds i am making a project on Grading System of school and i am using vb.net 2010 as my front end and SqlExpress as my back end . i have a Marks_Table in my database in which user stores student marks info . i want to generate marksheet on …

Hi! How should I get date, month & year in ascending order there in Crystal report? I have written following code there in my form to show report. Imports System.Data.SqlClient Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared Public Class Income_Sheet_Report Private Sub Income_Sheet_Report_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load cmbisrbdt.Items.Clear() …

i am trying to get crystal report of my Marks_master Records From Table . I tried Following Code But It is Giving Me Exception As : System.IO.FileNotFoundException was unhandled Message=Could not load file or assembly 'file:///C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet1\crdb_adoplus.dll' or one …

Creating a Report in Visual Studio 2008 In this section, you create a report that draws its information from the sample Microsoft Access database that ships with Crystal Reports. To create a report with secure data from the Your database follow these steps . 1. In Solution Explorer, right- click …

i have two MySQL tables with the following structures CREATE TABLE tbldepartments ( departmentID TINYINT( 2 ) UNSIGNED NOT NULL AUTO_INCREMENT, department VARCHAR( 20 ) UNIQUE NOT NULL, PRIMARY KEY ( departmentID ) ) and CREATE TABLE tblemployees ( employeeID SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT, departmentID TINYINT( 2 …

The employees of our company are using an India Cash Program application that displays records and data according to search criteria and also genertes reports.It is built using VB6.0,sql server 2005 and crystal report 8.5 .The application is used daily from an .exe file that is installed on all computers.The …

hello i am trying to use selection formula with crystal report viewer i write the formula in string and set it to crystalReportViewer1.SelectionFormula here whe i use this formula " {Customer.LastYearSales} > 11000"; it said a string is required here & when i change it to this " {Customer.LastYearSales} > …

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

hi to all I have list of names in list view with corresponding unique employee id. The user could select more rows. In each employee id I will find it in database in retrieve all the details information and print it using crystal report. What I want is in each …

Hi, I am trying to eliminate crystal reports duplicates. For some reason, the same record showed 18 times!!!! Craziness!! I tryed to create groups, to check suppress if duplicates .. but nothing happened!! Plz help!

Hi, I am using vs2005 with access 2003. In my windows application there is one tabcontrol which contains 2 tabpages with 2 crystal report viewer for each one. I have loaded data in form load event. It works great. Unfortunately the 2nd tabpage is not displaying the crystal report toolbar. …

i have vb 2005 express edition. so i dont have crystal report. now i want to print some data from the form to paper. so can anybody help me to print those data

Hi All, I am well in Access Reports but in crystal reports just i am learning. I am using visual basic 2005 and access 2003 database. The report development in crystal, I am struggling and searching a long time but there is no useful tips. My database has more tables …

Logon failed. Details: crdb_adoplus : Object reference not set to an instance of an object. Error in File C:\Users\puy\AppData\Local\Temp\temp_30b1c203-656f-4baa-bcf0-1f3973082664 {7558C8AA-A85C-410E-993A-CA4CCADB14E6}.rpt: Unable to connect: incorrect log on parameters Please help me:( using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Data.SqlClient; using System.Drawing; using System.Data.Common; …

Im running an accounting package using crystal reports. all my fields are coming from the table except the totals. the problem is i have a running total where the **total income**-**the total expenditure = net income** for each month. the problem is that the opening balance is supposed to be …

hi everyone, can some one tell me how i can generate a crystal report dependeing on some sending value from datagrid view, or there is a method to do to filter my report, i dont knowhow to do.. thanks before

i was trying to fill my conninfo to apply it to repdocument help!

hii all, i hope everyone is ok, can someone tell me why my crystal report dosesnt show any of my data. Best regards

Hi I am wrinting a program which takes customers details and their order details, each order line is added to a DGV and eventually saved to a MDB, a Crystal Report Viewer than queries the information back and displays it in the format I setup in the report i created, …

my report show this way: surname 1 firstname1 middlename1 surname 1 firstname1 middlename1 surname 1 firstname1 middlename1 surname 1 firstname1 middlename1 surname 1 firstname1 middlename1 surname 2 firstname2 middlename2 surname 2 firstname2 middlename2 i want to display my those records this way surname 1 firstname1 middlename1 surname 2 firstname2 middlename2 …

i cant seem to see the crystal report in the add new item

Hello, Guys i am working on a little project using C# & Ms Access, where i need to print some reports,there are few things i need to ask:- 1) is there any way to print reports other than Crystal Reports 2) i tried using crystal reports all things are kind …

I have a query regarding On Demand Report in Crystal Report Visual Studio 2008 I have seen queries on this topic but didn't find any solution or i didn't understand the solution. I m asking again pls help me I have a main report having a subreport as a On …

hi! i want to include a pie chart in my report! i have a file called inquiries in sql server 2008. the file contains Inquiry Number,Name,Date,Telephone,Email and status. The status contains information from where the customer got to know about a particular product(i.e newspapers,Friends,T.v etc) i want to generate a …