Skip to Content
0
Former Member
Jun 27, 2011 at 10:08 PM

Command DataSource - Invalid tablename

22 Views

This is my first time using a Command DataSource. I had a need to create a command ds. Working on SQL Server 2005, I needed to have a UNION between two tables along with a join or two on each one of the tables. I was getting the proper information when I was using the MS Management Studio.

In Crystal XI, I did an ADD->Command and inserted my running code. I renamed the datasource from 'command' to 'CalData'. In some formula fields I attempted to use fields from the table as in ( DayOfWeek ({CalData.startdate}).

When I try to run the report I get an error:

Error in compiling SQL Expression :

Failed to retrieve data from the database.

Detail: ADO Error Code: 0x

Source: SalesLogix OLE DB Provider

Description: Invalid table name..

Crystal then takes me back to the formula field which contains "DayOfWeek ({CalData.startdate})", the only statement in that formula.

I hope someone can help me out on this one.

Thanks,

DMACK1