JAMGODZ
Jul 13th, 2008, 09:05 PM
Hello to ALL Expert! Good Day!
This is my first post and i hope someone will reply me... i have a big problem regarding the crystal report 8... i have a created a report file and i want to used that file to my 11 tables in one database, my problem is how do i change the table name and its field that ive already inserted to the report. as what i have read here... they used .datafiles(index) to change the table name, but how do i change the fields? or its value? please i really i need an advice/suggestion... heres my sample code:
With CR1.
.Reset
.ReportFileName = App.Path & "\Reports\" & srcReportFileName
.Connect = "DSN=" & App.Path & "\BUDGET_SYSTEM.dsn;"
.DataFiles(10) = srcDatabase
.SQLQuery = "SELECT * FROM " & myTable & " WHERE " & myConditions
.WindowTitle = "Sample"
.ParameterFields(0) = "prmBusAdr;" & myCompanyAddress & ";TRUE"
.PageZoom 100
.Action = 1
End With
:confused:
This is my first post and i hope someone will reply me... i have a big problem regarding the crystal report 8... i have a created a report file and i want to used that file to my 11 tables in one database, my problem is how do i change the table name and its field that ive already inserted to the report. as what i have read here... they used .datafiles(index) to change the table name, but how do i change the fields? or its value? please i really i need an advice/suggestion... heres my sample code:
With CR1.
.Reset
.ReportFileName = App.Path & "\Reports\" & srcReportFileName
.Connect = "DSN=" & App.Path & "\BUDGET_SYSTEM.dsn;"
.DataFiles(10) = srcDatabase
.SQLQuery = "SELECT * FROM " & myTable & " WHERE " & myConditions
.WindowTitle = "Sample"
.ParameterFields(0) = "prmBusAdr;" & myCompanyAddress & ";TRUE"
.PageZoom 100
.Action = 1
End With
:confused: