When I define the recordsource for this report, it continually adds WHERE 1 = 2 to the end of the MS SQL statement. I have defined the connection by the following steps to try to get this WHERE 1 = 2 thing to stop being added to the string:
Anyone know where or how I can find why alpha is appending a WHERE condition to my datasource??
Note: I have been using Alpha since 2014 and use it frequently.
AlphaCapture.png
- Initially I defined the DataSource by selecting an SQL View from a Named Connection String. Then selected * all records. Preview data, shows 334 records. Then Finish.
- Then I tried Edit Datasource and then Define a new DataSource. defined the connection string Ad Hoc, selected an SQL View then selected * all records. Preview data, shows 334 records. Then Finish.
- Then I tried Edit Datasource and then Define a new DataSource. defined the connection string Ad Hoc, used custom SQL Statement (same as the SQL from the MS SQL View I was selecting earlier). Preview data, shows 334 records. Then Finish.
- Then I tried Edit Datasource and then Define a new DataSource. selecting an SQL View from a Named Connection String. Then selected each column individually, added a condition WHERE 1 = 1 (just to see if this would prevent Alpha from adding its own. all records). Preview data, shows 334 records. Then Finish.
Anyone know where or how I can find why alpha is appending a WHERE condition to my datasource??
Note: I have been using Alpha since 2014 and use it frequently.
AlphaCapture.png
Comment