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

Dear All i am developing .Net Application with MS Access and Crystal Report i am using DSN for crystal report to view the data from database. on each new client i have to go there to make DSN and then crystal reoport work, my application forms using database through physical …

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

Hello Friends, I Developed application in C# with crystal reports and created setup file in third party (Advance) Installer.When i installed my application on client system application is working but when i click on report it dosent work and generates error :System.TypeInitializationException: The type initializer for 'CrystalDecisions.Shared.SharedUtils' threw an exception. …

hye Friends, I installed my c# app. with crystal reports , all is fine but when i want to generate crystal report , rises DATABASE LOGON dialog box. and asks Log ID and password.. Please, help me....

Dear Frien, I am working in C# .... I nedd Help/.] I created FROM1 which has DATAGRIDVIEW and fetched data from Database,and on the Form2 has Crystal Report Design , how can transfer data from Datagrideview of FORM1 to Crystal Report of FORM2.......... Code is bellow-: private void btn_CrtRep_Click(object sender, …

I am new in reporting with crystal reports. i am trying to genrate a report in vb.net. My data to be displayed in the report is based on a screen output. But I don't know how to bring the data from screen to report. Please help me any one so …

Hi to all experts, i have a big problem here, i want to print data from my datagridview, when i select 1 row.. there is no problem, but when i try to print multiple row, just first selected row appear here is the code : private void button4_Click(object sender, EventArgs …

I have a table `tbl_mdcl` which show the sale details. I got the `tbl_mdcl` data using: SELECT TOP 1000 [Invoice_No],[Invoice_Date],[CustomerId],[Med_Name],[Comp_Name],[Date_Manaf],[Date_Exp],[Qty],[Price],[Discount],[Retail] FROM [MMIS].[dbo].[tbl_mdcl] Following is the result of query: http://i.imgur.com/51seVlK.jpg To gather and report a monthly report using the above table ,i created a new CrsytalReportViewer and set its datasource to …

AOA, I m using VB6 as front end and MS ACCESS 2010 as Database (DAO recordset) , I have created some Parametric queries in Access and also created some Crystal reports based on those queries, all this work find in designe mode, but when i compile the project and make …

How to attached Crystel Report to Window form??

I am fairly new to crystal report and I need a help. I have a report having two groups,project id and work_item. And I placed 3 sub reports material,labor and equipment reports in the work item group. They pass a value to the main report that is used for further …

[QUOTE]guys, i need help on passing multiple values in a parameter field in crystal report viewer, I already set it to allow multiple values. When the code below executed it only displays the last record and not all of the records that appeared. here's my code. hope you help me …

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 have small issue with my datagridview and crystal report I am using this code for display my crystal report but my problem is I can display only one row from data grid view But I want to print all rows randomly selected from datagridview in crystal report Private Function …

hi I have create windows application using visual Studio 2010, every things goes will, but I have problem with display crystal reports in arabic language. on my pc every things working and showing reports very will in arabic language, but when i create setup project and .exe file then install …

Greetings, I'm using a crystal report and using it to make a sales report and I want to sort the reports displayed based on the date of the sales order what I should do I create a parameter field and its type is Boolean what else I should do what …

Hi all I just started using Crystal reports in vs2010. I have created a Dataset in the Designer and pulled data from an access DB. The dataset is being populated fine. My Issue is when I assign the dataset to crystal database expert and drag the columns to the report …

Hi all, I had a little problem when deploying an application having crystal reports as a reporting tool on a client pc. It works so well in my dev pc even installed.Since i'm using Access 2007 i used Microsoft.ACE.OLEDB.12.0 provider. I haven't provided any password or username for the database.But …

Hi guys I'm having problem in crystal report where my inner join is a success but of my 3 fields that are affected dowsn't show up. The values from 2 tables that match is showing on the crystal report but the 3 fields that has a match doesn't. Tried inputting …

I'm using VS 2010 professional with SAP crystal report. And I have an windows form application for displaying some crystal reports. This is working well and good in the system I'm have developed it but, when I set this project to run in setup mode or in other machine then …

Hi! I using Crystal 9 in Visual Studio 2010. When update database field I got this error "crdb_adoplus.dll cannot load ". I have downloaded crdb_adoplus.dll but I don't know where to place this dll.Any idea?

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 …

how loop subreport in one report on crystal report using aspx

hi!, guys I want to make a daily time record in crystal report but I did not know how to do?, can you help me please?

Hi Everyone, Can I ask your Suggestion/Help about this query. I am using the Crystal Reports in C#, I want CR to call in MenuStrip(Menu). Every time that I run the main form of my system. I want to call the the CR in menu. My Menustrip calling for FORM, …

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 …

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 …

Hello everyone, am doing a small project and i need to use crystal report with MS access. i did the connection by wizard but now am having problem with the path when using it on another PC. What i need to know is how to connect Crystal report with access …

I'm completely clueless to this as I have never used crystal reports before. So I want to use a textbox to pass values into my crystal report so basically only those I inputted into my textbox will be read and be outputted into my crystal report. Here is my code …

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 …

Hi! I am using crystal report to make my report. But problem is that I cant use same SQL Command there in report parameter because its different. I am going to show you my code so that you can understand it. I have a report & a form where I …

Hi friend , I am new in programming. I am having a table named as bill and i wanted to generate crystal report for invoice purpose,and report will contain Sr.No,ProductName,Weight, Rate, Total ,VAT and a final GrandTotal as final amount sum of the Total of multiple product.Bill will be generating …

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

Hello All, How to hide show section columns in crystal report based on condition?? e.g.if my report "Rpt" have col1, clo2, clo3 i want to show when i click on Rpt1 it will show col1, col3 if i click on Rpt2(any link) it will show col2, clo3. i dont want …

Hi guys,i was using crystal reports in my vb.net project.I read in some books and in the internet that you can create a grand total for some fields like total cost calculation.And using 'sum' you can calculate the total result.well in my case i can't find 'sum' in my crystal …

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 …

I am back with another question. hoping again you people help me out on the thing that i am going to ask you over here. I am developing Crystal report in 2008 with c sharp. But the issue is that as soon as report is about display it simply asks …

How I can print a ticket as seen here http://www.freeimagehosting.net/image.php?ec42ef6c3e.png using crystal reports?

Few years back i developed a project in VS 2003.Today in that project i was trying to add a new report. however after adding the report page, i am getting an error prompt that is Failed to open Document with the title of Crystal Reports Activex Designer. Also VS is …

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.

i want quantity * weight (both column's total) in the textbox in crystal report. the data should retrive from sql database and should display in crystal reports.

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

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 …

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 …

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

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

 Hi to all... I am getting an error Load to fail report in my c sharp crystal report application. the error is some what like below mentioned. CrystalDecisons.CrystalReports.Engine.LoadSaveReportExceptio: LoadReport failed. also find the attachement of the error message that i got .... Any help will be greatly apprecaited... …

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 …

Hi all, Can anyone help me? Or guide me to solve this error. I get an error like this when I run my crystal report. Your help is appreciated. "A string required here. Error in File C:\DOCUME~1\COUNTER\LOCALS~1\TEMP\temp_ebfc56a7-f48a-46b4-9335-709e5682573c{E5F4DBBE-6BE3-4C08-A7A8-63F7769CC81C}.rpt: Error in formula <GroupID>, 'stringvar ID := {Consignment_Sales_Report.GroupID}; ' A string required here." …