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 Replies
How I can set a Textbox or the report header title programmatically at runtime?
Like as in a form - Me.text = "Sales Report"
Depending on how I query the report I'd like to give the report a descriptive report name.
Can I set custom paper size in my crystal report? For example, i want to show 8.5X5.5.
View 4 RepliesI need to print the bill and the paper size is 204 by 152 mm and its a continous paper. i did write the code as follows [code]i have done enough research but came with nothing thats why m posting here.I just need how to set custom paper size to crystal report.
View 7 RepliesI 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 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 am new in vb.net i am designing small application and i am adding reports to it.problem is that 1) in header i text at end of text i need to add zone number from database. like: This is header text " zone number"
zone number after header text from database or from a variable
I tried a lot of ways to change a text box value in crystal report. I faild....
THis is what I tried to do (with no success...)
crystalReport31.Section2.ReportObjects.Item("txtCompName").??? "sdaf" ??
crystalReport31.Section2.ReportObjects("txtCompName"). ??? = "sdaf" ??
crystalReport31.ParameterFields.Item(1).CurrentValues.Add("txtCompName") ' = "sdaf"
crystalReport31 it is the crystal report document object.
the title says it all, i want to have() this layout in crystal reports: how to do this?
View 2 Repliesexport crystal report into text format?
View 4 Repliesam 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 RepliesHow can i get the text object so that i can use it in formula editor?
View 1 Replieshow can i pass values from textbox to crystal report? i wanted the value of the textbox willbe shown or my report.[code]
View 4 Repliesi want same custom header on every page when i print my report, how can i?
View 3 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 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 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 Repliesim using crystal report in vb 2005. how to import the data from the textbox or label on the form to the text on crystal report using a button.
View 2 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
after 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 Replies
