Results 1 to 2 of 2

Thread: [Crystal Report 8] How to change table... please

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Dec 2007
    Posts
    24

    [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


  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: [Crystal Report 8] How to change table... please

    Moved to Reporting

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width