Member Avatar

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 …

+0 forum 0
Member Avatar

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

+0 forum 0
Member Avatar

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 …

+0 forum 0
Member Avatar

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 …

+0 forum 0
Member Avatar

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..

+0 forum 0
Member Avatar

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..

+0 forum 0
Member Avatar

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 …

+0 forum 0
Member Avatar

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 …

+0 forum 0
Member Avatar

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 …

+0 forum 0
Member Avatar

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 …

+0 forum 0
Member Avatar

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

+0 forum 0
Member Avatar

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....

+0 forum 0
Member Avatar

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 …

+0 forum 0
Member Avatar

I know how to make grand total in crystal report. But I dont know how to get grand result. For example my crystal report will show student`s result. Let me make it clear to you. [Code] STUDENT ID SUBJECT ORAL MARK WRITTEN MARK TOTAL MARK RESULT DEN10101 ENGLISH 40 40 80 PASS DEN10101 COMPUTER 44 44 88 PASS DEN10101 GAME 20 20 40 FAIL [/Code] How should I get grand result. If one will fail in one subject grand result will be faill. If one will pass in all subjects grand result will be pass. It will something like that …

+0 forum 0
Member Avatar

Hello Everyone I need some expert advice on this problem that i have, i been trying to google this issue but still no luck. Im using VB 2005 and the Crystal Reports that come with Visual Studio 2005. I have a "Purchase Order" program that im trying make my company use to reduce cost and save paper. So what my report does is print the "Providers Info and Details of what we need", so the program makes only one print of the report on a 8.50x11in page, so what i want to perform is to make 2 copies of the …

+0 forum 0

The End.