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 want to ask how to display the fields in Crystal report from different tables. I have this line of code:
[Code]...
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 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 am having a Visual Studio 2008 but it not install with crystal report when i open add new item-> its didnot contain Crystal Report how can i add crystal report and make crystal reports in visual studio 2008 how i install crystal report with visual studio 2008 only crystal reports 2008 install and its open with visual studio 2008 when we click Project->Add New Item-> and crystal reports shows in thiis file
View 1 RepliesI m using .net , I create some temporary tables at run time, how to print these table data thru crystal report
View 1 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 try to build a system that need me to use crystal report, but i don't know how to use it, i build my project using vb.net version 2008 and database microsoft sql2000.
View 2 RepliesBefore I post this question, I would like to introduce my self first to the community. I'm Instructor and a Filipino programmer. From Vb. 6.0 I migrate to Vb 2008.
[Code]...
ReportDocument cryRpt = new ReportDocument();
//cryRpt.Load("C:\Documents and Settings\Vaibhav\Desktop\powertech\report2.rpt");
cryRpt.Load("E:\powertech\crystalreport1.rpt");
[code].....
I try to print the Crystal Report, without Report Preview and following codes I used.
Dim MISObjRpt As New CrystalReport1
MISObjRpt.SetDataSource(Ds1.Tables(0))
If PrintDialog1.ShowDialog = Windows.Forms.DialogResult.OK Then
PrintDialog1.AllowSomePages = True
MISObjRpt.PrintOptions.PrinterName = PrintDialog1.PrinterSettings.PrinterName
MISObjRpt.PrintToPrinter(PrintDialog1.PrinterSettings.Copies, False, PrintDialog1.PrinterSettings.FromPage,
PrintDialog1.PrinterSettings.ToPage)
End If
But the problem is I can't select the PAGES RANGE. So how to solve this problem?
I have created a crystal report with two tables, one for company details as a header and one for report details as a filler. I have been trying to get dates to filter the report and have done so successfully but the header part of the report does not show any data at all. I have binded the crystal report using a report viewer. Here is code I use to call crystal report. Lets say second table is called Company details, how do I get this information to show up with rescinded documents information. I have attached a copy fo what my final report will look like.
Private Sub BtnOpen_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnOpen.Click
Dim sqlsearch As String
Dim con As New OleDb.OleDbConnection
Dim hugh As Date = DateTimePicker1.Value.Date
Dim hugh2 As Date = DateTimePicker2.Value.Date.AddDays(1)
[Code] .....
How to use crystal report with VB.NET by passing the SQL statement? Try to pass sql statement to a crystal report in vb.net 2008 after creating a dataset with it yet it will load the report but not showing the records
View 3 RepliesI plan on designing a Crystal Report, and then calling it through VB.NET code. Will the end-user need a Crystal license in order to use the crystal report part of the program?
View 1 RepliesUntil recently my reports working ok, only after I convert it to vs 2008 all my reports not display in proper manner or shown error.The most noticeable is previously to hide the Pageview control in crystalreportviewer can be done easily. After this conversion all the codes failed me :(Another error is Invalid Pointer or Invalid Parameter. All report was working fine in VS.2003
View 1 RepliesIs there any way to set the crystal report data source location to the application.startup-path?
have a nice day
in Crystal reports ( crystalreport1 )how can i change the textbox text in report header ( say for Eg textbox3 ) to some thing of my own,during run time for visualization i can say, i need to set the report header textbox that states the report filtered date, which can be set while the run time only
View 4 Repliesafter that, I try to add crystal report 2008 component to VB.net .By right click on toolbox choose items and checked crystal report viewerIt doesn't seem works, there is no crystal report 2008 component on toolbox
View 17 RepliesWhen i pass the parameter and run the report it works fine as i close the form it closes the form is there any way so that i should be able to close the crystal report viewer and pass the parameter again and should be able to view report again.
View 1 RepliesI got a problem I want to print a report which is receipt having size 3 x 4 cm. i am unable to resize crystal report. i am using crystal report coming with visual studio.net 2008.
View 1 RepliesI wish to add a progress bar in code. I have a sample here but with the "Cursor.Current = Cursors.WaitCursor" to notify the user that it running.. however a progress bar maybe can make it more noticeble. how can i do that.
Private
Sub CmdOK_Click(ByVal
sender As System.Object,
[code]....
My problem is, when deploy vb.net 2005 with crystal report on Windows Server R2 2008, the report can't load it show blank. i'm using AxCRViewer91 component.
the DLL's;
AxInterop.CRVIEWER9Lib.dll
Interop.CRAXDRT.dll
Is it compatible on Windows Server R2 2008 x64?
I have "Visual Studio 2008 Standard Edition" and "Crystal Reports XI Developer edition".I have to integrate crystal reports in my application. I am fine developing the reports using the "Crystal Reports IDE" but not sure on how can I integrate those reports into my application.I have downloaded and installed the reportviewer control but not sure how to use it for crystal reports.
View 1 Repliesdelete 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 have created an application using vb.net 2008 and for reports Crystal Reports Basic for Visual Studio 2008 but the problem is, when I run the application in another machine away from developing box, I get the Load report failed notice. I don't have any idea on how I should approach this issue. I tried installing the CRRedist2008_x86 and CRRedist2005_x86 but still the problem won't go away.
View 3 RepliesI'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 am studying crystal report with visual studio 2008. I knew OLEDB, ADO.Net And ADO connections etc. But whatever connection that we must assign data sources. I want to non-configured and assign data sources as like data-grid. In the data-grid, we can configure data field name and generate data assignation in runtime. Can I do this for report or not. If I can this, tell me how can I do this.
View 1 Repliesi have a vb .net 2008 console application that generate a pdf based on a report made in crystal report (.rpt) developed on a local machine, it work fine but when i installed the same application on the server and its opened in the vb .net 2008 installed in the server the fonts looks differents (they both have arial inline, i dont use cssclass on the project) and some controls have different sizes, so i have to make differents changes in the proyect.I check the crystal report.engine dll and are the same in both vb. studio why it presents the differents between the applications?
[URL]
I created an application with some Crystal Reports. I published the application and installed it on the machine which is my develop machine. This machine has Vista on it and is runnig the application 100%. When I install it on a different machine with windows XP, it runs fine until it tries to load the mybase.new. It generates a windows error with no description.
This is a system generated sub:
[CODE]......................