|
-
Jul 13th, 2008, 09:05 PM
#1
Thread Starter
Junior Member
[Crystal Report 8] How to change table... please
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
-
Jul 14th, 2008, 06:07 AM
#2
Re: [Crystal Report 8] How to change table... please
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|