Search results for query: *

Hello, I have figured out how to do what I wanted. In the main report, I have what I had in the first place. I connect the XLS file to the SQL Server table via the Database Expert and I linked the XLS file's Account field to the SQL Server table's Account field with Inner Join, Not...

This is me again. I am using Crystal Reports version XI. Hviezdoslav

- - - This is me again, the one who posted this thread to ask. I tried the following in the Add Command under the path of the Excel file of the sub report: SELECT `Sheet1_`.`Account_No` FROM `Sheet1$` `Sheet1_` LEFT OUTER JOIN Pt_User_Defined_Fields ON `Sheet1_`.`Account_No`=...

Greetings, I do not have access to the SQL Server. I have a Crystal Report and in it is a sub report. The main rpt has an Excel file (named Sheet1_ in Crystal Rpt even though on my desktop the name of the XLS file is different) and a SQL Server table linked (inner joined where two fields...

Thanks very much to you, LB! I tried what you suggested and it works. I kept the Details A of the main report for the first Excel file. I deleted from the main report the Details B that had the second and unrelated Excel file. I deleted the 2nd Excel file that was connected to the main...

Please bear with me because I am very new to Crystal Reports. I am using version XI. I have a report that has two Excel files as data sources. I have hidden everything in design view except Details A and Details B. On Details A, I have the 3 fields from the first Excel file. On Details B, I...