WHERE Pt_User_Defined_Fields.Account Is Null ON `Sheet1_`.`Account_No`= Pt_User_Defined_Fields I tried the following in the Add Command under the path of the Excel file of the sub report: This is me again, the one who posted this thread to ask. RE: Database Connector Error: ‘42S02:[S Hviezdoslav (TechnicalUser) When I try to use the Add Command for the sub report to query to show the accounts in the Excel file that do not have a row in the SQL Server table, I get the Database Connector Error: '42S02:Invalid object name 'Sheet1_'.'.ĭoes anybody know by chance how I can resolve this? I would be very grateful. The main report works I guess because I am linking (inner joining the XLS file and SQL Server table where each field equals) via the Database Expert.
#Odbc excel driver invalid use of null Pc#
The real path on my PC and the real name of the Excel file is as follows:Ĭ:\Users\michaelw\Desktop\My_CR_ShowPatientsNotInUserDefinedTbl\ Second_And_Last_Excel_File_For_Language.xls When I click OK in the Add Command To Report for the sub report after entering the above query, I get the following error:ĭatabase Connector Error: '42S02:Invalid object name 'Sheet1_'.' I am trying for the sub rpt to enter into Add Command the following to link the XLS file and the SQL Server table with the following code:
I want the sub rpt to use the same Excel file and the same SQL Server table. 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 equal) in the Database Expert and this produces the proper results for this main report. I have a Crystal Report and in it is a sub report.
0 kommentar(er)
