I want to be able to programmatically add or remove database fields in my crystal report.I am familiar with programmatically working to parameters but not with database fields, I just can figure out how to programmatically do what you do in the Database Expert.
View 1 RepliesI want to ask how to display the fields in Crystal report from different tables. I have this line of code:
[Code]...
I have the following SQL Expression Field in my Crystal Report 11.5
{fn CONCAT({fn CONCAT("SPR_PRODUCT"."PRODUCT_ID","SPR_PRODUCT_SUB_ITEM"."P_SUB_ITEM_ID" )},{fn CONCAT("SPR_PRODUCT_ITEM"."P_ITEM_ID","SPR_PRODUCT_GROUP"."P_GROUP_ID" )} )}
It works well in the Preview Mode. But when I use the report in my VB.NET 2008 Project it says the following:
[Code]...
I need to get data from reports fields to open others windows forms or other reports, How I can get the values of reports fields to pass to local C# o VB.net variables? After many time ... With this upgrade making click on any Textobject on the Report the ClickPage event fire and in that sub is possible to get the Textobject data. You have to upgrade to Crystal Report 2008 SP 3.6, Link below [URL]
Private Sub crViewer_ClickPage(ByVal sender As Object, ByVal e As CrystalDecisions.Windows.Forms.PageMouseEventArgs) Handles crViewer.ClickPage
If Not IsNothing(e.ObjectInfo.Text) Then
Clipboard.Clear()
Clipboard.SetText(e.ObjectInfo.Text)
Me.CallBackForm(e.ObjectInfo.Name.ToUpper.Trim, e.ObjectInfo.Text)
End If
End Sub
I have tested my code in order to pass single value to single parameter field in crystal report from VB.NET Form, it is ok but the problem is that I want to pass multiple values to only one parameter field called "Product Name" and it displays only one last record.
I want to display like this
Receipt : 0001 Product Name
pencil
pen
stamp
book
[Code]....
I already set parameter field "productname" for allowing to multiple values, but it is still the same.
i have stored the sort field parameter value in the variable szYes_No.I have to pass this value to crystal report, i used the code given below but not work--
Dim FieldDef As FieldDefinition
FieldDef = frmReportDisplay.cryRpt.Database.Tables.Item(0).Fields.Item(szYes_No & "{REP_i_fORMAT.Mem_Name}")
[Code]....
how can i pass sort field parametr to crystal report.
I have created custom paper Size "XPaperSize 15 x 12" in Printers - File - Sever Properties. In VB .net 2005 I am trying to set custom Paper Size for Crystal Report. My problem is when I run report from Vb .net, Crystal report viewer showing correct preview for custom paper size but when I give print command it's print default printer paper size e.g. Letter size.
Here's the code I'm using to print:
Dim ObjCrReport as new ReportDocument
ObjCrReport.SetDataSource(ObjPrintDataSet.Tables("PrintData"))
SetReportPageSize("XPaperSize 15 x 12", 1) ' call Procedure for setting Custom Paper Size
End Sub
[Code] .....
If I used "myAppPrintOptions.PaperSize = PaperSize.PaperLegal" then print preview & Printing coming correct. Why it's printing Letter Size where Crystal preview showing custom paper size preview? & How to set Crystal Report Printer Paper Size?
I m using .net , I create some temporary tables at run time, how to print these table data thru crystal report
View 1 RepliesI have the code I am using below. On 3.5 framework Access 2003 database vb net 2008
I already have the database created but need to be able to add Tables and fields with the correct datatypes. So far it's not working but i don't know why or where the error is.
Private Sub MDIParent_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Try
[Code].....
I have few crystal 10 reports with default to a server & database during crystal design time (server=SRV1, DB=Pub1). And, i calling these report from VB. net application with a config.ini define my server & DB . Recently,i hv clone the same reports but extract from different server & Database name (Server=Srv2,DB=Pub2, the tables & fields are still same ) i have created a config.ini which contain my server, database, uid & pwd. And, when i execute these cloned report , they still point back to the origin server which was server=SRV1, DB=Pub1.
My coding :-
Imports CrystalDecisions.Shared
Imports CrystalDecisions.CrystalReports.Engine
Private Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs)
[Code].....
Anyone 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 RepliesI have to create a report with crystal reports in my application.my reports is based on a table in my database.As I've seen in the crystal reports designer, I have to add database to the report, and then I can pick the table and fileds that I need in my report.This is a quick and good when I use only one database type (for example Oracle or SQL Server)My questions are:How can I use the same report when my app is on two databases types? (Part of the customers I have use SQL Server, and part of them use Oracle DB)?
View 6 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 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 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 RepliesI am developing a vb.net windows application with crystal report and ms access. My database is stored in bin folder. I cannot bind database to report after deployment. How can I set the database location in report?
View 3 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.
i want to put my images saved as byte from the database to crystal reports.
View 3 Replieshow 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].....
dynamically passing image to crystal report from a disk in vb.net 2005
View 1 Repliesi 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 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 visual studio 2005 to develop a form with a combobox passing a value into the parameter of an embedded crystal report. Why it keeps prompting me for a database login every single time you try to run the report with a different combobox selection.
Here is my code:
private Sub Form1_load...
Dim ConnName As String
Dim ServerName As String
Dim DBName As String
Dim user As String
Dim pass As String
[Code] .....
I looked at this previous posting [URL]. I couldn't find where a CMC was to disable the prompt.
I am using VB.Net and crystal Report in VS2008. On Crystal Report I have a database(SQL20005) Column "Address".
I have used "Can Grow" option for that Column to change. But it resizes Vertically. I want to change its Width as Address have different data.
i am semester 2 in the "system information", as usual just like in semester 1, this hardcore lecturer just has some way to make us difficult he is giving us a one semester long assignment, and as you probably can see.i got mysql as my database to making a hotel system application.
1.now i am stuck with how to connect "crystal report" with mysql database table??
2.after connected, how shoud i display it?.
I 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?
delete a record in a database table in crystal report, after the report had been view from the new page and when the page is close.
the report is done in vs2008 c#.
I recently download/Installed Crystal Report for Visual Studio 2010 to work with Visual Studio 2010 Prof. Database from SQL Sever 2008 Express. Now my problem is when I run Crystal Report Viewer - Windows form : 1st message Database Login request and otherwise WRONG RECORDS DISPLAYING which I have not in my database table.
do print reports for my new Windows Application.