[Eyeballs]

Hi there. My question is how can someone make changes to many Crystal report designers dynamically, preferably through VB? We have about 200 Crystal Rpt files that are going to have to have their Datasource Locations changed (new Server, although the database name and corresponding Stored Procedure names will be the same). Is it possible to do this thru a VB routine and have the files saved & verified with the new data sources?

Thanks to anyone who knows the answer and is willing to type it in here!

[amit0287]

hi
I am not able to generate crystal reprot in vb 6.0
Iam using ms access2003 database
when i am trying to genrate the report blanl report is generated
even if the database contains the data
the database which i am using is saved in the server machin
Private Sub PRINT_Click()
str1 = "delete from tempslip"
db.Execute str1

str2 = "select * from tempslip"
Set rs1 = db.OpenRecordset(str2)
'Do While Not rs.EOF = False
rs1.AddNew
rs1!emp_name = cmbname.Text
rs1!esic = txtesic.Text
rs1!pfno = txtpfno.Text
rs1!Month = Combo1.Text
rs1!days = txtdays.Text
rs1!basic = txtbasic.Text
rs1!hra = txthra.Text
rs1!conv = txtconv.Text
rs1!education = txtedu.Text
rs1!medical = txtmedical.Text
rs1!other = txtother.Text
rs1!lta = txtlta.Text
rs1!special = txtspecial.Text
rs1!ctc = txtcosttothecompany.Text
rs1!pf = txtpf.Text
rs1!pt = txtpt.Text
rs1!income = txtit.Text
rs1!esicno = txtesicno.Text
rs1!loan = txtloan.Text
rs1!others = txtothers.Text
rs1!deduction = txttotdeduction.Text
rs1!netsalary = txtnetslaary.Text
rs1!Year = Text1.Text
rs1.update
rs1.Close
CrystalReport1.ReportFileName = ""
CrystalReport1.Reset
CrystalReport1.Connect = "\\SERVER2\d\database\pd1.mdb"
CrystalReport1.ReportFileName = App.Path & "\slip.rpt"

' CrystalReport1.DataFiles(0) = App.Path & "\pd.mdb"
'CrystalReport1.ParameterFields(0) = "Param1;Main Report Param;True"
CrystalReport1.Destination = crptToWindow
CrystalReport1.Action = 1
this is the code i am usin

pls help me as soon as possible

[tweety0012coo]

hello....

i want to ask if crystal report 4.2 or 8 or 11 is compatible with MYSQL?

if yes, how can i connect to my database?

your response in highly appreciated...

THANK YOU

[Amben]

kobebryant, on 5 Feb, 2008 - 02:36 AM, said:

wadddddddddduuuuup puto! musta na pare?pwede bang magtanung?salamat!!!
si eldrin yaos may sarili ka pa forum dito ha astig hehehe!

musta bro?astig may sarili ka pa forum panel ha hehehe!

are you guys a Pinoy?

Wow, nice one, it helps a lot to some students who are doing their thesis project.

Nice one....

[Amben]

tweety0012coo, on 6 Nov, 2008 - 07:21 PM, said:

hello....

i want to ask if crystal report 4.2 or 8 or 11 is compatible with MYSQL?

if yes, how can i connect to my database?

your response in highly appreciated...

THANK YOU

I hope it is possible, coz i'm also doing my project with that PL and Database

but the problem is that, my vb 6.0 has no Crystal Report, anyway, where can i download a free crystal report 4.2 or 8 or whatever version for me to try if it is possible to do that thing?

plz send me an email if you do know those thing @ LegendaryKnight@rocketmail.com.

It would be a great help if anyone knows about it.

[hamsakm]

hello,
Please give me the link of Crystal Report 8.5 and serial key with reg.code.
Give it to my email.My E-mail ID:hamsakm@gmail.com

[darkoragon]

jeff_sibal, on 9 Apr, 2007 - 10:44 PM, said:

Hi guys! If you have problems with crystal reports 8.5 and visual basic 6, please send me your message, I'll see if I could possibly HELP!

Thanx!


Jepoy
V@$

hello.. i have something to ask.. i want your reply asap? how to cnect vb to crystal report?




[code]

[darmawan6801]

jeff_sibal, on 9 Apr, 2007 - 10:44 PM, said:

Hi guys! If you have problems with crystal reports 8.5 and visual basic 6, please send me your message, I'll see if I could possibly HELP!

Thanx!


Jepoy
V@$

[rkhunter]

jeff_sibal, on 9 Apr, 2007 - 10:44 PM, said:

Hi guys! If you have problems with crystal reports 8.5 and visual basic 6, please send me your message, I'll see if I could possibly HELP!

Thanx!


Jepoy
V@$

Hi Jepoy,

I'm new from VB6 and im planning now to use CR8.5 can you help where to download CR8.5 developer edition? any tips?

thanks
rk

[cry]

jeff_sibal, on 9 Apr, 2007 - 10:44 PM, said:

Hi guys! If you have problems with crystal reports 8.5 and visual basic 6, please send me your message, I'll see if I could possibly HELP!

Thanx!


Jepoy
V@$

cry said:

hi my problem is how to connect the seagate crystal report in vb6 and i have another problem i can't connect the microsoft access in vb6, displaying in listview can you help me

cry

[ashish_s0102]

jeff_sibal, on 9 Apr, 2007 - 10:44 PM, said:

Hi guys! If you have problems with crystal reports 8.5 and visual basic 6, please send me your message, I'll see if I could possibly HELP!

Thanx!


Jepoy
V@$

[jeff_sibal]

Hi selvakumarkrishnasamy,

To run a Crystal report in your VB6 application, first you need to include (check) the Crystal Reports in your VB 6 Components (located in the Designer tab as you open the Components : Project\Components\Designer)

then add the crystal reports "Object" into your "form" from your VB6 components panel (located in the left side portion)

create a command button (Command1) or you may use the Edit Menu of VB6 for a better Report generation interface.

then try this code:

Public Sub Command1_Click()
frmYourFormName.NameofCyrstalreportObject.SelectionFormula = ""
            frmYourFormName.NameofCyrstalreportObject.SelectionFormula = "{nameofquery_in_msacess.fieldname}= '" & tempnameto_filter & "'"
            frmYourFormName.NameofCyrstalreportObject.ReportFileName = App.Path & "\yourDirectory\NameofYourCR_Report.rpt"
frmYourFormName.NameofCyrstalreportObject.WindowShowPrintSetupBtn = True
frmYourFormName.NameofCyrstalreportObject.WindowShowRefreshBtn = True
frmYourFormName.NameofCyrstalreportObject.WindowState = crptMaximized
frmYourFormName.NameofCyrstalreportObject.Action = 1
End Sub

Note:

Line 1 is a standard starting syntax

Line 2 can be use if you want to filter a specific group of item or field in your report, using this line the VB 6will filter your desired item accordingly.

Line 3 is the report path

Line 4 will include a Printer Setting button in your CR report

Line 5 will include a refresh button in your CR report. It is useful to get the real time values/items/fields in your report

Line 6 will make your report into maximum view

Line 7 triggers the report generation


Happy Programming!


Jeff Sibal
Programmer

This post has been edited by macosxnerd101: 09 November 2010 - 07:10 AM
Reason for edit:: Added code tags.