Hi,
I hve a problem with accessing data out of a database and having it show up in a crystal report. I am using a SQL query to pull the data out of the database but my problem is it pulls all of the data ou in the report. The query in itself works since I use the same query to load data into my program in which gives me the correct data. So far I have this in code in the program to load the crystal report:
RptReport1.WindowState = crptMaximized
RptReport1.ReportFileName = App.Path & "\Stats.rpt"
RptReport1.DataFiles(0) = pDatabase.Name
RptReport1.SQLQuery = "SELECT * From Clients, Results Where Clients.AccountID = Results.RAccountID ORDER BY RDate"
RptReport1.Destination = crptToWindow
RptReport1.Action = 1
Is there something in Crystal Reports I need to do as well? I have tried the SQL function in crystal reports but am not sure how to use it to get it to work properly. Any help would be greatly appreciated and thanx in advance.
Mike
