i am using Access 2003 and vs2005,i am trying to add data to my crystal report from my access database,ok. So to do this i followed these steps: Now after all these steps,how to add the column names of the table "Table1" in my crystal report?
View 11 Repliesi have done my application that uses crystal report and access database. I try to publish the application but when install on client machine, it wont work. the access database wont load and so the reports. What should i do?
View 9 RepliesI am having problem with the connection between an access database and crystal report. I created a crystal report by using wizard, all working go, but when I run the program in another computer am getting some error on path..wrong path for the database. So I need to find a way to connect database with the crystal report using a relative path...
View 1 Repliesdynamically passing image to crystal report from a disk in vb.net 2005
View 1 Repliesi am using a local database i.e,the sql server express that comes with the vs2005,dont have any sql server additonally installed in my pc.
whice creating a crystal report,first this comes:
on clicking next,this comes:
then i selected and click next,then this comes:
but it did not show the database(Database1.mdf) which i created in my local database.
then how to create the crystal report when i am using a local sql server express database?
which options to select from the images that i showed above?
I m using .net , I create some temporary tables at run time, how to print these table data thru crystal report
View 1 RepliesI am trying to build a setup file which will install my vb.net application with database and crystal report files to the client.
1.) I created my vb.net application in release mode.
2.) I created new setup project and added my vb.net application project in that solution.
3.) Also added the primary output in application folder
4.) [dun know how to add database so] created app_data folder inside the application folder and added the database file manually from add->file
5.) [dun know how to add crystal reports so] created reports folder inside the application folder and added the reports manually from add->file
6.) Build solution.
7.) Tried deploying in client machine.
8.) Application runs fine and works great. But crystal report files doesn't. When i try to open crystal report some long error messages comes in my way.
So I would like to know is the way i am doing to add the database file and crystal report files correct? how can i make crystal reports work in client machine?
How to create a crystal report in vb.net 2005 using data source wizard.
View 1 RepliesI have loaded the rows data of a datagridview into a datatable object but I am not aware how to show them in crystal report.
View 3 Repliesi just want to ask if you know any links regarding Crystal Report Tutorial, Or Video Tutorial of it that will teach on how to create a Crystal Report. If someone who can teach me on how to create it then it would really be fine for me.. Im looking for hard coding not just using the connection properties. I want to know on how to connect the crystal report to a database and gets all the data that I need and displays it. Designing the crystal report. Using TSQL if possible.
View 4 Repliesi just want to display data's from mysql database to crystalreport and i need codings
View 1 RepliesI have the following code.
Private Sub genWorkOrderCompForOneCustomer()
If customerNameComboBox.Text = "Please Select a Customer" Then
MessageBox.Show("Please select a customer to create a report for.", "Error",
[Code]....
When I run the the application I am not getting the current information from the sql database until I hit the refresh button and enter the parameter. I would like the information to be up to date when first loading the application.
how to get the updated database data and print into crystal report using VB.net?
Dim rpt As New CrystalReport1()
Dim myConnection As SqlConnection
Dim MyCommand As New SqlCommand()
[Code].....
<Visual Stusio 2005 visual basic / Crystal Report 2008>
I simply created a "Report" folder on the the project and "crTxEmpMaster.rpt" is created on the "Report" folder.I tried load a .rpt file for Crystal Report, but it occured "Load report failed" What is wrong wth it? #1 and #2 both failed.
Dim menuReport As New ReportDocument()
'#1
Dim reportPath As String = Application.StartupPath & "" & "ReportcrTxEmpMaster.rpt"
[code]....
I'm having a problem with my crystal report with regards to report footer. I want to display the data from the table, column name "Remarks" in report footer but when I try to call the data it doesn't show the remarks. I'm using VB 6 and mdb files as my back end. Is there any command or fundamental that I've missed?
View 1 RepliesI need advise on how to solve this scenario. I am not sure whether I should use any Report Application such as Crystal Report or I can just simply use datagridview.My scenario:In a new form, a table will show a least 3 columns.
First, ItemID
2nd, Total Quantity Sold for the Current Month
3rd, Total Quantity Sold: Last month
ItemID Current (Nov) October
ABA1 100 85
ABB1 80 90
Hence, I can compare the figure of the current month with the past few month.Right now, I do not have any problems building SQL_String for calculating the Total Qty Sold for the Current month and display it via DataGridView. But I am not sure how to additional column that calculate the Total for the past few month
I am trying to convert a VB6 Data Report (.dsr file) to a Crystal Report through the migration process within Visual Studio. I have read articles that reference adding a Data Report to a Project from Visual Studio 2005/2008 and that it will convert the Data Report to a Crystal Report, but I have not been successful in doing so. Does the VB6 Data Environment need to be converted too? Has anyone been able to do this successfully and if so, how?
View 1 Repliesi have probleam with my reportviewer, After i generate my report it only show 1 row from my database, My report also to big which is width until need 2 page . Any advice how i can generate all data in my database using reportviwer.and how i can resize my report. For you info i use visual studio 2005 and sql 2005. I also attach here the picture of the report and my database contain
View 3 RepliesInstead of loading a crsytal report from a path like this:myCrystalReport1.Load("C:Program FilesAstec IndustriesPlantDailyShiftReport.rpt")Is it possible to include the crystal report in the solution and load it from there? I've used this is asp:
Dim myPath As String = (Server.MapPath("PlantDailyShiftReport.rpt"))
myCrystalReport1.Load(myPath)
I have a Crystal Report that I am trying to access thru my VB.Net app. My problem is that I keep getting a "Database Logon" prompt (see screenshot). My code is below and I think I might have more than I actually need. I created the report from with the VS 2008 IDE.
Private Sub rptSingleWorkOrder()
Try
strSQL = "Select A.productName, " & _
"A.productDesc, " & _
[code]....
By the way, this code runs cleanly completely thru from the time the procedure is called until it exits.
how to make a crystal report in Vb.net using ms access as your back.end The purpose for this is about my project i think it's better to use a crystal report rather than to command another application for viewing your file right? ^_^
View 1 RepliesI'm trying to add a Crystal Report to a VS 2005 VB project.Here's what I do: Right-click on my project, Add -> New Item Crystal Report Add a report with the standard report wizard (or just a blank report
[Code]...
UPDATE: OK, something's really screwed up. When I inspect the Me object above, it isn't even putting out the kind of object I expect. I think I may need to piece together the solution again.
I decided to learn reporting in visual basic .net 2005 but I didn't know what version of crystal report to be used. I've heard that we must use appropriate version for different Visual Studio. Can you please give me the exact version for VS 2005 and 2010?
View 1 RepliesI'm facing one problem with crystal report viewer. which is developed .net 2005 as class library.
myCRviewer.dll
Registered this dll using Regasm as follow:
C:WINDOWSMicrosoft.NETFrameworkv2.0.50727
[Code]....
Calling method from myCRviewer.dll via referenced this .tlb in VB6.0 working perfectly where ever .net 2005 installed machine. But it is not working if .net 2005 not installed machine.
am a beginner in vb.net 2005 i have to generate a crystal report in vb.net from a textfield that the user enter and the following report should be generated depending on that query..
View 1 RepliesI am using a Crystal Report in my application to display an Invoice. For this, I take the 'Invoice No' as input from the user. I was wondering if I could display multiple invoices on different pages of the report by taking 'From Invoice No' & 'To Invoice No' as input form the user.
View 6 RepliesI have a strange problem on one of our agent's pc. He can view a crystal report fine on his machine, but he can't export the report to pdf, or excel etc. even tho he has the programs installed. He is just missing the export button on the report viewer. On all the other agents pcs, the button is there. And on mine as well.
Any ideas what dll's i need to register on his pc ?
i made 2 reports but when i execute report so is always ask for username and password. please assist me that how to execute reports directly without inserting everytime username and password?
View 8 RepliesAnyone who give me a reference how to query the sql to SAP crystal report?
View 2 RepliesIam workin wid crystal reports have a problem i jus want to create a crystal report dynamically not by using crystal report wizard rather by using a blank crystal report and connecting to the database server and generating the report from the database manually....
View 1 Replies